LOCKS

Definition

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

Structure

LOCKS

SESSION

FIXED(10)

ID of the database session

TRANSCOUNT

CHAR(20)

Transaction identification in the database session

PROCESS

FIXED(10)

Process identification in the database instance

USERNAME

CHAR(32)

Name of the user

DATE

DATE(10)

Creation date of the lock

TIME

TIME(8)

Creation time of the lock

TERMID

CHAR(18)

User terminal identification

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)

Process identification on the client hardware

APPLNODE

CHAR(64)

Client hardware identification

SCHEMANAME

CHAR(32)

Name of the schema of the table

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 of the key of the locked row in hexadecimal notation

ROWID

CHAR(128)

Start of the key of the locked row

See also:

Evaluating System Tables, LOCKS

Concepts of the Database System, Locking for Database Objects