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)

Identification of the database session

TRANSCOUNT

CHAR(20)

Identification of the transaction in the database session

PROCESS

FIXED(10)

Identification of the process in the database

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)

Identification 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)

Identification of the process on the client hardware

APPLNODE

CHAR(64)

Identification 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

Identification 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

LOCK_WAITS

Evaluating System Tables, LOCKS

Concepts of the Database System, Locks