By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,496 Members | 1,527 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,496 IT Pros & Developers. It's quick & easy.

DB2 8.01 - need help with deadlock problem (Event Monitor Log Attached)

P: n/a
Hello all,
we are running a delphi application with DB2 V8.01 which is causing
deadlocks when rows are being inserted into a table. Attaching the
Event Monitor Log (DEADLOCKS WITH DETAILS) here. From the log it looks
like the problem happens when 2 threads insert 1 record each in the
same table and then try to aquire a NS (Next Key Share)
lock on the record inserterd by the other thread.
Thanks
Rohit

Event Monitor Log
-----------------------------------------------------------------

--------------------------------------------------------------------------
EVENT LOG HEADER
Event Monitor name: DLMON
Server Product ID: SQL08010
Version of event monitor data: 7
Byte order: LITTLE ENDIAN
Number of nodes in db2 instance: 1
Codepage of database: 1208
Territory code of database: 1
Server instance name: DB2
--------------------------------------------------------------------------

--------------------------------------------------------------------------
Database Name: CNUSER
Database Path: E:\DB2\NODE0000\SQL00001\
First connection timestamp: 08-18-2004 16:06:09.862144
Event Monitor Start time: 08-18-2004 17:10:13.808347
--------------------------------------------------------------------------

3) Deadlock Event ...
Deadlock ID: 2
Number of applications deadlocked: 3
Deadlock detection time: 08-18-2004 17:13:30.874490
Rolled back Appl participant no: 2
Rolled back Appl Id: M40201C7.G405.012188114314
Rolled back Appl seq number: : 002a

4) Connection Header Event ...
Appl Handle: 83
Appl Id: M40201C7.G405.012188114314
Appl Seq number: 002a
DRDA AS Correlation Token: M40201C7.G405.012188114314
Program Name : BESvr.exe
Authorization Id: CNUSER
Execution Id : ADMINISTRATOR
Codepage Id: 1252
Territory code: 1
Client Process Id: 2592
Client Database Alias: CNUSER
Client Product Id: SQL08010
Client Platform: Unknown
Client Communication Protocol: TCPIP
Client Network Name:
Connect timestamp: 08-18-2004 17:13:13.195860

5) Deadlocked Connection ...
Deadlock ID: 2
Participant no.: 2
Participant no. holding the lock: 1
Appl Id: M40201C7.G405.012188114314
Appl Seq number: 002a
Appl Id of connection holding the lock: M40201C7.G405.012188114314
Seq. no. of connection holding the lock: 002a
Lock wait start time:
Lock Name : 0x0200290148428D000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 1
Current Mode : none
Deadlock detection time: 08-18-2004 17:13:30.874570
Table of lock waited on : PAYMENTCOR
Schema of lock waited on : CNUSER
Tablespace of lock waited on : CNTBL32K
Type of lock: Row
Mode of lock: X - Exclusive
Mode application requested on lock: NS - Share (and Next Key Share)
Node lock occured on: 0
Lock object name: 9257544
Application Handle: 83
Deadlocked Statement:
Type : Dynamic
Operation: Fetch
Section : 11
Creator : NULLID
Package : SYSSH200
Cursor : SQL_CURSH200C11
Cursor was blocking: FALSE
Text : SELECT "SYSTEM_REF" ,"PAYMENT_SEQ" ,"PAYTHRU_ID"
,"PAYTHRU_NAME" ,"PAYTHRU_ADDR" ,"PAYTHRU_SEND" ,"PAYTHRU_SENDVIA"
,"PAYTHRU_FORM" ,"BENE_ID" ,"BENE_NAME" ,"BENE_ADDR" ,"BENE_ACC"
,"BENE_SEND" ,"BENE_SENDVIA" ,"BENE_FORM" ,"BENEBK_ID" ,"BENEBK_NAME"
,"BENEBK_ADDR" ,"BENEBK_ACC" ,"BENEBK_SEND" ,"BENEBK_SENDVIA"
,"BENEBK_FORM" ,"INTBK_ID" ,"INTBK_NAME" ,"INTBK_ADDR" ,"INTBK_ACC"
,"INTBK_SEND" ,"INTBK_SENDVIA" ,"INTBK_FORM" ,"PAYTHRU_TEMPLATE"
,"BENE_TEMPLATE" ,"BENEBK_TEMPLATE" ,"INTBK_TEMPLATE"
,"PAYTHRU_CORREF" ,"BENE_CORREF" ,"BENEBK_CORREF" ,"INTBK_CORREF"
,"REMARKS" ,"PAYTHRU_CORID" ,"BENE_CORID" ,"BENEBK_CORID"
,"INTBK_CORID" ,"SETTLEMENT_SEQ" ,"OPARTY_ID" ,"OPARTY_NAME"
,"OPARTY_ADDR" ,"OPARTY_SEND" ,"OPARTY_SENDVIA" ,"OPARTY_CORID"
,"OPARTY_TEMPLATE" ,"OPARTY_FORM" ,"OPARTY_ACC" ,"ARCHIEVE_FLAG"
,"PAYTHRU_REMARKS" ,"BENE_REMARKS" ,"BENEBK_REMARKS" ,"INTBK_REMARKS"
,"OPARTY_REMARKS" ,"PAYTHRU_CHARGES_FOR" ,"BENE_CHARGES_FOR"
,"BENEBK_CHARGES_FOR" ,"INTBK_CHARGES_FOR" ,"OPARTY_CHARGES_FOR"
,"PAYTHRU_OTHER_INFO" ,"BENE_OTHER_INFO" ,"BENEBK_OTHER_INFO"
,"INTBK_OTHER_INFO" ,"OPARTY_OTHER_INFO" ,"OPARTY_CORREF" FROM
"PAYMENTCOR" WHERE "SYSTEM_REF"=? AND "PAYMENT_SEQ"=? ORDER BY
"SYSTEM_REF" ASC , "PAYMENT_SEQ" ASC
List of Locks:
Lock Name : 0x02000000010000000100E20056
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Variation
Mode : S - Share

