Explanation an application program attempted to use a dbrm or package that was not found location namecollection iddbrm nameconsistency token the package that was not found the collection id is blank if the current packageset special register was blank for the local program execution plan name. Check whether the plan given in jcl is same as the one you bind with your program suppose if you bind plan that updates database and ve used the one that just fetches from database then this conflict would return 805. Regardless of whether the application program provides an sqlca or a stand alone variable sqlcode is set by db2 after each sql statement is executed db2 conforms to the iso ansi sql standard as follows if sqlcode 0 execution was successful if sqlcode 0 execution was successful with a warning if sqlcode 0 execution was not successful. Noapplog error sqlcode 805 sqlstate51002 thrown when a translation map connects to a db2 z os pool and executes sql statements too many concurrent open statements
How it works:
1. Register a Free 1 month Trial Account.
2. Download as many books as you like ( Personal use )
3. No Commitment. Cancel anytime.
4. Join Over 100.000 Happy Readers.
5. That's it. What you waiting for? Sign Up and Get Your Books.