Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
how to Resolve SQL Error Code -924

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

New User


Joined: 09 Dec 2015
Posts: 1
Location: chennai

PostPosted: Thu Dec 10, 2015 2:39 pm    Post subject: how to Resolve SQL Error Code -924
Reply with quote

While Executing Cobol IMS DB2 module with 2 different input files simultaneously either of the program is getting abended with sql code -924. As per the manual we came to know it is contention of jobs.

So we have added With UR (Uncommitted read) in the SQL Select query. but then to the job gets abended with same error. could you please help on this.

Thanks,
Rajesh.
Back to top
View user's profile Send private message

Bill O'Boyle

CICS Moderator


Joined: 14 Jan 2008
Posts: 2504
Location: Atlanta, Georgia, USA

PostPosted: Thu Dec 10, 2015 5:30 pm    Post subject: Reply to: how to Resolve SQL Error Code -924
Reply with quote

Search the DB2 forum for -924, where you'll find several hits in previous postings.
Back to top
View user's profile Send private message
Rohit Umarjikar

Senior Member


Joined: 21 Sep 2010
Posts: 2166
Location: NY,USA

PostPosted: Thu Dec 10, 2015 10:24 pm    Post subject:
Reply with quote

Also, have you spoken yet to your Support Group? if not then that is the first step you should do.
Quote:
As per the manual we came to know it is contention of jobs.

Show us please. I see this and explore more on Negative Dependency during scheduling too.
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 data conversion error maxsubrat PL/I & Assembler 4 Thu May 09, 2019 10:57 pm
No new posts S0C4 Reason Code 10 cz016m COBOL Programming 1 Thu May 02, 2019 7:13 am
No new posts How to resolve sqlcode of CALL ATTACH... maxsubrat DB2 3 Fri Feb 22, 2019 11:54 am
This topic is locked: you cannot edit posts or make replies. PARAMETER 'F1' IS UNIDENTIFIED error ... Poha Eater DFSORT/ICETOOL 14 Fri Feb 01, 2019 2:39 pm
No new posts SORT INNER JOIN [F1] OUT OF SEQ ERROR balaji81_k DFSORT/ICETOOL 8 Wed Jan 30, 2019 3:21 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us