Lock Name : 0x0200D00119C2F1000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 15843865
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : PAYMENTDETAILS
Mode : X - Exclusive

Lock Name : 0x0200D001000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 464
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : PAYMENTDETAILS
Mode : IX - Intent Exclusive

Lock Name : 0x0200290149428D000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 9257545
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : PAYMENTCOR
Mode : X - Exclusive

Lock Name : 0x02002901000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 1
Lock Object Name : 297
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : PAYMENTCOR
Mode : IX - Intent Exclusive

Lock Name : 0x0200C70120C2EC000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 15516192
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : PAYMENT
Mode : X - Exclusive

Lock Name : 0x0200C701000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 455
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : PAYMENT
Mode : IX - Intent Exclusive

Lock Name : 0x020072014C84B7000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 12026956
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_AUDITTRAIL
Mode : X - Exclusive

Lock Name : 0x020072013384B7000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 1
Lock Object Name : 12026931
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_AUDITTRAIL
Mode : NS - Share (and Next Key Share)

Lock Name : 0x02007201000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 1
Lock Object Name : 370
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_AUDITTRAIL
Mode : IX - Intent Exclusive

Lock Name : 0x150000000100000002008B0056
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Variation
Mode : S - Share

Lock Name : 0x020003022E0DF6000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 16125230
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_TOKEN_STAGER
Mode : X - Exclusive

Lock Name : 0x020003022D0DF6000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 16125229
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_TOKEN_STAGER
Mode : X - Exclusive

Lock Name : 0x02000302000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 515
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_TOKEN_STAGER
Mode : IX - Intent Exclusive

Lock Name : 0x0200CB013841EF000000000052
Lock Attributes : 0x00000020
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 15679800
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TRANSACTION_TOKEN
Mode : X - Exclusive

Lock Name : 0x0200CB01000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 459
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TRANSACTION_TOKEN
Mode : IX - Intent Exclusive

Lock Name : 0x020077011281BA000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 12222738
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_SCHEDULE
Mode : X - Exclusive

Lock Name : 0x02007701000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 375
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_SCHEDULE
Mode : IX - Intent Exclusive

Lock Name : 0x0200CA0121C1EE000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 15647009
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TRANSACTION_FEES
Mode : X - Exclusive

