SQLCODE -805 encountered in a CICS/DB2 program



IBM's flagship relational database management system

SQLCODE -805 encountered in a CICS/DB2 program

Postby huxianjun » Thu Mar 09, 2017 7:48 am

Hello

I was trying to recompile an existing online DB2 program with Xpediter ON, so that to debug the program; however, after re-compiled the program, I got SQLCODE -805 after run it.

Here's how I recompiled the program:
1. Compiled the program with the DBRM generated
2. Bound the DBRM into a package used for online program in our testing environment
3. Further bound the package to the plan used for online program in our testing environment
4. Login the CICS testing region and NEWCOPY the program
5. Debug the program by Xpediter, then got SQLCODE -805 upon the 1st SQL statement was executed

Can anyone advise what could be the rootcause? I'm thinking, other than NEWCOPY the program, do I've to do anything to refresh the plan also (since it's bound again) ?

Thanks, Roy
huxianjun
 
Posts: 23
Joined: Thu Jul 21, 2016 10:10 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SQLCODE -805 encountered in a CICS/DB2 program

Postby huxianjun » Thu Mar 09, 2017 8:48 pm

Update:

I've located the rootcause - when bound the DBRM, I specified the wrong DB2 subsystem which is for batch testing(I thought it's for online also), after I changed to use the subsystem for CICS testing, the issue is solved!

So, please ignore the post, thanks!
huxianjun
 
Posts: 23
Joined: Thu Jul 21, 2016 10:10 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SQLCODE -805 encountered in a CICS/DB2 program

Postby Terry Heinze » Thu Mar 09, 2017 8:53 pm

Oh, we won't ignore it. Someone may come along and have the same problem and your solution might be theirs also.
.... Terry
Terry Heinze
 
Posts: 239
Joined: Wed Dec 04, 2013 11:08 pm
Location: Richfield, MN, USA
Has thanked: 12 times
Been thanked: 11 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post