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
 

 

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: 2502
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: 1610
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 PL/I code tuning/Performance improvement Virendra Shambharkar PL/I & Assembler 4 Mon Dec 05, 2016 11:57 am
No new posts S922 Error yuvan ABENDS & Debugging 3 Fri Dec 02, 2016 6:58 pm
No new posts What is the code in CLIST to enable t... jackzhang75 CLIST & REXX 1 Fri Dec 02, 2016 3:02 am
No new posts IDEAL - Code Retrieval yugendran CA Products 0 Fri Nov 25, 2016 3:27 pm
No new posts Invoke Webservice Fails with DFHPI100... divated CICS 2 Thu Nov 24, 2016 5:57 pm


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