Lock Name : 0x0200CA01000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 458
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TRANSACTION_FEES
Mode : IX - Intent Exclusive

Lock Name : 0x5359534C564C303153544E4441
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Plan
Mode : S - Share

Lock Name : 0x0200530180000000070000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 3
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x0200530180000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 3
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530170000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 48
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530160000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 39
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530150000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 39
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530140000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 39
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530130000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 39
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530120000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 48
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530110000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 48
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530100000000130000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x0200530100000000100000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x0200530100000000090000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x0200530100000000070000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x0200530100000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 39
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x02005301000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 339
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : RULES
Mode : IS - Intent Share

Lock Name : 0x02007E0100000000130000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 2
Hold Count : 1
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x02007E0100000000100000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 2
Hold Count : 1
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x02007E0100000000090000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 2
Hold Count : 1
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x02007E0180000000070000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 2
Hold Count : 1
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x02007E01D0000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 2
Hold Count : 1
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x02007E012F40BD000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 1
Lock Object Name : 12402735
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : USERPROFILES
Mode : NS - Share (and Next Key Share)

Lock Name : 0x02007E01000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 2
Hold Count : 1
Lock Object Name : 382
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : USERPROFILES
Mode : IS - Intent Share

Lock Name : 0x01000000010000000300B70056
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Variation
Mode : S - Share

Lock Name : 0x4141414141614953534C4E4441
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Plan
Mode : S - Share

Lock Name : 0x0200D1010C49F2000000000052
Lock Attributes : 0x00000020
Release Flags : 0x40000000
Lock Count : 4
Hold Count : 0
Lock Object Name : 15878412
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : REMITTANCES
Mode : X - Exclusive

Lock Name : 0x0200D101000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 4
Hold Count : 0
Lock Object Name : 465
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : REMITTANCES
Mode : IX - Intent Exclusive

Lock Name : 0x5359534C564C303153304E4441
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Plan
Mode : S - Share

Locks Held: 48
Locks in List: 48

6) Connection Header Event ...
Appl Handle: 86
Appl Id: M40201C7.GA05.014008114320
Appl Seq number: 002a
DRDA AS Correlation Token: M40201C7.GA05.014008114320
Program Name : BESvr.exe
Authorization Id: CNUSER
Execution Id : ADMINISTRATOR
Codepage Id: 1252
Territory code: 1
Client Process Id: 2592
Client Database Alias: CNUSER
Client Product Id: SQL08010
Client Platform: Unknown
Client Communication Protocol: TCPIP
Client Network Name:
Connect timestamp: 08-18-2004 17:13:16.123736

