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: 1755
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: 1281
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: 650
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
This topic is locked: you cannot edit posts or make replies. Cobol GUI (like Editor) Kala Mainframe COBOL Programming 14 Wed May 10, 2017 12:30 pm
No new posts IMS T-Pipe queue counts in a COBOL Pr... Siva NKK Kothamasu IMS DB/DC 0 Tue May 09, 2017 6:31 pm
No new posts COBOL Code Parsers and Lineage Establ... balimanja COBOL Programming 2 Tue May 02, 2017 3:30 am
No new posts Cobol upgrade - source code missing f... gthmrj IBM Tools 1 Wed Apr 26, 2017 6:04 pm
No new posts Running an REXX EXEC implicitly sho7hills CLIST & REXX 3 Thu Apr 20, 2017 8:14 am


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