ActiveTRX Data Collector

"ActiveTRX" Data Collector

For a detailed discussion of these metrics, see ProTop Real-Time - Active Transactions (x) and ProTop Trends - Main Dashboard.

To set up an alert on a metric listed here, make note of the Data Collector name at the top of this page, the Alertable Metric and Data Type from the table below and visit Alert Configuration.

Alertable Metric ProTop RT Label Data Type Description
tt_trx     (temptable name)
duraStr Duration char Age of Transaction as HH:MM:SS
duration   num Age of Transaction in seconds
idleStr Idle char Database Idle Time as HH:MM:SS
idleTime   num Database Idle Time in seconds
trx-num TRX# num Unique Transaction Number
trx-rl BIClstr num The BI cluster number at the start of this transaction
trx-st Stat char Transaction Status
trx-wait Wait Resource (dbkey) char Indicates if the transaction is waiting on something and what that something is. "–" means the transaction is not waiting
userDev Device char The user's device. For a shared memory session this is a tty and for a client/server connection it is the hostname or IP address of the client
userFlags Flags char See Flags under ProTop Real-Time - Active Transactions (x)
userName Name char User login name
userPID PID char Operating System process id
usrnum Usr# num Unique database user number
zdbAccess   num Number of Logical IO operations performed by this transaction
ztrxStart   char Start Time of the transaction as HH:MM:SS