"ActiveTRX" Data Collector
For a detailed discussion of these metrics, see ProTop Real-Time - Active Transactions (x) and ProTop Trends - Advanced 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 |