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.
DB2 Deadlocks VS Locks
Previous topic • Next topic • 2 posts
• Page 1 of 1
DB2 Deadlocks VS Locks
by kumar009 » Wed Apr 23, 2014 9:51 pm
- kumar009
- Posts: 10
- Joined: Wed Apr 23, 2014 11:48 am
- Has thanked: 0 time
- Been thanked: 0 time
Re: DB2 Deadlocks VS Locks
by 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
-
Akatsukami - Global moderator
- Posts: 1058
- Joined: Sat Oct 16, 2010 2:31 am
- Location: Bloomington, IL
- Has thanked: 6 times
- Been thanked: 51 times
Previous topic • Next topic • 2 posts
• Page 1 of 1
-
- Related topics
- Replies
- Views
- Last post
-
- Types of Locks. ??
by heshmahesh » Fri Nov 21, 2014 1:05 pm - 1 Replies
- 2593 Views
- Last post by enrico-sorichetti
Fri Nov 21, 2014 2:13 pm
- Types of Locks. ??
-
- Can deadlocks cause lock escalations ?
by Rockish » Thu Apr 22, 2010 12:29 pm - 1 Replies
- 2098 Views
- Last post by dick scherrer
Thu Apr 22, 2010 11:30 pm
- Can deadlocks cause lock escalations ?
-
- DB2 Select statements causing deadlocks?
by paulmac1968 » Wed May 01, 2013 8:12 pm - 7 Replies
- 6202 Views
- Last post by dick scherrer
Thu May 02, 2013 1:35 am
- DB2 Select statements causing deadlocks?