View previous topic :: View next topic
|
Author |
Message |
vijayaselvam
New User
Joined: 29 May 2006 Posts: 6
|
|
|
|
Hi all,
Does any one know the reason for SQL abend 80N and sqlstate 51002. Please clarify me on this. Thank you.
Details from SPOOL:
DB2 PROBLEM OPENING EXTRACT_CSR
SQLCODE ABEND: 00000080N
SQLSTATE: 51002
Ever Yours,
Vijayaselvam |
|
Back to top |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
Selvam,
Taken from QW -
Quote: |
-805 DBRM OR PACKAGE NAME
location-name.collection-id.dbrm-name.consistency -token NOT FOUND
IN PLAN plan-name. REASON reason |
|
|
Back to top |
|
|
vijayaselvam
New User
Joined: 29 May 2006 Posts: 6
|
|
|
|
Thanks Murali.
Could you clarify it some more?
I got the info for the sql state 51002 as the package corresponding to an SQL statement execution request was not found... For this the respective abend code is 805..... But in my spool I got 80N... Please clarify. Thanks
Ever Yours,
VijayaSelvam |
|
Back to top |
|
|
William Thompson
Global Moderator
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
|
|
|
|
80N is -805 with the sign imbedded in the last digit.
For more information, look at the reason code in the error message as defined in the DB2 for OS/390 V5 Messages and Codes manual. |
|
Back to top |
|
|
vijayaselvam
New User
Joined: 29 May 2006 Posts: 6
|
|
|
|
Thank You Very Much.
Ever Yours,
VijayaSelvam |
|
Back to top |
|
|
|