Skip to end of metadata
Go to start of metadata

HANA_Locks_Transactional_LockWaits_History

Display locked scenarios in a specified time. Can be used in situations where there was a lock on a record but the system has since been restarted to resolve the issue.

Input Parameters

BEGIN_TIME
END_TIME
HOST
PORT
SCHEMA_NAME
TABLE_NAME          
MIN_WAIT_TIME_S
ORDER_BY

Output Parameters

HOST:              Host name
PORT:              Port number
WAIT_SINCE:        Start time of lock wait situation
WAIT_S:            Seconds since lock wait started
WAIT_CONN_ID:      Connection ID of lock waiter
WAIT_TRANS_ID:     Transaction ID of lock waiter
HOLD_CONN_ID:      Connection ID of lock holder
HOLD_TRANS_ID:     Transaction ID of lock holder
SCHEMA:            Schema name of object related to lock wait
TABLE_NAME:        Table name related to lock wait
RECORD_ID:         ID of record related to lock wait
LOCK_TYPE:         Lock type (e.g. TABLE_LOCK, RECORD_LOCK)
LOCK_MODE:         Lock mode (e.g. EXCLUSIVE)

  • No labels