|
View previous topic :: View next topic
|
| Author |
Message |
knd_r
Currently Banned
New User
Joined: 18 Mar 2005
Posts: 48
|
|
|
|
hi,
How to overcome deadlock situation?
bye,
ks reddy. |
|
| Back to top |
|
 |
MGIndaco
Active User
Joined: 10 Mar 2005
Posts: 432
Location: Milan, Italy
|
|
|
|
| What deadlock situation have you met? |
|
| Back to top |
|
|
knd_r
Currently Banned
New User
Joined: 18 Mar 2005
Posts: 48
|
|
|
|
| suppost in db2, if more than one task updating the same table then deadlock situation arises, then to overcome this deadlock we have to terminate the first task or second task or both? |
|
| Back to top |
|
|
priya
Moderator
Joined: 24 Jul 2003
Posts: 568
Location: Bangalore
|
|
|
|
| No, DB2 take care about that. Just specify CR, UR, RR at your bind time. |
|
| Back to top |
|
|
sen_1983us
New User
Joined: 21 May 2005
Posts: 21
Location: Hyderabad
|
|
|
|
| what is rr cr ur explain it |
|
| Back to top |
|
|
priya
Moderator
Joined: 24 Jul 2003
Posts: 568
Location: Bangalore
|
|
|
|
CR - Cursor Stability
UR - Uncommitted Read
RR - Repeatable Read |
|
| Back to top |
|
|
|
|