7) Deadlocked Connection ...
Deadlock ID: 2
Participant no.: 1
Participant no. holding the lock: 2
Appl Id: M40201C7.GA05.014008114320
Appl Seq number: 002a
Appl Id of connection holding the lock: M40201C7.GA05.014008114320
Seq. no. of connection holding the lock: 002a
Lock wait start time:
Lock Name : 0x0200290149428D000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 1
Current Mode : none
Deadlock detection time: 08-18-2004 17:13:30.876374
Table of lock waited on : PAYMENTCOR
Schema of lock waited on : CNUSER
Tablespace of lock waited on : CNTBL32K
Type of lock: Row
Mode of lock: X - Exclusive
Mode application requested on lock: NS - Share (and Next Key Share)
Node lock occured on: 0
Lock object name: 9257545
Application Handle: 86
Deadlocked Statement:
Type : Dynamic
Operation: Fetch
Section : 11
Creator : NULLID
Package : SYSSH200
Cursor : SQL_CURSH200C11
Cursor was blocking: FALSE
Text : SELECT "SYSTEM_REF" ,"PAYMENT_SEQ" ,"PAYTHRU_ID"
,"PAYTHRU_NAME" ,"PAYTHRU_ADDR" ,"PAYTHRU_SEND" ,"PAYTHRU_SENDVIA"
,"PAYTHRU_FORM" ,"BENE_ID" ,"BENE_NAME" ,"BENE_ADDR" ,"BENE_ACC"
,"BENE_SEND" ,"BENE_SENDVIA" ,"BENE_FORM" ,"BENEBK_ID" ,"BENEBK_NAME"
,"BENEBK_ADDR" ,"BENEBK_ACC" ,"BENEBK_SEND" ,"BENEBK_SENDVIA"
,"BENEBK_FORM" ,"INTBK_ID" ,"INTBK_NAME" ,"INTBK_ADDR" ,"INTBK_ACC"
,"INTBK_SEND" ,"INTBK_SENDVIA" ,"INTBK_FORM" ,"PAYTHRU_TEMPLATE"
,"BENE_TEMPLATE" ,"BENEBK_TEMPLATE" ,"INTBK_TEMPLATE"
,"PAYTHRU_CORREF" ,"BENE_CORREF" ,"BENEBK_CORREF" ,"INTBK_CORREF"
,"REMARKS" ,"PAYTHRU_CORID" ,"BENE_CORID" ,"BENEBK_CORID"
,"INTBK_CORID" ,"SETTLEMENT_SEQ" ,"OPARTY_ID" ,"OPARTY_NAME"
,"OPARTY_ADDR" ,"OPARTY_SEND" ,"OPARTY_SENDVIA" ,"OPARTY_CORID"
,"OPARTY_TEMPLATE" ,"OPARTY_FORM" ,"OPARTY_ACC" ,"ARCHIEVE_FLAG"
,"PAYTHRU_REMARKS" ,"BENE_REMARKS" ,"BENEBK_REMARKS" ,"INTBK_REMARKS"
,"OPARTY_REMARKS" ,"PAYTHRU_CHARGES_FOR" ,"BENE_CHARGES_FOR"
,"BENEBK_CHARGES_FOR" ,"INTBK_CHARGES_FOR" ,"OPARTY_CHARGES_FOR"
,"PAYTHRU_OTHER_INFO" ,"BENE_OTHER_INFO" ,"BENEBK_OTHER_INFO"
,"INTBK_OTHER_INFO" ,"OPARTY_OTHER_INFO" ,"OPARTY_CORREF" FROM
"PAYMENTCOR" WHERE "SYSTEM_REF"=? AND "PAYMENT_SEQ"=? ORDER BY
"SYSTEM_REF" ASC , "PAYMENT_SEQ" ASC
List of Locks:
Lock Name : 0x0200290149428D000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 1
Lock Object Name : 9257545
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : PAYMENTCOR
Mode : NS - Share (and Next Key Share)

Lock Name : 0x02000000010000000100E20056
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Variation
Mode : S - Share

Lock Name : 0x0200D00117C2F1000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 15843863
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : PAYMENTDETAILS
Mode : X - Exclusive

Lock Name : 0x0200D001000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 464
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : PAYMENTDETAILS
Mode : IX - Intent Exclusive

Lock Name : 0x0200290148428D000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 9257544
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : PAYMENTCOR
Mode : X - Exclusive

Lock Name : 0x02002901000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 1
Lock Object Name : 297
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : PAYMENTCOR
Mode : IX - Intent Exclusive

Lock Name : 0x0200C7011FC2EC000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 15516191
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : PAYMENT
Mode : X - Exclusive

Lock Name : 0x0200C701000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 455
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : PAYMENT
Mode : IX - Intent Exclusive

Lock Name : 0x020072014D84B7000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 12026957
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_AUDITTRAIL
Mode : X - Exclusive

Lock Name : 0x020072013884B7000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 1
Lock Object Name : 12026936
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_AUDITTRAIL
Mode : NS - Share (and Next Key Share)

Lock Name : 0x02007201000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 1
Lock Object Name : 370
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_AUDITTRAIL
Mode : IX - Intent Exclusive

Lock Name : 0x180000000100000002008B0056
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Variation
Mode : S - Share

Lock Name : 0x02000302300DF6000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 16125232
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_TOKEN_STAGER
Mode : X - Exclusive

Lock Name : 0x020003022F0DF6000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 16125231
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_TOKEN_STAGER
Mode : X - Exclusive

Lock Name : 0x02000302000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 515
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_TOKEN_STAGER
Mode : IX - Intent Exclusive

Lock Name : 0x0200CB013B41EF000000000052
Lock Attributes : 0x00000020
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 15679803
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TRANSACTION_TOKEN
Mode : X - Exclusive

