Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

How to solve DB2 SQLcode -805

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
pcoreddy

New User


Joined: 14 Mar 2007
Posts: 24
Location: Mysore

PostPosted: Fri Mar 30, 2007 3:33 pm    Post subject: How to solve DB2 SQLcode -805
Reply with quote

SQLcode -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
View user's profile Send private message

William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Fri Mar 30, 2007 3:47 pm    Post subject:
Reply with quote

Explanation: An application program attempted to use a DBRM or package 'location-name.collection-id.dbrm-name.consistency-token' that was not found.
Go there with your reason code for a more specfic 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
View user's profile Send private message
pandey_nitin78

New User


Joined: 08 Aug 2005
Posts: 7

PostPosted: Fri Mar 30, 2007 6:18 pm    Post subject: solution for -805 Problem
Reply with quote

-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 this for more solutions for -805 error: http://ibmmainframes.com/references/a2.html#-805
Back to top
View user's profile Send private message
Shobana Bhaskar

New User


Joined: 02 Mar 2007
Posts: 35
Location: Pennsylvania, US

PostPosted: Thu Apr 05, 2007 6:10 pm    Post subject:
Reply with quote

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
View user's profile Send private message
letmeknow

New User


Joined: 10 Dec 2005
Posts: 5
Location: chennai

PostPosted: Mon Apr 30, 2007 9:15 pm    Post subject:
Reply with quote

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
View user's profile Send private message
nayaksidd

New User


Joined: 22 May 2007
Posts: 16
Location: bangalore

PostPosted: Thu May 24, 2007 4:36 pm    Post subject: -805 error unable to trace
Reply with quote

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
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu May 24, 2007 8:08 pm    Post subject:
Reply with quote

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 icon_smile.gif
Back to top
View user's profile Send private message
Vishwamurthy

New User


Joined: 11 Mar 2008
Posts: 57
Location: India

PostPosted: Wed Dec 14, 2011 5:07 pm    Post subject: Reply to: SQLcode -805 when running the cobol-db2 program
Reply with quote

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
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Wed Dec 14, 2011 5:40 pm    Post subject:
Reply with quote

I'll just repeat what Dick has stated in year 2007.
Back to top
View user's profile Send private message
Akatsukami

Global Moderator


Joined: 03 Oct 2009
Posts: 1755
Location: Bloomington, IL

PostPosted: Wed Dec 14, 2011 5:45 pm    Post subject: Re: Reply to: SQLcode -805 when running the cobol-db2 progra
Reply with quote

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
  1. Start a new thread, instead of tagging on to one that been quiescent for four and a half years.
  2. Learn that hexadecimal data is not junk. You're playing in the big boys' sandbox now.
  3. Show your package and plan bind control cards and sysouts.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am
No new posts SQLCODE-000000080N priya91 DB2 1 Mon Feb 01, 2016 4:35 pm
No new posts Need to understand SQLCODE = 12 rohanthengal DB2 3 Thu Nov 05, 2015 11:22 am
No new posts SQLCODE -922 in Batch-Cics program tr... kishpra CICS 2 Thu Sep 10, 2015 12:36 pm
No new posts SQLCODE -450 for stored procedure spoorni DB2 3 Fri Jan 16, 2015 2:45 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us