View previous topic :: View next topic
|
Author |
Message |
sushtare
New User
Joined: 05 Oct 2005 Posts: 1 Location: PUNE
|
|
|
|
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 |
|
|
Rupesh.Kothari
Member of the Month
Joined: 27 Apr 2005 Posts: 463
|
|
|
|
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 |
|
|
radhakrishnan82
Active User
Joined: 31 Mar 2005 Posts: 435 Location: chennai, India
|
|
|
|
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 |
|
|
|