db2诊断系列之－－-定位锁等待问题

核心提示：Slot 2:Offset Location = 2916 (xB64)Record Length = 76 (x4C)Record Type = Table Directory RecordMetaIndex Root Page = 157377Index Type = 2Table Descriptor Poi

Slot 2:

Offset Location = 2916 (xB64)
Record Length = 76 (x4C)

Record Type = Table Directory Record

MetaIndex Root Page = 157377
Index Type = 2
Table Descriptor Pointer -- Page 157312 Slot 3
Max Insert Search = 0
Flags = x02000200
bit representation = 00000010 00000000 00000010 00000000
Check pending info:
Constraint status = x00
Constraint RID = Page 0 Slot 0
last BID = x00000000

Slot 3:

Offset Location = 2892 (xB4C)
Record Length = 24 (x18)

Record Type = Table Description Record

Number of Columns = 2

Column 1:
Type is Long Integer
Length = 4
Prohibits NULLs
Prohibits Default
Fixed offset: 0

Column 2:
Type is Fixed Length Character String
Length = 10
Allows NULLs
Prohibits Default
Fixed offset: 4

Slot 4:

Offset Location = 2869 (xB35)
Record Length = 23 (x17)

Record Type = Table Data Record (FIXEDVAR)

Fixed part length value = 15

Column 1:
Fixed offset: 0
Type is Long Integer
Value = 1

Column 2:
Fixed offset: 4
Type is Fixed Length Character String
61202020 20202020 2020 a

Slot 5:

Offset Location = 2846 (xB1E)
Record Length = 23 (x17)

Record Type = Table Data Record (FIXEDVAR)

Fixed part length value = 15

Column 1:
Fixed offset: 0
Type is Long Integer
Value = 2

Column 2:
Fixed offset: 4
Type is Fixed Length Character String
61202020 20202020 2020 a

Slot 6:

Offset Location = 2823 (xB07)
Record Length = 23 (x17)

Record Type = Table Data Record (FIXEDVAR)

Fixed part length value = 15

Column 1:
Fixed offset: 0
Type is Long Integer
Value = 3

Column 2:
Fixed offset: 4
Type is Fixed Length Character String
61202020 20202020 2020 a

Slot 7:

Offset Location = 2800 (xAF0)
Record Length = 23 (x17)

Record Type = Table Data Record (FIXEDVAR)

Fixed part length value = 15

Column 1:
Fixed offset: 0
Type is Long Integer
Value = 4

Column 2:
Fixed offset: 4
Type is Fixed Length Character String
61202020 20202020 2020 a

Slots Summary: Total=8, In-use=8, Deleted=0.

Table object report phase end.
______________________________________

DB2DART Processing completed with warning(s)!
Warning(s) detected during processing.
______________________________________

Complete DB2DART report found in:
/home/db2inst1/sqllib/db2dump/DART0000/EOS.RPT
_______ D A R T P R O C E S S I N G C O M P L E T E _______

找到Solt 7 (0x07)，ok，你现在可以清楚的知道应用等待的Row为(4,a)