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
 

 

SQLcode -805 when running the cobol-db2 program

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

New User


Joined: 11 Mar 2008
Posts: 57
Location: India

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

I get a similar STATUS: -0805 error. Below are the error details:
DBRM OR PACKAGE NAME
DB2SSID..PROGRAM.<HEX> 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..

I don't understand "Show your package and plan bind control cards and sysouts". Bind is always successful..
Back to top
View user's profile Send private message

Akatsukami

Global Moderator


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

PostPosted: Wed Dec 14, 2011 8:09 pm    Post subject: Re: SQLcode -805 when running the cobol-db2 program
Reply with quote

Vishwamurthy wrote:
I don't understand "Show your package and plan bind control cards and sysouts". Bind is always successful..

In that case, you must be only imagining the -805 SQLCODE. I can't help you, as I'm a software developer, not a psychiatrist.
Back to top
View user's profile Send private message
GuyC

Senior Member


Joined: 11 Aug 2009
Posts: 1280
Location: Belgium

PostPosted: Wed Dec 14, 2011 8:25 pm    Post subject:
Reply with quote

Maybe you are running with an old load module ?
or against the wrong subsystem ?
Back to top
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 662
Location: Pennsylvania

PostPosted: Wed Dec 14, 2011 9:02 pm    Post subject:
Reply with quote

From my experience, the number one cause of a -805 is:

The library concatenation used in the Bind (step 3 for you above) does not match the library concatenation used in your Batch Job or CICS region setup.

Show the JCL you used for your external bind and your Batch run.
Back to top
View user's profile Send private message
don.leahy

Active Member


Joined: 06 Jul 2010
Posts: 647
Location: Whitby, ON, Canada

PostPosted: Wed Dec 14, 2011 10:12 pm    Post subject:
Reply with quote

Possibly the online region(s) needs to be refreshed to ensure that the latest version of the load module is loaded. This often happens in IMS MPRs. (I don't speak CICS).

However, the TS hasn't given us any information about the execution environment, so this is just speculation.

I was going to suggest that this question would be more suited to the beginner's forum, but then I remembered that I have known veteran programmers whose solution to every -805 problem was to keep binding the program over and over in the hopes that it would eventually work.
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 RULES(NOEVENPACK) in cobol jackzhang75 COBOL Programming 5 Wed Mar 29, 2017 12:47 am
No new posts Determine Region with max bandwidth f... seahawk789 COBOL Programming 3 Mon Feb 27, 2017 8:26 pm
No new posts SQL query not working in Cobol program. CuriousMainframer COBOL Programming 14 Wed Feb 22, 2017 5:56 pm
No new posts Execute TSO ACF commands from COBOL-I... supreethi.srid TSO/ISPF 0 Tue Feb 21, 2017 5:19 pm
No new posts DB2 SQL Error: SQLCODE=-440, SQLSTATE... kishpra DB2 1 Sat Feb 18, 2017 2:31 am


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