Lock types for detail trace events
Lock type(short) | Lock type(long) | Lock type value | Resource name | Resource number(hexadecimal) |
|---|---|---|---|---|
32K-DESP | 32K-DESPERATION POOL | 0C | Not applicable | Not applicable |
ADD PART | ADD PARTITION SERIALIZATION | 36 | DB = database | Not applicable |
ALTER BP | ALTER BUFFERPOOL | 1A | BP = bpid | Not applicable |
ACCELER | ACCELERATOR SERVICES COMMANDS | 3F | ACCEL SERVICES COMMANDS | Not applicable |
BINDLOCK | AUTOBIND/REMOTE BIND | 17 | BINDLOCK | Not applicable |
BUFF MGR | BUFFER MGR PAGESET RR P-LOCK | 2E | DB = database OB = pageset | BPID / DBID / OBID / Part# |
CATM CAT | CATMAINT CONVERT CATALOG | 25 | DB = databaseOB = page set | Not applicable |
CATM DIR | CATMAINT CONVERT DIRECTORY | 24 | DB = databaseOB = page set | Not applicable |
CATM MIG | CATMAINT MIGRATION | 26 | DB = databaseOB = page set | Not applicable |
CDB PLOK | CDB P-LOCK (DDF) | 1F | DB = database | Not applicable |
CDDS BLD | COMPRESSION DICTIONARY BUILD | 3A | DB = database OB = pageset | Part# |
CDDS DRP | COMPRESSION DICT DROP CLEANUP | 4B | CDDS_DRP | Not applicable |
CDDS LOA | COMPRESSION DICTIONARY LOAD | 3B | DB = database OB = pageset | Part# |
COLLECTN | COLLECTION | 13 | CI = collection ID | Not applicable |
CS-DRAIN | CURSOR STABILITY DRAIN | 14 | DB = databaseOB = page set | Part# / 0 |
DATABASE | DATABASE | 01 | DB = database | Not applicable |
DATAPAGE | DATA PAGE | 00 | DB = databaseOB = page set | Page# |
DBALLOC | DBALLOC - START/STOP | 0A | DB = databaseOB = page set | Part# / 0 |
DBCMDSER | DB COMMAND SERIALIZATION | 2D | DB = database | Not applicable |
DBD PLOK | DBD P-LOCK | 23 | DB = database | Not applicable |
DGTTURID | DECLARE GLOBAL TEMP TBL URID | 3E | DB = database OB = pageset | Unit of recovery ID (URID) |
DYNQ AUT | SYSDYNQRY AUTH DEPENDENCY | 48 | SA = stabilization aname | Stabilization auth dependency lock name |
DYNQ HSH | SYSDYNQRY HASH_ID | 42 | HI = hash ID | SQLID (1st 12 bytes) |
DYNQ OBJ | SYSDYNQRY OBJECT DEPENDENCY | 47 | SO = stabilization oname | Stabilization object dependency lock name |
DYNQ STB | SYSDYNQRY STBLGRP | 43 | SG = stabilization gname | Stabilization group name or hash |
FTB PLOK | FAST TRAVERSE BLOCK P-LOCK | 49 | DB = database OB = pageset | DBID / OBID / Part# |
GBP CAST | GROUP BP CASTOUT P-LOCK | 20 | BP = bpid | Not applicable |
GP EX UP | GROUP DB EXCEPTION UPDATE | 2B | DX = GDBET | Not applicable |
GROUP BP | GROUP BP START/STOP | 1B | BP = bpid | Not applicable |
HASH BKT | HEADER PAGE HASH BUCKET | 33 | DB = databaseOB = page set | Part# / Hash# / 0 |
HASH VAL | HASH VALUE | 3C | DB = database OB = pageset | Hash value |
HASH-ANC | HASH ANCHOR | 11 | DB = databaseOB = page set | Page#Anchor |
INDEXPAG | INDEX PAGE(# = x’000002FF’, index root page) | 05 | DB = databaseOB = page set | Page#Subpage# |
INDX KEY | INDEX KEY | 3D | DB = database OB = pageset | Not applicable |
IX EOF | INDEX END-OF-FILE | 19 | DB = databaseOB = page set | OBID / PART# |
IXTREEPL | INDEX MANAGER TREE P-LOCK | 1C | DB = databaseOB = page set | DBID / OBID / Part# |
LOB | LOB LOCK | 30 | DB = databaseOB = page set | Row ID / Version # |
LPL RCVY | LPL RECOVERY | 32 | DB = databaseOB = page set | not applicable |
LPL/GREC | LPL/GRECP DB EXCEPTION | 27 | DB = databaseOB = page set | Part# / 0 |
MASSDEL | MASS DELETE | 0F | DB = databaseOB = page set | Not applicable |
NEW FUNC | ACTIVATE NEW FUNCTION | 4A | ACTIVATE | Not applicable |
OPEN | OPEN PAGESET / DATASET | 07 | DB = databaseOB = page set | Not applicable |
P/P CAST | PAGESET/PARTITION CASTOUT PLOK | 21 | DB = databaseOB = page set | BPID / DBID / OBID / Part# |
P/P PLOK | PAGESET/PARTITION P-LOCK | 1D | DB = databaseOB = page set | BPID / DBID / OBID / Part# |
PAGE PLK | PAGE P-LOCK | 1E | BP = bpidDB = databaseOB = page set | BPID / DBID / OBID / Part# / Page# |
PAGESET | PAGE SET | 02 | DB = databaseOB = page set | Not applicable |
PART-DS | PARTITIONED DATASET | 03 | DB = databaseOB = page set | Part# |
PARTLOCK | PARTITION LOCKING | 06 | DB = databaseOB = page set | Part# |
PIECE | PAGE SET PIECE | 09 | DB = databaseOB = page set | Not applicable |
PITR | POINT-IN-TIME-RECOVERY | 34 | SYS_PITR | Not applicable |
REPR DBD | REPAIR DBD TEST/DIAGNOSE | 2C | DB = database | Not applicable |
REST SVC | REST SERVICE CREATE/DROP | 4C | REST SERVICES | Not applicable |
RETRY | RETRY GETPAGE DURING ABORT | 0B | Not applicable | Not applicable |
RLF PLOK | RLF P-LOCK | 22 | DB = databaseOB = page set | Not applicable |
ROW | ROW | 18 | DB = databaseOB = page set | Page#RID |
RR-DRAIN | REPEATABLE READ DRAIN | 15 | DB = databaseOB = page set | Part# / 0 |
SCA ACC | SCA ACCESS - RESTART/REDO | 2A | SC = BMC-RSTP | Not applicable |
SERVICE | SERVICEABILITY | 2F | (not identified) | Not applicable |
SKCT | SKELETON CURSOR TABLE | 04 | CT = planname | Not applicable |
SKPT | SKELETON PACKAGE TABLE | 12 | CI = collection, package, token | Not applicable |
SYSENV | SYSENV SERIALIZATION | 37 | SYSENVRL | Not applicable |
SYSLGRNG | SYSLGRNG RECORDING | 0D | DB = databaseOB = page set | Not applicable |
TABLE | TABLE | 10 | DB = databaseOB = object | Not applicable |
UNKN | UNKNOWN (undefined lock) | Not applicable | Not applicable | |
UTIL CAT | UTILITY CATALOG SERIALIZATION | 41 | DB = database OB = pageset | Not applicable |
UTIL COM | UTILITY COMMIT | 31 | COM.unique | Not applicable |
UTIL EXC | UTILITY EXCLUSIVE EXECUTION | 29 | UTEXEC | Not applicable |
UTIL HSH | UTILITY OBJECT WITH HASH | 40 | DB = database OB = pageset | Not applicable |
UTIL I/O | UTILITY I/O DAMAGE ASSESSMENT | 08 | Not applicable | Not applicable |
UTIL OBJ | UTILITY OBJECT | 38 | DB = database OB = pageset | Not applicable |
UTILSER | UTILITY SERIALIZATION | 0E | UTSERIAL | Not applicable |
UTILUID | UTILITY UID | 28 | UI = utility ID | Not applicable |
WR-DRAIN | WRITE DRAIN | 16 | DB = databaseOB = page set | Part# / 0 |
XML | EXTENSIBLE MARKUP LANGUAGE | 35 | DB = databaseOB = page set | DocID |
- Page# is 0 for unlocks.
- P-Locks do not cause timeouts or deadlocks, so they do not appear for these events.