Object documentationLOCKS Locate this document in the navigation structure

 

The system table DOMAIN.LOCKS describes the current lock entries and entries for lock requests.

Structure

LOCKS

SESSION

FIXED(10)

ID of the database session

TRANSCOUNT

CHAR(20)

ID of the transaction in the database session

PROCESS

FIXED(10)

ID of the process in the database instance

USERNAME

CHAR(32)

Name of the user

DATE

DATE

Start date of database session that holds the lock

TIME

TIME

Start time of database session that holds the lock

TERMID

CHAR(18)

ID of the user

LASTWRITE

CHAR(10)

Elapsed time since the last SQL statement for data manipulation

LOCKMODE

CHAR(14)

Type of lock (NULL value | SHARE | EXCLUSIVE)

LOCKSTATE

CHAR(10)

Status of lock

APPLPROCESS

FIXED(10)

ID of the process on the client hardware

APPLNODE

CHAR(64)

ID of the client hardware

SCHEMANAME

CHAR(32)

Name of the table schema

OWNER

CHAR(32)

Name of the owner of the table

TABLENAME

CHAR(32)

Name of the table

TABLEID

CHAR(8) BYTE

ID of the table

ROWIDLENGTH

FIXED(4)

Length of the key of the locked row

ROWIDHEX

CHAR(64) BYTE

Start (prefix) of the key of the locked row in hexadecimal notation

ROWID

CHAR(128)

Start (prefix) of the key of the locked row

More Information

Evaluating System Tables, LOCKS

Concepts of the Database System, Locks