DB2 Deadlocks VS Locks



IBM's flagship relational database management system

DB2 Deadlocks VS Locks

Postby kumar009 » Wed Apr 23, 2014 9:51 pm

Most of the DB2 deadlocks happen with the contention of DB2 locks. Am I correct ?

Can a developer specify locks and control them at program level ?
I mean, Developers usually specify the locks in the form of ISOLATION LEVEL at the BIND parameter. Depends on the usage of the table data in the program, the isolation level will be specified. I feel that, the lock escalation happen automatically by DB2 sub-system

What are the various other scenarios DB2 deadlocks happen ? Please list out ... Please tell me, How do you approach DB2 deadlock issue in production and possible solutions to avoid them in future.
kumar009
 
Posts: 10
Joined: Wed Apr 23, 2014 11:48 am
Has thanked: 0 time
Been thanked: 0 time

Re: DB2 Deadlocks VS Locks

Postby Akatsukami » Thu Apr 24, 2014 2:33 am

Look at this thread.
"You have sat too long for any good you have been doing lately ... Depart, I say; and let us have done with you. In the name of God, go!" -- what I say to a junior programmer at least once a day
User avatar
Akatsukami
Global moderator
 
Posts: 1058
Joined: Sat Oct 16, 2010 2:31 am
Location: Bloomington, IL
Has thanked: 6 times
Been thanked: 51 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post