HP NonStop G-Series - Manual (Page 178)

Examples of RECORD Statements and FIND
Queries
Measure User’s Guide —520560-003
B- 2
02 End-SDS TYPE binary 32 unsigned.
02 Start UCL TYPE binary 32 unsigned.
02 End-UCL TYPE binary 32 unsigned.
02 Start-SCL TYPE binary 32 unsigned.
02 End-SCL TYPE binary 32 unsigned.
end
Example B-2. Enform FIND Query for Unstructured CPU File
?DICTIONARY
OPEN cpu, uncpu;
FIND UNIQUE uncpu
(
cpu.loadid,
ascd cpu.cpu-num,
cpu.from-timestamp,
cpu.to-timestamp,
cpu.delta-time,
cpu-busy := ((cpu-busy-time * 100) / cpu.delta-time),
cpu-qlen := (cpu-qtime / cpu.delta-time),
cpu-qlenm := cpu.cpu-qlen-max,
mem-qlen := (mem-qtime / cpu.delta-time),
mem-qlenm := cpu.mem-qlen-max
disp-rate := (dispatches / (cpu.delta-time / 1000000)),
swap-rate := (swaps / (cpu.delta-time / 1000000)),
send-busy := ((send-busy-time * 100) / cpu.delta-time),
disc-rate := (disc-ios / (cpu.delta-time / 1000000)),
chit-rate := (cache-hits / (cpu.delta-time / 1000000)),
tran-rate := (transactions / (cpu.delta-time / 1000000)),
resp-time := (IF transactions > 0
THEN ((response-time / 1000000) / transactions) ELSE 0),
accel-busy := ((cpu.accel-busy-time * 100) / cpu.delta-time),
tns-busy := (( cpu.tns-busy-time * 100) / cpu.delta-time),
comptrap-rate := (cpu.comp-traps / (cpu.delta-time / 1000000)),
tnsr-busy := ((tnsr-busy-time * 100) / cpu.delta-time),
page-sizeb := page-size-bytes,
meminit-lock := mem-initial-lock,
pagereq-rate := (page-requests / (cpu.delta-time / 1000000)),
pagescan-rate := (page-scans / (cpu.delta-time / 1000000)),
Start-freemem := Starting-free-mem,
End-freemem := Ending-free-mem,
Start-UCME := Starting-UCME,
End-UCME := Ending-UCME,
Start-UDS := Starting-UDS,
End-UDS := Ending-UDS,
Start-SDS := Starting-SDS,
End-SDS := Ending-SDS,
Start-UCL := Starting-UCL,
End-UCL := Ending-UCL,
Start-SCL := Starting-SCL,
End-SCL := Ending-SCL,
)
WHERE cpu.delta-time > 0;
Example B-1. DDL RECORD Statement for Unstructured CPU File (page 2 of 2)