Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Forum Index
 
Register
 
IBM Mainframe Forum 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: 2268
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 Not seeing the error panel )ATTR Harold Barnes TSO/ISPF 4 Fri Sep 20, 2019 10:56 am
No new posts End the job into error / abend state wik123 JCL & VSAM 3 Wed Sep 11, 2019 6:37 pm
No new posts WER027A Error Chinnadu SYNCSORT 8 Thu Aug 29, 2019 11:58 am
No new posts ISRE771 error while invoking macros pkmurali CLIST & REXX 4 Mon Aug 26, 2019 7:59 pm
No new posts proc step return code to override in ... Aaryaa JCL & VSAM 3 Tue Aug 20, 2019 4:32 pm

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