How to overcome deadlock situation

knd_r · New User Joined: 18 Mar 2005 Posts: 48

hi,

How to overcome deadlock situation?

bye,
ks reddy.

MGIndaco · Posted: Mon May 23, 2005 5:27 pm Post subject:

What deadlock situation have you met?

knd_r · 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?

priya · Posted: Mon May 23, 2005 9:46 pm Post subject:

No, DB2 take care about that. Just specify CR, UR, RR at your bind time.

sen_1983us · New User Joined: 21 May 2005 Posts: 12 Location: Hyderabad

what is rr cr ur explain it

priya · Posted: Tue May 24, 2005 9:21 pm Post subject:

CR - Cursor Stability
UR - Uncommitted Read
RR - Repeatable Read