Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search 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
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
References
priya

Moderator


Joined: 24 Jul 2003
Posts: 624
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
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DB2 All times are GMT + 6 Hours
Page 1 of 1