"who" Data Collector
For a detailed discussion of these metrics, see ProTop Real-Time - Who Is Connected (W).
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_who | (temptable name) | ||
| connectAge | Duration | char | Length of time connected to the database |
| lastUpd | CSC Age | char | If enabled, the number of seconds since the user's Client Statement Cache (CSC) was last updated |
| lineNum | Line# | num | If CSC is enabled, line number of currently executing program |
| procName | Program Name | char | If CSC is enabled, name of the currently execuring program |
| statTRX | TRX Stat | char | Transaction Status |
| usrBlk | Blkd | char | User is waiting for a database-related resource |
| usrIPAddr | Device | char | Connected device or, if remote client, the IP Address |
| usrName | Name | char | Name associated with Usr# |
| usrNum | Usr# | num | Database connection user number |
| usrServ | Server | num | Number of the server managing the remote client |
| usrType | Flags | char | User type. Most likely one of the following: SELF service, BROKer, SERVer, REMote & PT3 - ProTop |
| whoPID | PID | char | Operating system process ID |