beautypg.com

Example b-5, Enform find query for unstructured process file – HP NonStop G-Series User Manual

Page 181

background image

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)