Lock Name : 0x0200CB01000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 459
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TRANSACTION_TOKEN
Mode : IX - Intent Exclusive

Lock Name : 0x020077011381BA000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 12222739
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_SCHEDULE
Mode : X - Exclusive

Lock Name : 0x02007701000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 375
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_SCHEDULE
Mode : IX - Intent Exclusive

Lock Name : 0x0200CA0122C1EE000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 15647010
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TRANSACTION_FEES
Mode : X - Exclusive

Lock Name : 0x0200CA01000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 458
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TRANSACTION_FEES
Mode : IX - Intent Exclusive

Lock Name : 0x5359534C564C303153544E4441
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Plan
Mode : S - Share

Lock Name : 0x0200530180000000070000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 3
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x0200530180000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 3
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530170000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 48
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530160000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 39
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530150000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 39
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530140000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 39
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530130000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 39
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530120000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 48
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530110000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 48
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530100000000130000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x0200530100000000100000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x0200530100000000090000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x0200530100000000070000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x0200530100000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 39
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x02005301000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 339
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : RULES
Mode : IS - Intent Share

Lock Name : 0x02007E0100000000130000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 2
Hold Count : 1
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x02007E0100000000100000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 2
Hold Count : 1
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x02007E0100000000090000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 2
Hold Count : 1
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x02007E0180000000070000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 2
Hold Count : 1
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x02007E01D0000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 2
Hold Count : 1
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x02007E012F40BD000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 1
Lock Object Name : 12402735
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : USERPROFILES
Mode : NS - Share (and Next Key Share)

Lock Name : 0x02007E01000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 2
Hold Count : 1
Lock Object Name : 382
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : USERPROFILES
Mode : IS - Intent Share

Lock Name : 0x01000000010000000300B70056
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Variation
Mode : S - Share

Lock Name : 0x4141414141614953534C4E4441
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Plan
Mode : S - Share

Lock Name : 0x0200D1010E49F2000000000052
Lock Attributes : 0x00000020
Release Flags : 0x40000000
Lock Count : 4
Hold Count : 0
Lock Object Name : 15878414
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : REMITTANCES
Mode : X - Exclusive

Lock Name : 0x0200D101000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 4
Hold Count : 0
Lock Object Name : 465
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : REMITTANCES
Mode : IX - Intent Exclusive

Lock Name : 0x5359534C564C303153304E4441
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Plan
Mode : S - Share

Locks Held: 49
Locks in List: 49

8) Deadlock Event ...
Deadlock ID: 3
Number of applications deadlocked: 3
Deadlock detection time: 08-18-2004 17:13:31.874495
Rolled back Appl participant no: 2
Rolled back Appl Id: M40201C7.G805.0139C8114318
Rolled back Appl seq number: : 002a

9) Connection Header Event ...
Appl Handle: 85
Appl Id: M40201C7.G805.0139C8114318
Appl Seq number: 002a
DRDA AS Correlation Token: M40201C7.G805.0139C8114318
Program Name : BESvr.exe
Authorization Id: CNUSER
Execution Id : ADMINISTRATOR
Codepage Id: 1252
Territory code: 1
Client Process Id: 2592
Client Database Alias: CNUSER
Client Product Id: SQL08010
Client Platform: Unknown
Client Communication Protocol: TCPIP
Client Network Name:
Connect timestamp: 08-18-2004 17:13:14.855251

