SQLRPGLE gets SQLCODE 08003

370 pts.
Tags:
IBM i
SQLRPGLE
I have an SQLRPGLE program running interactively, and i am intermittently getting 08003 The connection does not exist.SQLCODE -900. I am only accessing the local IBM i DB2 database. How does an SQLRPGLE connect to the IBM i databasese under wraps? Is it part of the /exec sql directive? Is there an IBM i log or function, view or table somewhere that i can check to figure out what is disconnecting the connection to the IBM i database from my SQLRPGLE program? I was thinking some other program might be issuing a disconnect or closes the database connection to the relational database of the IBM i ? No obvious entries in the interactive job's job log.   IBM i V7R2. Many thanks, Joel


Software/Hardware used:
SQLRPGLE, ibm i
0

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

Discuss This Question: 7  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.
  • Jpjawili
    i checked QHST log file and there were no entries related to disconnection to the database. The interactive job is still up and running but i am getting SQL08003 in my program dumps. 
    370 pointsBadges:
    report
  • ToddN2000
    It could be a number of things like a connection timeout or maybe a pooling issue or system setup parameter. Does the job fail at random times? We would need to see the program and how the SQL is being called and used. If your screen sits idle for an extended period it may be the connection times out. Then when you try and access the data since the last SQL select was issued the data is no longer there. 
    136,290 pointsBadges:
    report
  • ToddN2000
    @Jpjawili: you may want to take a look at these links if you havent already.
     
    for the 900 error

    for the 8003 error
    136,290 pointsBadges:
    report
  • Jpjawili
    Thanks @ToddN2000, i did saw these links when i was googling yesterday. 

    the problem is intermittent so its quite difficult to pinpoint the error, all i have are the job logs. I am reviewing the compilation spooled file and the job logs as i noticed that when the program ran, there is an SQL severity 30 error SQL0501 Cursor C1 not open. It could be that the cursor was closed because the connection to the relational database has been ended, but i did not encounter any CPI3E02 Connection to relational database &1 ended. in the job log before i got SQL0501 and eventually SQL -900 and SQL08003. 

    I will dig a bit deeper and let you know if i am ever able to figure this one out. Many Thanks!

    370 pointsBadges:
    report
  • Jpjawili
    I meant CPI3E04 Connection to relational database &1 ended, not CPI3E02 . My apologies. 
    370 pointsBadges:
    report
  • TheRealRaven
    I've seen a similar problem with native I/O, but that was in a server exit program. I can imagine a potential kind of scenario that could possibly result in what you see, though it's not very likely.

    Can you describe the job structure that your program runs in? Is it the top-level program, or is it called by others? Do you know if any of the XA APIs are involved anywhere in the stack?
    36,880 pointsBadges:
    report
  • Jpjawili
    Hi @TheRealRaven, 

    The SQLRPGLE program is called by other programs in the call stack, its not the top level program in the call stack. The program runs in an interactive IBM i 5250 job, running with *job level commitment control. All the programs in that interactive job's call stack is running in the default activation group.. There are no XA APIs in the call stack. 

    Also i think CPI3E04  was not in the job log because Message logging was set to *NOLIST. I will try to set it to *seclvl the next time i encounter it, its just that its really intermittent so a bit difficult to generate more detailed job logs that i could work on. 

    thanks!
    Joel

    370 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following

Share this item with your network: