IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SQL abend 80N and sql state 51002


IBM Mainframe Forums -> ABENDS & Debugging
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
vijayaselvam

New User


Joined: 29 May 2006
Posts: 6

PostPosted: Tue Jul 10, 2007 2:32 pm
Reply with quote

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
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India

PostPosted: Tue Jul 10, 2007 2:51 pm
Reply with quote

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
View user's profile Send private message
vijayaselvam

New User


Joined: 29 May 2006
Posts: 6

PostPosted: Tue Jul 10, 2007 3:28 pm
Reply with quote

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
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Tue Jul 10, 2007 4:00 pm
Reply with quote

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
View user's profile Send private message
vijayaselvam

New User


Joined: 29 May 2006
Posts: 6

PostPosted: Tue Jul 10, 2007 4:33 pm
Reply with quote

Thank You Very Much.

Ever Yours,
VijayaSelvam
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> ABENDS & Debugging

 


Similar Topics
Topic Forum Replies
No new posts ISAM and abend S03B JCL & VSAM 9
No new posts Abend S0C4 11 (Page Translation Excep... PL/I & Assembler 16
No new posts WER999A - UNSUCCESSFUL SORT 8ED U Ab... SYNCSORT 5
No new posts the system or user abend SF0F R=NULL COBOL Programming 0
No new posts Need to get an DLI abend like U0200 IMS DB/DC 2
Search our Forums:

Back to Top