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
 

 

Abend U0100 due to SQL CODE -924

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> ABENDS & Debugging
View previous topic :: :: View next topic  
Author Message
ponnu116
Warnings : 1

New User


Joined: 12 Sep 2007
Posts: 21
Location: chennai

PostPosted: Tue Oct 07, 2008 3:48 pm    Post subject: Abend U0100 due to SQL CODE -924
Reply with quote

Im getting Abend U0100 due to SQL CODE -924.

The query is fetching a cursor which was a update cursor with hold.

Can anyone please help me on this
Back to top
View user's profile Send private message

expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Oct 07, 2008 3:56 pm    Post subject:
Reply with quote

What was the explanation from the -924 message code ?

You need to post the error messages and codes to supply us with more detail
Back to top
View user's profile Send private message
dbzTHEdinosauer

Global Moderator


Joined: 20 Oct 2006
Posts: 6967
Location: porcelain throne

PostPosted: Tue Oct 07, 2008 3:59 pm    Post subject:
Reply with quote

Quote:

-924 DB2 CONNECTION INTERNAL ERROR, function-code, return-code, reason-code

Explanation: Connection to DB2 has failed because of an unexpected internal error, identified by the 'reason-code'.

System action: The statement cannot be executed. The connection to DB2 is not established.

Programmer response: Look up the abend 'reason-code' in Part 3, “DB2 codes” for further information. The requested 'function-code' and 'return-code' may provide additional information. Any attempts to issue SQL statements following the SQLCODE -924 will cause unpredictable results. SQLSTATE: 58006


the above is from Vsn 8, but is basically valid for 6 & 7.

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNC1J12/2.3.442?SHELF=&DT=20070111144235&CASE=

here is a link for the reason code: http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNC1J12/3.0?DT=20070111144235#HDRARC

suggest you download the PDF.

you can also find explanations for error at the IBM LookAt site:
http://www-03.ibm.com/systems/z/os/zos/bkserv/lookat/

suggest you bookmark that link.
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
No new posts Job failing with USER = 4093 REASON C... Pradeepa S ABENDS & Debugging 1 Wed May 17, 2017 3:35 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 JCL to Set Return code based on DB2 S... vinu78 DB2 17 Mon Mar 13, 2017 9:47 pm
No new posts IMS region inactive - User abend code... gthmrj IMS DB/DC 5 Tue Mar 07, 2017 12:29 pm


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