10) Deadlocked Connection ...
Deadlock ID: 3
Participant no.: 2
Participant no. holding the lock: 1
Appl Id: M40201C7.G805.0139C8114318
Appl Seq number: 002a
Appl Id of connection holding the lock: M40201C7.G805.0139C8114318
Seq. no. of connection holding the lock: 002a
Lock wait start time:
Lock Name : 0x0200290148428D000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 1
Current Mode : none
Deadlock detection time: 08-18-2004 17:13:31.874597
Table of lock waited on : PAYMENTCOR
Schema of lock waited on : CNUSER
Tablespace of lock waited on : CNTBL32K
Type of lock: Row
Mode of lock: X - Exclusive
Mode application requested on lock: NS - Share (and Next Key Share)
Node lock occured on: 0
Lock object name: 9257544
Application Handle: 85
Deadlocked Statement:
Type : Dynamic
Operation: Fetch
Section : 11
Creator : NULLID
Package : SYSSH200
Cursor : SQL_CURSH200C11
Cursor was blocking: FALSE
Text : SELECT "SYSTEM_REF" ,"PAYMENT_SEQ" ,"PAYTHRU_ID"
,"PAYTHRU_NAME" ,"PAYTHRU_ADDR" ,"PAYTHRU_SEND" ,"PAYTHRU_SENDVIA"
,"PAYTHRU_FORM" ,"BENE_ID" ,"BENE_NAME" ,"BENE_ADDR" ,"BENE_ACC"
,"BENE_SEND" ,"BENE_SENDVIA" ,"BENE_FORM" ,"BENEBK_ID" ,"BENEBK_NAME"
,"BENEBK_ADDR" ,"BENEBK_ACC" ,"BENEBK_SEND" ,"BENEBK_SENDVIA"
,"BENEBK_FORM" ,"INTBK_ID" ,"INTBK_NAME" ,"INTBK_ADDR" ,"INTBK_ACC"
,"INTBK_SEND" ,"INTBK_SENDVIA" ,"INTBK_FORM" ,"PAYTHRU_TEMPLATE"
,"BENE_TEMPLATE" ,"BENEBK_TEMPLATE" ,"INTBK_TEMPLATE"
,"PAYTHRU_CORREF" ,"BENE_CORREF" ,"BENEBK_CORREF" ,"INTBK_CORREF"
,"REMARKS" ,"PAYTHRU_CORID" ,"BENE_CORID" ,"BENEBK_CORID"
,"INTBK_CORID" ,"SETTLEMENT_SEQ" ,"OPARTY_ID" ,"OPARTY_NAME"
,"OPARTY_ADDR" ,"OPARTY_SEND" ,"OPARTY_SENDVIA" ,"OPARTY_CORID"
,"OPARTY_TEMPLATE" ,"OPARTY_FORM" ,"OPARTY_ACC" ,"ARCHIEVE_FLAG"
,"PAYTHRU_REMARKS" ,"BENE_REMARKS" ,"BENEBK_REMARKS" ,"INTBK_REMARKS"
,"OPARTY_REMARKS" ,"PAYTHRU_CHARGES_FOR" ,"BENE_CHARGES_FOR"
,"BENEBK_CHARGES_FOR" ,"INTBK_CHARGES_FOR" ,"OPARTY_CHARGES_FOR"
,"PAYTHRU_OTHER_INFO" ,"BENE_OTHER_INFO" ,"BENEBK_OTHER_INFO"
,"INTBK_OTHER_INFO" ,"OPARTY_OTHER_INFO" ,"OPARTY_CORREF" FROM
"PAYMENTCOR" WHERE "SYSTEM_REF"=? AND "PAYMENT_SEQ"=? ORDER BY
"SYSTEM_REF" ASC , "PAYMENT_SEQ" ASC
List of Locks:
Lock Name : 0x02000000010000000100E20056
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Variation
Mode : S - Share

Lock Name : 0x0200D00118C2F1000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 15843864
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : PAYMENTDETAILS
Mode : X - Exclusive

Lock Name : 0x0200D001000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 464
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : PAYMENTDETAILS
Mode : IX - Intent Exclusive

Lock Name : 0x020029014A428D000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 9257546
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : PAYMENTCOR
Mode : X - Exclusive

Lock Name : 0x02002901000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 1
Lock Object Name : 297
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : PAYMENTCOR
Mode : IX - Intent Exclusive

Lock Name : 0x0200C70121C2EC000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 15516193
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : PAYMENT
Mode : X - Exclusive

Lock Name : 0x0200C701000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 455
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : PAYMENT
Mode : IX - Intent Exclusive

Lock Name : 0x020072014E84B7000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 12026958
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_AUDITTRAIL
Mode : X - Exclusive

Lock Name : 0x020072013784B7000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 1
Lock Object Name : 12026935
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_AUDITTRAIL
Mode : NS - Share (and Next Key Share)

