Object documentationLOCK_WAITS Locate this document in the navigation structure

 

The system table DOMAIN.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 (prefix) of the key of the locked row in hexadecimal notation

H_ROWID

CHAR(128)

Start (prefix) of the key of the locked row

H_LOCKMODE

CHAR(14)

Type of lock (NULL value | SHARE | EXCLUSIVE)

H_DATE

DATE

Start date of database session that holds the lock

H_TIME

TIME

Start time of database session that holds 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 (prefix) of the key of the requested row in hexadecimal notation

R_ROWID

CHAR(128)

Start (prefix) of the key of the requested row

R_REQMODE

CHAR(14)

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

R_DATE

DATE

Start date of database session that requests the lock

R_TIME

TIME

Start time of database session that requests the lock

R_REQTIMEOUT

CHAR(10)

Time remaining until request timeout has expired

More Information

Concepts of the Database System, Locks