TRANSACTIONS
The system table SYSINFO.TRANSACTIONS
describes the status of all current transactions.
|
FIXED(10) |
ID of the task |
|
FIXED(15) |
ID of the transaction |
|
TIMESTAMP |
Start time of the transaction |
|
FIXED(15) |
ID of a write transaction |
|
FIXED(10) |
Timeout for SQL lock requests for database objects (s). This value may be different than the database parameter. |
|
FIXED(10) |
Timeout for lock requests for OMS objects (s). This value may be different than the database parameter. |
|
FIXED(10) |
Duration of a transaction that has made changes in the database (s) |
|
CHAR(14) |
Type of lock for SQL database objects ( |
|
CHAR(14) |
Type of lock for OMS objects ( |
|
CHAR(14) |
Type of lock in case of a collision with timeout wait situations ( |
|
FIXED(10) |
First page in the chain of history pages |
|
FIXED(10) |
Last page in the chain of history pages |
|
FIXED(10) |
Number of used history pages |
|
FIXED(10) |
Last number assigned for a history entry |
|
FIXED(15) |
ID of the currently valid consistent view |
|
CHAR(32) |
Task type |
Concepts of the Database System, Transactions, SQL Locks