Lock types for detail trace events
The following table defines the possible lock types and resources for the lock-related detail trace events:
- Detail logical lock - IFCID 21
- Lock Suspension - IFCID 44/45
- Deadlock - IFCID 172
- Timeout - IFCID 196
- Detail physical locks (P-Locks) - IFCIDs 251, 259
Lock type(short) | Lock type(long) | Lock type value | Resource name | Resource number(hexadecimal) |
|---|---|---|---|---|
32K-DESP | 32K-DESPERATION POOL | 0C | Not applicable | Not applicable |
ALTER BP | ALTER BUFFERPOOL | 1A | BP = bpid | Not applicable |
BINDLOCK | AUTOBIND/REMOTE BIND | 17 | BINDLOCK | Not applicable |
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 |
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 |
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-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# |
IX EOF | INDEX END-OF-FILE | 19 | DB = databaseOB = page set | OBID / PART# |
IXTREEPL | INDEX MANAGER TREE P-LOCK | 1C | DB = databaseOB = page set | Not applicable |
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 |
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 |
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 |
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 EXC | UTILITY EXCLUSIVE EXECUTION | 29 | UTEXEC | Not applicable |
UTIL I/O | UTILITY I/O DAMAGE ASSESSMENT | 08 | Not applicable | 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.
Related topic