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