Pons
New User
Joined: 25 May 2007 Posts: 61 Location: Coimbatore
|
|
|
|
Hi,
I try to solve the -911 (Dead lock) contention issue. For that i explicitly give the commit while we receive the -911.
Ex:
I plan to code like,
IF WS-SQL-CODE = -0911
EXEC SQL
COMMIT
END-EXEC
END-IF.
but my doubt is,
-911 THE CURRENT UNIT OF WORK HAS BEEN ROLLED BACK DUE TO
DEADLOCK OR TIMEOUT. REASON reason-code, TYPE OF
RESOURCE resource-type, AND RESOURCE NAME resource-
name.
Is my code will commit the transaction, or while getting the -911 from the DB2 Detecter itself is it rolled back the transaction?
Please let me know some detailed information. |
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
as the -911 says, your current unit of work has been rolled back. If you issue a COMMIT, there is nothing to commit.
What you need to do is restart you last current unit of work.
Are you sure that you did not receive a -913 and ignore it.
you need to read chapter 4 of the sql programming and application guide. |
|