473,386 Members | 1,621 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

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

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
1 4210
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Daniel Chou | last post by:
Hello, We are runnig DB2 on AIX and have DB2 deadlock problem. Is there any way or any tool to find out which SQL statements cause the deadlock? Thanks a lot.
8
by: Javauser | last post by:
Hi there we are getting the following db2 error on executeBatch() method that inserts n rows on a table (where n is between 50 and 200). SQL0911N The current transaction has been rolled...
0
by: Kin | last post by:
Dear all, Thank you very much for your help in advance. I am using DB2 on AS400. Recently, I receive deadlock message from developers. I would like to do following tasks. Could anyone teach me...
3
by: Nigel Robbins | last post by:
Hi There, I'm getting a deadlock when I have two clients running the following statement. DELETE FROM intermediate.file_os_details WHERE file_uid = ? AND obj_uid There is a compound index on...
6
by: Todd McNeill | last post by:
Hi- We ran into some very strange deadlocks this AM, and I was hoping to get some insight. We were running a REORGCHK on a database, and started getting deadlocks. What is curious is that...
0
by: henrycortezwu | last post by:
Hi All, We are experiencing the ff error from time to time in our web production server, found in the event viewer. Event Type: Error Event Source: ASP.NET 1.1.4322.0 Event Category: None Event...
13
by: Jonathan Amsterdam | last post by:
I think there's a slight design flaw in the Queue class that makes it hard to avoid nested monitor deadlock. The problem is that the mutex used by the Queue is not easy to change. You can then...
3
by: kavin | last post by:
hi, can any one help me in detecting a deadlock and to clear the deadlock when it occours? how to monitor the databases for deadlocks?
3
by: Arun Srinivasan | last post by:
Please correct me if I am wrong 1. no 2 processes can have exclusive lock on same object (by object, same row or same table) 2. on deadlock incident between 2 processes only one of them will be...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.