Returns information from a lock snapshot.
The schema is SYSPROC.
If the null value is specified, -1 is set implicitly.
If both parameters are set to NULL, the snapshot will be taken only if a file has not previously been created by the SNAPSHOT_FILEW stored procedure for the corresponding snapshot API request type.
The function returns a table as shown in the following section.
Column name | Data type | Description or corresponding monitor element |
---|---|---|
SNAPSHOT_TIMESTAMP | TIMESTAMP | snapshot_timestamp - Snapshot timestamp |
AGENT_ID | BIGINT | agent_id - Application handle (agent ID) |
TABLE_FILE_ID | BIGINT | table_file_id - Table file identification |
LOCK_OBJECT_TYPE | BIGINT | lock_object_type - Lock object type waited on |
LOCK_MODE | BIGINT | lock_mode - Lock mode |
LOCK_STATUS | BIGINT | lock_status - Lock status |
LOCK_OBJECT_NAME | BIGINT | lock_object_name - Lock object name |
PARTITION_NUMBER | SMALLINT | node_number - Node number |
LOCK_ESCALATION | SMALLINT | lock_escalation - Lock escalation |
TABLE_NAME | VARCHAR(128) | table_name - Table name |
TABLE_SCHEMA | VARCHAR(128) | table_schema - Table schema name |
TABLESPACE_NAME | VARCHAR(128) | tablespace_name - Table space name |