ASAP 2.8 Server Manual

Querying the ASAP Database
HP NonStop ASAP Server Manual522303-007
A-2
ASAPCOL as an Enform Server
timestamp-time ( x ) as time "h2:m2" space
cpubusy as i4 space
cpuq as "[bz] i2" space
cpudisp as "[bz] i4" space
discrate as "[bz] i4" space
chitrate as "[bz] i4" space
swaprate as "[bz] i4" space
memq as "[bz] i2" space
pcbmax as "[bz] i4" space
lcbmax as "[bz] i4" space
;
ASAPCOL as an Enform Server
This example shows ASAPCOL as an Enform server:
?section cpu-last-hour
!--------------------!
! Display cpu statistics by \node and cpu for the most recent hour.
! Note: this query uses an enform server to quickly obtain stats.
! Run the stat server as follows: ASAPCOL/ NAME $CPUdb / DB <db prefix>
!----------------------------------------------------------------------!
close net, net-srv, cpu;
open cpu-srv;
declare x,cpubusy,cpuq,cpudisp,discrate,chitrate,swaprate,memq,pcbmax,lcbmax;
set @target-records 0 @stats on;
title "System Cpu Date Time Busy Q Disp Disc Chit Swap MQ Pcbx Lcbx";
subtitle "-------- --- ----- ----- ---- -- ---- ---- ---- ---- -- ---- ----";
list by ihour noprint
x := ( (event.ts - 211024440000000000) /10000 * 65536 ) noprint
cpubusy := avg (busy over ihour) noprint
cpuq := avg (qlen over ihour) noprint
cpudisp := avg (disps over ihour) noprint
discrate := avg (discs over ihour) noprint
chitrate := avg (chits over ihour) noprint
swaprate := avg (swaps over ihour) noprint
memq := avg (mqlen over ihour) noprint
pcbmax := max (pcb-use over ihour) noprint
lcbmax := max (lcb-use over ihour) noprint
after change on ihour print