AppSrvStatus Data Collector

"AppSrvStatus" Data Collector


For a detailed discussion of these metrics, see "Classic" App Servers (A) and ProTop Trends - Application Servers

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_apsv, tt_apsvList     (temptable name)
tt_apsv.apsvDBAccess Blk Acc num Number of Database Block Access Requests by this server
tt_apsv.apsvLineNum Line# num If CSC is enabled, contains the line number of the program currently executing
tt_apsv.apsvName Broker char The name of the broker, as defined in ubroker.properties that started this server
tt_apsv.apsvOSRead OS Rd num Number of OS reads generated by this app server
tt_apsv.apsvOSWrite OS Wr num Number of OS writes generated by this app server
tt_apsv.apsvPID PID num Operating System Process ID
tt_apsv.apsvPort Port num Port Number this app server is listening to
tt_apsv.apsvProc Program Name char If CSC is enabled, contains the name of the program currently executing
tt_apsv.apsvReq Requests num The number of requests made of the application server
tt_apsv.apsvStatus Status char Many possible values. The most common are "Available," "Busy," "Locked" and "Sending."
tt_apsv.apsvType Type char AppServer or WebSpeed Broker
tt_apsv.apsvUsr Usr# num The database user number associated with the AppServer. The AppServer may not be connected to the monitored database, so this value could be "?"
tt_apsv.apsvWait Wait char Lists what the user is waiting for, usually RECord. Followed by flags eXclusive, Queued, and/or Hold
tt_apsv.lastUpd CSC Age char If enabled, the number of seconds since the user's Client Statement Cache (CSC) was last updated
tt_apsvList.asActCli ActCli num The current number of active client connections
tt_apsvList.asActive Actv num Number of running agent processes
tt_apsvList.asAvail Avail num Number of servers available to service requests
tt_apsvList.asAvgLen   num  
tt_apsvList.asAvgWt Avg Wt num  
tt_apsvList.asBusy Busy num Number of busy servers
tt_apsvList.asClUsePct Cli% num Number of active client connections as a percentage of maximum number of client connections allowed
tt_apsvList.asCommand   char  
tt_apsvList.asCurrQ CurrQ num The current request queue length
tt_apsvList.asLocked Lckd num Number of Locked Servers
tt_apsvList.asMaxCliInst MaxCli num Maximum number of client connections permitted
tt_apsvList.asMaxLen   num  
tt_apsvList.asMaxQ MaxQ num High water mark of requests in the queue
tt_apsvList.asMaxSrvInst MaxSrv num Maximum number of agents that the broker can start
tt_apsvList.asMaxWt Max Wt num Maximum number of waits this application server has experienced
tt_apsvList.asMode Mode char Stateless, State-free, State-reset or State-aware
tt_apsvList.asName Broker char Name of the broker as defined in ubroker.properties
tt_apsvList.asNote   char  
tt_apsvList.asPid PID num Operating System Process ID
tt_apsvList.asPort Port num Listening Port Number
tt_apsvList.asSending Sndg num Number of sending servers
tt_apsvList.asSrUsePct Srvr% num Sum of Busy, locked and sending agents as a percentage of MaxSrv
tt_apsvList.asStuck Stuck num The number of agents that remain in sending mode when that number exceeds the 'APPSRVSTUCK' threshold set in $PROTOP/etc/localenv
tt_apsvList.asType Type char AppServer or WebSpeed Broker ...
       
tt_apsvList.zasCliHWM   num This alertable field is not displayed and contains the high water mark of connected clients
tt_apsvList.zasSrInUse   num This alertable field is not displayed and contains the sum of busy, locked and sending agents
tt_apsvList.zosType   char The type of operating system the application server is running on