View previous topic :: View next topic
|
Author |
Message |
pcoreddy
New User
Joined: 14 Mar 2007 Posts: 24 Location: Mysore
|
|
|
|
How to solve the DB2 SQL code -805
I am getting SQL error code -805 when i am running the COBOL DB2 program
plz can anyone help how can i solve it |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
Your reason code for a more specific answer.
Quote: |
An application program attempted to use a DBRM or package 'location-name.collection-id.dbrm-name.consistency-token' that was not found.
Collection id is blank ('location-name..dbrm-name.consistency-token') if the CURRENT PACKAGESET special register was blank for the local program execution.
The REASON token is blank if the length of 'location-name' is 16, the length of 'collection-id' is 18, and the length of 'dbrm-name' is 8 due to the length of SQLERRMT. |
|
|
Back to top |
|
|
pandey_nitin78
New User
Joined: 08 Aug 2005 Posts: 7
|
|
|
|
-805 shows Bind problem, Please rebind your program in the correct instance and make sure you give the correct DBRM library name so that your bind JCL picks up DBRM from there.
Check here for -805 error:
/references/a2.html |
|
Back to top |
|
|
Shobana Bhaskar
New User
Joined: 02 Mar 2007 Posts: 35 Location: Pennsylvania, US
|
|
|
|
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. |
|
Back to top |
|
|
letmeknow
New User
Joined: 10 Dec 2005 Posts: 5 Location: chennai
|
|
|
|
Check whatever DBRM modules requires for your program are included in the PLAN or not. If not include all the DBRM'S required and REBIND it. |
|
Back to top |
|
|
nayaksidd
New User
Joined: 22 May 2007 Posts: 16 Location: bangalore
|
|
|
|
Hi all,
I am posting the error which I am getting while running the jcl afetr compilation of my application.I have tested all the possible steps to resolve -805 its like:
1)deleting dbrm and loadlib
2)pointing directly to production loadlib
3)chk the run jcl
following error i am getting=>>>>>
Code: |
DSNT408I SQLCODE = -805, ERROR: DBRM OR PACKAGE NAME DB2DFMR.FPD4COL01.PSPL85
0.17E5DF92007E840F NOT FOUND IN PLAN |
|
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello and welcome to the forums,
A couple of suggestions. . .
First, when you post a question (even if it is similar to an existing topic), please start a new topic.
Next, please read the previous discussion in this topic. Your error is most likely caused by a bind problem or naming the wrong plan when you execute. It may help to talk with your database support people.
Good luck and we're here for followon questions |
|
Back to top |
|
|
Vishwamurthy
New User
Joined: 11 Mar 2008 Posts: 57 Location: India
|
|
|
|
I get a similar STATUS: -805 error. Below are the error details:
DBRM OR PACKAGE NAME
DB2SSID..PROGRAM.<JUNK> NOT FOUND IN PLAN PROGRAM.
I tried 1. Deleting the test cobol, 2. Re-generating the cobol, 3. External bind but it doesn't help me in any way. Same old error message.
Please help me.. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
I'll just repeat what Dick has stated in year 2007. |
|
Back to top |
|
|
Akatsukami
Global Moderator
Joined: 03 Oct 2009 Posts: 1788 Location: Bloomington, IL
|
|
|
|
Vishwamurthy wrote: |
I get a similar STATUS: -0805 error. Below are the error details:
DBRM OR PACKAGE NAME
DB2SSID..PROGRAM.<JUNK> NOT FOUND IN PLAN PROGRAM.
I tried 1. Deleting the test cobol, 2. Re-generating the cobol, 3. External bind but it doesn't help me in any way. Same old error message.
Please help me.. |
Please
- Start a new thread, instead of tagging on to one that been quiescent for four and a half years.
- Learn that hexadecimal data is not junk. You're playing in the big boys' sandbox now.
- Show your package and plan bind control cards and sysouts.
|
|
Back to top |
|
|
|