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
 

 

-805 SQLCODE IN CICS/DB2 APPLICATION PROGRAM

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> CICS
View previous topic :: :: View next topic  
Author Message
sushtare

New User


Joined: 05 Oct 2005
Posts: 1
Location: PUNE

PostPosted: Wed Oct 05, 2005 3:14 pm    Post subject: -805 SQLCODE IN CICS/DB2 APPLICATION PROGRAM
Reply with quote

HI
THIS IS MY FIRST QUERY ON THIS FORUM..HOPING FOR QUICK REPLY..
ME AND MY TEAMMATES ARE FACING THE PROBLEM OF ABEND -805....
DURING THE RUN TIME IN CICS/DB2 APPLN. PROG.......
WHILE EXECUTING THE PROGRAM IN CEDF MODE...USING TRANSACTION ID........WHEN IT COMES TO EXECUTE THE SQL QUERY IT ABENDS WITH THE CODE -805
PLZ MAIL THE SOLUTION TO THIS AS EARLY AS POSSIBLE
Back to top
View user's profile Send private message

Rupesh.Kothari

Member of the Month


Joined: 27 Apr 2005
Posts: 464

PostPosted: Wed Oct 05, 2005 3:47 pm    Post subject: Re: -805 SQLCODE IN CICS/DB2 APPLICATION PROGRAM
Reply with quote

Hi,

Reason for -805 error code

Code:
PROGRAM NAME location name.collection id.program name.consistency token NOT FOUND IN PLAN plan name


User responce.

Based on the above reasons, the programmer can perform the following operations to correct the error.
* Bind the program 'program name' as the member part of the application plan 'plan name' or
* Correct the collection id in the PKLIST and bind the application plan 'plan name' or
* Set the current package set special register correctly or * Put the correct 'location name' in the CURRENTSERVER of the BIND command and bind the application plan 'plan name' or * Connect to the correct RDB name or
* Correct the location id in the PKLIST and bind the application plan 'plan name' or
* Bind the DBRM of the version of the application program to be executed

I got all this info from Error Code Descriptor.

Hope this helps

Regards

Rupesh
Back to top
View user's profile Send private message
radhakrishnan82

Active User


Joined: 31 Mar 2005
Posts: 436
Location: chennai, India

PostPosted: Wed Oct 05, 2005 4:13 pm    Post subject: Re: -805 SQLCODE IN CICS/DB2 APPLICATION PROGRAM
Reply with quote

The following queries aid in determining the problem. Run these queries at the local location.

1. This query displays the DBRMs in the member list for the plan. If no
rows are returned, then the plan was bound without a member list.

Code:
 SELECT PLCREATOR, PLNAME, NAME, VERSION                               
      FROM SYSIBM.SYSDBRM                                                   
      WHERE PLNAME = 'plan-name';   


2. This query displays the entries in the package list for the plan. If
no rows are returned, then the plan was bound without a package list.

Code:
SELECT LOCATION, COLLID, NAME                                         
      FROM SYSIBM.SYSPACKLIST                                               
      WHERE PLANNAME = 'plan-name'; 



hope this helps.
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 -> CICS All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
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 Need help in REXX CALL program Raje1002 CLIST & REXX 5 Wed Apr 19, 2017 11:18 pm
No new posts CICS Transaction Timeout Hooman24 CICS 2 Sun Apr 16, 2017 2:16 pm
No new posts Application not run by time HH:MM tri... jzhardy IBM Tools 1 Sun Apr 09, 2017 3:22 pm
No new posts Date and time format in CICS Chandru3183 CICS 2 Sat Mar 18, 2017 12:46 pm


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