Example a-5, Qdproc query for enform reporting, Ough – HP NonStop G-Series User Manual

Page 172

Creating an Enform Report From Measure Data

Measure User’s Guide — 520560-003

A -14

NEWSUBVL—Establishing the Subvolume

Example A-5. QDPROC Query for Enform Reporting (page 1 of 3)

!=============== Measure analysis by process-group
?DICTIONARY
SET @DATE-FORMAT TO "M2-D2-Y2"
SET @WIDTH TO 132;
SET @LINES TO 54;

DECLARE TEST-DATE AS DATE *
SERVICE-TIME INTERNAL F19.3
CPU-TIME INTERNAL F19.3
AR-TIME INTERNAL F19.3
AB-TIME INTERNAL F19.3
DLTA-FACT INTERNAL F19.3

OPEN PROCREP;
OPEN BASEREP;

LINK BASEREP.B-LOADID TO PROCREP.LOADID;

LIST

BY LOADID NOPRINT

BY CPU-NUM HEADING "CPU/NUM"

BY PROGRAM-FILE-NAME.NAME HEADING "PROGRAM/NAME"

BY PROCESS-NAME

DLTA-FACT := (PROCREP.DELTA-TIME / BASEREP.B-DELTA-TIME)
NOPRINT

((CPU-BUSY * 10.) * DLTA-FACT)
AS I4
HEADING "CPU/MSEC/SEC"
SUBTOTAL OVER CPU-NUM
TOTAL
((ATIME-MEMQ * DISP-RATE) * DLTA-FACT)
AS I4
HEADING "FALT/MSEC/SEC"
SUBTOTAL OVER CPU-NUM
TOTAL

(PRES-PAGES + EXT-SEGS)
AS I4
HEADING "MEM/PAGES"

RECV-QLEN
AS F4.1
HEADING "RECV/QLEN"

(ATIME-READY / ATIME-BUSY)
AS F4.1
HEADING "READY/BUSY/RATIO"