HP NonStop G-Series - Manual (Page 171)

Creating an Enform Report From Measure Data
Measure User’s Guide — 520560-003
A -13
NEWSUBVL—Establishing the Subvolume
Example A-4. FINDPROC Query for Enform Reporting
?DICTIONARY
OPEN process;
OPEN cpu;
OPEN unproc;
LINK process TO cpu VIA cpu-num;
FIND UNIQUE unproc (
process.loadid,
process.from-timestamp,
process.to-timestamp,
process.delta-time,
process.system-name,
process.cpu-num,
process.pin,
process.process-name,
process.program-file-name,
process.priority,
cpu-busy := ((process.cpu-busy-time * 100) / process.delta-time),
atime-busy := (if process.dispatches > 0 then
((process.cpu-busy-time / 1000) / process.dispatches)
else 0),
atime-ready := (if process.dispatches > 0 then
((ready-time / 1000) / process.dispatches) else 0),
atime-memq := (if process.dispatches > 0 then
((process.mem-qtime / 1000) / process.dispatches) else 0),
disp-rate := (process.dispatches / (process.delta-time / 1000000)),
fault-rate := (page-faults / (process.delta-time / 1000000)),
pres-pages := (pres-pages-qtime / process.delta-time),
pres-pagem := pres-pages-max,
ext-segs := (ext-segs-qtime / process.delta-time),
ext-segsm := ext-segs-max,
vsem-rate := (vsems / (process.delta-time / 1000000)),
msg-rate-nr := messages-sent,
msg-rate := (messages-sent / (process.delta-time / 1000000)),
sbyte-rate := (sent-bytes / (process.delta-time / 1000000)),
rbyte-rate := (returned-bytes / (process.delta-time / 1000000)),
recv-qlen := (recv-qtime / process.delta-time),
recv-qlenm := recv-qlen-max,
recv-rate-nr := messages-received,
recv-rate := (messages-received / (process.delta-time / 1000000)),
vbyte-rate := (received-bytes / (process.delta-time / 1000000)),
ybyte-rate := (reply-bytes / (process.delta-time / 1000000)),
link-rate := (mqc-allocations / (process.delta-time / 1000000)),
link-fail := (mqc-alloc-failures / (process.delta-time / 1000000)),
links-inuse := (mqcs-inuse-qtime / process.delta-time),
links-inusem := max-mqcs-inuse,
chkpt-rate := (checkpoints / (process.delta-time / 1000000)),
)
WHERE ((process.cpu-busy-time > 0 OR process.priority = 220)
AND process.delta-time > 0
AND cpu.mqcs > 0)
!** (pri = 220 is to get backup disk processes with no activity)