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: 1939
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 Error while initiation CICS program f... Ashishpanpaliya CICS 3 Mon Jul 16, 2018 5:12 pm
No new posts Converting SAS code to Cobol or Easyt... Ashish.Raghav All Other Mainframe Topics 6 Fri Jun 29, 2018 6:01 pm
No new posts JCL COND CODE check juares castro JCL & VSAM 4 Tue Jun 26, 2018 7:43 pm
No new posts ERROR - NO ESD ENTRIES, EXECUTION IMP... Ashishpanpaliya COBOL Programming 6 Thu Jun 21, 2018 8:57 pm
No new posts What will happen if we dont code STOP... Poha Eater COBOL Programming 4 Mon Jun 04, 2018 5:27 pm

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