Lock Name : 0x02007201000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 1
Lock Object Name : 370
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_AUDITTRAIL
Mode : IX - Intent Exclusive

Lock Name : 0x170000000100000002008B0056
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Variation
Mode : S - Share

Lock Name : 0x02000302320DF6000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 16125234
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_TOKEN_STAGER
Mode : X - Exclusive

Lock Name : 0x02000302310DF6000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 16125233
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_TOKEN_STAGER
Mode : X - Exclusive

Lock Name : 0x02000302000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 515
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_TOKEN_STAGER
Mode : IX - Intent Exclusive

Lock Name : 0x0200CB013A41EF000000000052
Lock Attributes : 0x00000020
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 15679802
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TRANSACTION_TOKEN
Mode : X - Exclusive

Lock Name : 0x0200CB01000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 459
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TRANSACTION_TOKEN
Mode : IX - Intent Exclusive

Lock Name : 0x020077011481BA000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 12222740
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_SCHEDULE
Mode : X - Exclusive

Lock Name : 0x02007701000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 375
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TXN_SCHEDULE
Mode : IX - Intent Exclusive

Lock Name : 0x0200CA0123C1EE000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 15647011
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TRANSACTION_FEES
Mode : X - Exclusive

Lock Name : 0x0200CA01000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 458
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : TRANSACTION_FEES
Mode : IX - Intent Exclusive

Lock Name : 0x5359534C564C303153544E4441
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Plan
Mode : S - Share

Lock Name : 0x0200530180000000070000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 3
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x0200530180000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 3
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530170000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 48
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530160000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 39
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530150000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 39
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530140000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 39
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530130000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 39
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530120000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 48
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530110000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 48
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x0200530100000000130000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x0200530100000000100000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x0200530100000000090000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x0200530100000000070000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x0200530100000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 39
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x02005301000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 255
Hold Count : 0
Lock Object Name : 339
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : RULES
Mode : IS - Intent Share

Lock Name : 0x02007E0100000000130000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 2
Hold Count : 1
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x02007E0100000000100000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 2
Hold Count : 1
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x02007E0100000000090000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 2
Hold Count : 1
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x02007E0180000000070000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 2
Hold Count : 1
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : IS - Intent Share

Lock Name : 0x02007E01D0000000040000004C
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 2
Hold Count : 1
Lock Object Name : 0
Object Type : Internal - Long/Lob
Mode : S - Share

Lock Name : 0x02007E012F40BD000000000052
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 1
Lock Object Name : 12402735
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : USERPROFILES
Mode : NS - Share (and Next Key Share)

Lock Name : 0x02007E01000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 2
Hold Count : 1
Lock Object Name : 382
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : USERPROFILES
Mode : IS - Intent Share

Lock Name : 0x01000000010000000300B70056
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Variation
Mode : S - Share

Lock Name : 0x4141414141614953534C4E4441
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Plan
Mode : S - Share

Lock Name : 0x0200D1010D49F2000000000052
Lock Attributes : 0x00000020
Release Flags : 0x40000000
Lock Count : 4
Hold Count : 0
Lock Object Name : 15878413
Object Type : Row
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : REMITTANCES
Mode : X - Exclusive

Lock Name : 0x0200D101000000000000000054
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 4
Hold Count : 0
Lock Object Name : 465
Object Type : Table
Tablespace Name : CNTBL32K
Table Schema : CNUSER
Table Name : REMITTANCES
Mode : IX - Intent Exclusive

Lock Name : 0x5359534C564C303153304E4441
Lock Attributes : 0x00000000
Release Flags : 0x40000000
Lock Count : 1
Hold Count : 0
Lock Object Name : 0
Object Type : Internal - Plan
Mode : S - Share

Locks Held: 48
Locks in List: 48
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
We were able to reproduce the deadlock condition in a test program.
We dropped and recreated the index of the table and now the deadlock
doesnt occur anymore. This is wiered because every time we used this
table and index we ensured to do a RUNSTATS on the table before using
it. But after recreating the primary index and doing a RUNSTATS again
the deadlock doesnt occout.
Could anybody suggest why its like this and what solved the problem?
Thanks a bunch for the help.

Rohit
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.