TRANSACTIONS

Definition

The statistics system table TRANSACTIONS contains information about active transactions of a database instance.

Structure

TRANSACTIONS

SESSION

FIXED(10)

ID of the database session

TRANSCOUNT

CHAR(20)

ID of the transaction

SUB_TRANS

FIXED(10)

Number of the current subtransaction

WRITE_TRANS

CHAR(6) BYTE

ID of the current write transaction, if this has made a change

PROCESS

FIXED(10)

ID of the user process

USERNAME

CHAR(32)

User name

CONNECTDATE

DATE

Date of start of session

CONNECTTIME

TIME

Time of start of session

TERMID

CHAR(18)

ID of the terminal

REQTIMEOUT

CHAR(10)

Seconds remaining until time specified in special database parameter REQUEST_TIMEOUT

LASTWRITE

CHAR(10)

Elapsed time since last write request in timeout intervals

LOCKMODE

CHAR(14)

Type of lock (NULL value | SHARE | EXCLUSIVE)

LOCKSTATE

CHAR(10)

Status of lock

REQMODE

CHAR(14)

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

REQSTATE

CHAR(10)

Status of lock request

CONSISTENTVIEW

CHAR(6) BYTE

For future use

APPLPROCESS

FIXED(10)

ID of the application process

APPLNODEID

CHAR(64)

ID of the client computer of the application process

The system table TRANSACTIONS exists only to enable compatibility with older database versions. Instead of the statistics system table TRANSACTIONS, use the system table TRANSACTIONS.