- 论坛徽章:
- 0
|
db2dump目录下文件涨满问题?
DB2/CS Lock List Formatter
Version 2.1
IBM Toronto Laboratory
-------------------------------------------------------------------------------
-----
Run Timestamp: 11/29/2003 22:17:21
===============================================================================
=====
HDR - Location of the Lock Header
LRB - Location of the Lock Request Block
Lock Modes - ...: None .IN: Intent None
.IS: Intent Share ..S: Share
.IX: Intent Exclusive SIX: Share with Intent Exclusive
.NS: Next Key Share NX: Next Key Exclusive
..U: Update ..X: Exclusive
..Z: Super Exclusive
Lock States - F: Free H: Header
D: Deadlock Victim L: LRB
Lock Status - C: Converting G: Granted W: Waiting
Lock Durations - 0: Instant 1-254: Medium
255: Long
Transaction Wait Flags - C: Converting G: Granted
*: Not Waiting W: Waiting
Transaction States - F: Free R: Read W: Write
C: Commit A: Abort 1: Save1
2: Save2 3: Save3 4: Save4
P: Prepare X: Heur Commit Y: Heur Abort
Z: Huer Aborting U: Forget T: Repair
CMode - Conversion Mode
CDur - Conversion Duration
===============================================================================
=====
>;>;>; Database Name: JDAHIS
Lock Chain Dump --------------------------------------------------------------
-----
HDR=40038d5c HashIndex=168 LockName=00020014000000000000000054
GroupMode=.IX type=tab bj={2;20}
LRB State Status Mode Dur CMode CDur TranHandle HoldCount CursorB
itmap AppHandle
-------- ----- ------ ---- --- ----- ---- ---------- --------- -------
----- --------
40038d80 L G .IX 255 ... 0 2 0 4
0000000 0-166
HDR=40038d14 HashIndex=390 LockName=FDF3FD06081ED7DE211BEDEC41
GroupMode=..S type=PACKAGE: id={4260625670,136239070,555478508}
, loading = 0
LRB State Status Mode Dur CMode CDur TranHandle HoldCount CursorB
itmap AppHandle
-------- ----- ------ ---- --- ----- ---- ---------- --------- -------
----- --------
40038d38 L G ..S 1 ... 0 2 0 4
0000000 0-166
Number of Lock Request Blocks = 2
Transaction Chain Dump -------------------------------------------------------
----------
Transaction 2 Transptr=40020f44 Handle=2 State=1 ProcessID=49812
TID=0000027B7116 GXID= AppHandle= 0-166
NumLRBs=0 (info only, does not reflect # locks held by the
transaction in V3)
Locks Held by Transaction 2:
LRB Header Lock Name S ST Mod Dur CMod CDur Next LRB Hl
dCt CurBits
-------- -------- -------------------------- - -- --- --- ---- ---- -------- --
Locks under chain[0] : 2
40038d80 40038d5c 00020014000000000000000054 L G .IX 255 ... 0 0
0 40000000
40038d38 40038d14 FDF3FD06081ED7DE211BEDEC41 L G ..S 1 ... 0 0
0 40000000
Transaction 2 Transptr=40020f44
Number of Transactions = 1 |
|