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: 2064
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 PLI Run JCL error with 806 shrivatsa PL/I & Assembler 6 Wed Dec 05, 2018 12:23 pm
No new posts calling java code(on mainframe from c... elixir1986 COBOL Programming 1 Fri Nov 30, 2018 1:57 am
No new posts Code numeric format to display both '... Time2Live COBOL Programming 7 Wed Nov 21, 2018 10:20 pm
No new posts Will this code extract 1 byte from fi... pkmurali CLIST & REXX 8 Sat Nov 10, 2018 11:13 pm
No new posts Error reading file in REXX module ashek15 CLIST & REXX 3 Wed Oct 24, 2018 4:50 am

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