IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

DB2 deadlock


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Vasanth Kumar S K

New User


Joined: 08 Jun 2020
Posts: 1
Location: India

PostPosted: Mon Jun 08, 2020 8:23 am
Reply with quote

Suppose I am processing 1000 records and I got DB2 deadlock error 911 what are all the procedures we have to follow to resolve this error...? Please suggest me what you will do and how you will rerun the job to resolve this..?
Back to top
View user's profile Send private message
Nic Clouston

Global Moderator


Joined: 10 May 2007
Posts: 2454
Location: Hampshire, UK

PostPosted: Mon Jun 08, 2020 1:03 pm
Reply with quote

The procedures are as per your site's procedures.
Back to top
View user's profile Send private message
Rohit Umarjikar

Global Moderator


Joined: 21 Sep 2010
Posts: 3076
Location: NYC,USA

PostPosted: Mon Jun 08, 2020 2:50 pm
Reply with quote

If it’s production , you have no choice but to restart from top and if it’s a development question then use checkpoint restart table and use retry (3 or 4 times ) for contentions or deadlocks -911 or -913 before you issue abend.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts -913/-911 Deadlock during UPDATE stat... DB2 5
No new posts Can a select query participate in a d... DB2 1
No new posts Related to Deadlock issue DB2 2
No new posts table scan can cause deadlock over RID? DB2 10
No new posts Creating IDMS Deadlock IDMS/ADSO 1
Search our Forums:

Back to Top