TRANSACTIONS 

Use

This table contains information on active transactions in a serverdb.

Structure

TRANSACTIONS

SESSION

FIXED (10)

User session identification

TRANSCOUNT

CHAR ( 20)

Transaction identification

PROCESS

FIXED (10)

User process identification

USERNAME

CHAR ( 32)

User name

CONNECTDATE

DATE

Date of start of session

CONNECTTIME

TIME

Time of start of session

TERMID

CHAR ( 18)

Terminal identification

REQTIMEOUT

CHAR ( 10)

Remaining time until REQUEST_TIMEOUT in seconds

LASTWRITE

CHAR ( 10)

Elapsed time since last write request in timeout intervals

LOCKMODE

CHAR ( 14)

Type of lock

LOCKSTATE

CHAR ( 10)

Status of lock

REQMODE

CHAR ( 14)

Type of lock request

REQSTATE

CHAR ( 10)

Status of lock request

APPLPROCESS

FIXED (10)

Identifier of application process

APPLNODEID

CHAR ( 64)

Identifier of client machine of application process

 

Integration

Statistics system tables