IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

-805 sql code from db2 optimizer


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
yugendran

New User


Joined: 14 Dec 2007
Posts: 51
Location: indore

PostPosted: Thu Aug 13, 2015 7:59 am
Reply with quote

Hi guys

I am trying understand the below issue

I am adding a new package to a collection. the collection is already present in plan that I m gonna execute. So I didn't bind the plan. However I end up with -805 sql error. On looking at the logs I found that -805 is from package CAODDB8S.timestamp which is a ca optimizer ii package.

I am confused, till now my understanding is that no need to bind the plan if we add the package to a collection which is already present in plan Pklst.

btw, when I did the bind plan it solved the issue. but need to know it resolved the issue.

Thanks.
Yugendran
Back to top
View user's profile Send private message
RahulG31

Active User


Joined: 20 Dec 2014
Posts: 446
Location: USA

PostPosted: Thu Aug 13, 2015 10:26 am
Reply with quote

This should help. Look at reason code 3 :

Quote:
The DBRM of the version of the application program being executed was not bound. (A package with the same consistency token as that of the application program was not found.)
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts run rexx code with jcl CLIST & REXX 15
No new posts Compile rexx code with jcl CLIST & REXX 6
No new posts REXX code to expand copybook in a cob... CLIST & REXX 2
No new posts VSAM return code 23 - for a Random read COBOL Programming 4
No new posts Monitoring production job progress. N... JCL & VSAM 4
Search our Forums:

Back to Top