Example b-5, Enform find query for unstructured process file – HP NonStop G-Series User Manual
Page 181
![background image](/manuals/397027/181/background.png)
Examples of RECORD Statements and FIND
Queries
Measure User’s Guide —520560-003
B- 5
02 fault-rate TYPE binary 64,3.
02 pres-pages TYPE binary 64,3.
02 pres-pagem TYPE binary 16 unsigned.
02 ext-segs TYPE binary 64,3.
02 ext-segsm TYPE binary 16 unsigned.
02 vsem-rate TYPE binary 64,3.
02 msg-rate TYPE binary 64,3.
02 sbyte-rate TYPE binary 64,3.
02 rbyte-rate TYPE binary 64,3.
02 recv-qlen TYPE binary 64,3.
02 recv-qlenm TYPE binary 16 unsigned.
02 recv-rate TYPE binary 64,3.
02 vbyte-rate TYPE binary 64,3.
02 ybyte-rate TYPE binary 64,3.
02 link-rate TYPE binary 64,3.
02 link-fail TYPE binary 64,3.
02 links-inuse TYPE binary 64,3.
02 links-inusem TYPE binary 16 unsigned.
02 chkpt-rate TYPE binary 64,3.
02 accel-busy TYPE binary 64,3.
02 tns-busy TYPE binary 64,3.
02 comptrap-rate TYPE binary 64,3.
02 tnsr-busy TYPE binary 64,3.
02 page-sizeb TYPE binary 16 unsigned.
02 allocseq-rate TYPE binary 64,3.
02 UCLqlen TYPE binary 64,3.
02 UCLmax TYPE binary 16 unsigned.
02 fileopen-rate TYPE binary 64,3.
02 infocall-rate TYPE binary 64,3.
end
Example B-5. Enform FIND Query for Unstructured PROCESS File (page 1 of 2)
?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 := ((process.cpu-busy-time / 1000) / process.dispatches),
atime-ready := ((ready-time / 1000) / process.dispatches),
atime-memq := ((process.mem-qtime / 1000) / process.dispatches),
Example B-4. DDL RECORD Statement for Unstructured PROCESS
File (page 2 of 2)