How to overcome DEADLOCK

sagarika25 · New User Joined: 16 Jan 2006 Posts: 3

Hi,

If i ll get error code -911 or -913 (that is both for deadlock), Then how come i overcome this problem???

For both the error code the solution is same or different?

Regards,
Sagarika

Rupesh.Kothari · Member of the Month Joined: 27 Apr 2005 Posts: 486

HI,

khamarutheen · Posted: Fri Jan 20, 2006 7:43 pm Post subject: Deadlock

Hi sagarika25,
The thing is DB2 itself handles some Deadlock conditions. so -911 will rollback the situation since it itself cannot handle the situation. and if -913 prompts the low priority job can b killed mannaully. So Better Handle some Locking techniques such that to avoid the deadlock and place some checkpoint also. Hope it will help.