TRANSACTIONS

Definition

The system table TRANSACTIONS describes the status of all current transactions.

Structure

TRANSACTIONS

TASKID

FIXED(10)

ID of the task

TRANSACTIONID

FIXED(15)

ID of the transaction

STARTDATE

TIMESTAMP

Start time of the transaction

WRITETRANSACTIONID

FIXED(15)

ID of a write transaction

SQLLOCKREQUESTTIMEOUT

FIXED(10)

Timeout for SQL lock requests for database objects (s)

This value may be different than the database parameter.

OMSLOCKREQUESTTIMEOUT

FIXED(10)

Timeout for lock requests for OMS objects (s)

This value may be different than the database parameter.

LASTWRITE

FIXED(10)

Duration of a transaction that has made changes in the database (s)

SQLLOCKMODE

CHAR(14)

Type of lock for SQL database objects (NULL value | SHARE | EXCLUSIVE)

OMSLOCKMODE

CHAR(14)

Type of lock for OMS objects (NULL value | SHARE | EXCLUSIVE)

REQUESTMODE

CHAR(14)

Type of lock in case of a collision with timeout wait situations (NULL-Wert | SHARE | EXCLUSIVE)

HISTORYROOT

FIXED(10)

First page in the chain of history pages

HISTORYLAST

FIXED(10)

Last page in the chain of history pages

HISTORYPAGECOUNT

FIXED(10)

Number of used history pages

LASTHISTORYSEQUENCE

FIXED(10)

Last number assigned for a history entry

CONSISTENTVIEWID

FIXED(15)

ID of the currently valid consistent view

TASKTYPE

CHAR(32)

Task type

See also:

Concepts of the Database System, Transactions, Locking for Database Objects