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 avoid DB2 contention(911)

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2
View previous topic :: :: View next topic  
Author Message
Suresh Kumar

New User


Joined: 15 Feb 2005
Posts: 3

PostPosted: Thu Mar 17, 2005 11:57 am    Post subject: how to avoid DB2 contention(911)
Reply with quote

We have job abends with dead lock though we use WITH UR in our SQL queries.

Same table used in both jobs.

Awaiting for your ans...
Thanks
Suresh
Back to top
View user's profile Send private message

priya

Moderator


Joined: 24 Jul 2003
Posts: 568
Location: Bangalore

PostPosted: Sun Mar 20, 2005 1:51 am    Post subject:
Reply with quote

I hope the table may be in UseLock or DeadLock. Check whether the table is under a lock or not.

What manual says:

Quote:
-911 A SYNCPOINT command with the ROLLBACK option was issued
on behalf of your application process. All updates (CICS
commands and DL/I calls, as well as SQL statements) that
occurred during the current unit of work have been undone.
(SQLSTATE '40001')



Try this also:

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPH11/4.2.2.3?SHELF=&DT=20010710165542
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 -> DB2 All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Display ZEDLMSG without Pressing F1 &... anandgbe CLIST & REXX 8 Thu Dec 15, 2016 4:20 pm
No new posts GRS contention on IMS resource Hooman24 IMS DB/DC 7 Sun Jan 11, 2015 1:28 pm
No new posts How to avoid/Omit Addtional qualifer ... cmsmoon TSO/ISPF 2 Thu Nov 27, 2014 6:31 pm
No new posts How to reduce PDRB latch contention? Hooman24 IMS DB/DC 0 Sun Jun 22, 2014 8:53 pm
No new posts File open failed - contention with b... cser_oxygen CICS 6 Wed Apr 09, 2014 3:20 pm


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