Page 1 of 1

SQLCODE -805 encountered in a CICS/DB2 program

PostPosted: Thu Mar 09, 2017 7:48 am
by huxianjun
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

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

PostPosted: Thu Mar 09, 2017 8:48 pm
by huxianjun
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!

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

PostPosted: Thu Mar 09, 2017 8:53 pm
by Terry Heinze
Oh, we won't ignore it. Someone may come along and have the same problem and your solution might be theirs also.