View previous topic :: View next topic
|
Author |
Message |
nareshdacha
New User
Joined: 12 Jan 2010 Posts: 66 Location: US
|
|
|
|
This question was asked in interview.
Deadlock occured for the table EMP (-911). If we use CS (cursor stability) can we remove the deadlock ? If so how can we remove deadlock ?.
I know that while binding we can give CS parameter to avoid deadlocks but after deadlock happens i dont know how to remove the deadlock? Please explain how to remove deadlock.
I have searched the forum but am confused, hence i posted this question.... |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
You don't remove a deadlock - it is automatically removed. When a deadlock (sometimes known as a "fatal embrace" is detected, the task causing the the deadlock is terminated. |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
considering the lack of experience and knowledge of the TS,
i think it is important to modify the statement.
Quote: |
the task causing the the deadlock is terminated |
to
Quote: |
the DB2 task (not the task requesting db2 to process the sql) causing the the deadlock is terminated |
|
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hi Dick,
Yup, good point - i should have said the same
d |
|
Back to top |
|
|
|