The MON_FORMAT_LOCK_NAME table function formats the internal lock name and returns details regarding the lock in a row-based format.
Each returned row consists of a key-value pair relevant for that particular lock.
To get information about locks, use the MON_FORMAT_LOCK_NAME, MON_GET_LOCKS, and, MON_GET_APPL_LOCKWAIT table functions instead of the SNAPLOCKWAIT administrative view and SNAP_GET_LOCKWAIT table function, and the SNAPLOCK administrative view and SNAP_GET_LOCK table function, which are deprecated in Fixpack 1 of Version 9.7.
None
The schema is SYSPROC.
Column name | Data type | Description |
---|---|---|
NAME | VARCHAR(256) | Element of the lock name. See following table for more details. |
VALUE | VARCHAR(1024) | Value of the element. |
Not all elements that make up the specified lock name are returned; only those key-value pairs that are relevant are returned.
Element name | Description | Possible values or monitor element |
---|---|---|
LOCK_OBJECT_TYPE | lock_object_type - Lock object type waited on monitor element | lock_object_type - Lock object type For possible values, see "lock_object_type - Lock object type waited on monitor element". |
DATA_PARTITION_ID | data_partition_id - Data partition identifier monitor element | data_partition_id - Data partition identifier |
TBSP_NAME | The name of a table space | tablespace_name - Table space name |
TABSCHEMA | table_schema - Table schema name monitor element | table_schema - Table schema name |
TABNAME | table_name - Table name monitor element | table_name - Table name |
ROWID | Row ID of the table | - |
PAGEID | The page ID | - |
WORKLOAD_NAME | workload_name - Workload name monitor element | workload_name - Workload name |
STORAGE_GRP_ID | The storage group ID | - |
BUFFERPOOL_NAME | Name of the buffer pool | - |
FED_SERVER_NAME | Name of the federation server | - |
FED_USER_NAME | Name of the federation user mapping | - |
SEQ_OPERATION | Operation requesting a sequence lock | Possible values are:
|
CONTAINER_ID | container_id - Container identification monitor element | - |
STMT_UID | The statement ID | - |
PACKAGE_TOKEN | The package token | - |
INTERNAL | Reserved for internal use | - |
SELECT SUBSTR(NAME,1,20) AS NAME,
SUBSTR(VALUE,1,50) AS VALUE
FROM
TABLE( MON_FORMAT_LOCK_NAME('0000000E00000000000B00C152')) as LOCK
NAME VALUE
-------------------- -------------
LOCK_OBJECT_TYPE ROW
ROWID 0
DATA_PARTITION_ID 49408
PAGEID 184549376
TBSP_NAME SYSCATSPACE
5 record(s) selected.