LOCK_WAITS

Definition

The system table LOCK_WAITS describes the lock requests.

Structure

LOCK_WAITS

TABLENAME

CHAR(32)

Name of the table

TABLEID

CHAR(8) BYTE

ID of the table

H_TERMID

CHAR(18)

ID of user terminal that holds the lock

H_PROCESS

FIXED(10)

ID of user process that holds the lock

H_APPLPROCESS

FIXED(10)

ID of process on the client hardware that holds the lock

H_APPLNODE

CHAR(64)

ID of client hardware on which the application process runs that holds the lock

H_ROWIDHEX

CHAR(64) BYTE

Start of the key of the locked row in hexadecimal notation

H_ROWID

CHAR(128)

Start of the key of the locked row

H_LOCKMODE

CHAR(14)

Type of lock (NULL value | SHARE | EXCLUSIVE)

H_DATE

DATE(10)

Creation date of the lock

H_TIME

TIME(8)

Creation time of the lock

H_LOCKTIMEOUT

CHAR(10)

Always receives NULL value

R_TERMID

CHAR(18)

ID of user terminal that requests the lock

R_PROCESS

FIXED(10)

ID of user process that requests the lock

R_APPLPROCESS

FIXED(10)

ID of process on the client hardware that requests the lock

R_APPLNODE

CHAR(64)

ID of client hardware on which the application process runs that requests the lock

R_ROWIDHEX

CHAR(64) BYTE

Start of key of requested row in hexadecimal format

R_ROWID

CHAR(128)

Start of key of requested row

R_REQMODE

CHAR(14)

Type of lock request (NULL value | SHARE | EXCLUSIVE)

R_DATE

DATE(10)

Creation date of lock request

R_TIME

TIME(8)

Creation time of lock request

R_REQTIMEOUT

CHAR(10)

Time remaining until REQUEST_TIMEOUT has expired

See also:

Concepts of the Database System, Locking for Database Objects