HP NonStop G-Series - Manual (Page 170)

Creating an Enform Report From Measure Data
Measure User’s Guide — 520560-003
A -12
NEWSUBVL—Establishing the Subvolume
Example A-2. FUPXCHNG File for Enform Reporting
< SCHEMA PRODUCED DATE - TIME : 12/10/90 09:47:46
< SECTION UNPROC
< Record UNPROC created on 12/10/90 at 09:47
RESET
set ext (20,20), type U
SET REC 278
CREATE UNPROC
< SECTION PROCREP
< Record PROCREP created on 12/10/90 at 09:47
RESET
SET ALTKEY ( "pc", KEYOFF 40, KEYLEN 2, FILE 0 )
SET ALTKEY ( "pn", KEYOFF 44, KEYLEN 8, FILE 0 )
SET ALTKEY ( "pf", KEYOFF 68, KEYLEN 8, FILE 0 )
SET NO ALTCREATE
SET ALTFILE ( 0, PROCREP0 )
set ext (20,20), type E
SET REC 278
SET BLOCK 512
CREATE PROCREP
RESET
set ext (20,20), type K
SET KEYLEN 14
SET REC 14
SET BLOCK 512
SET IBLOCK 512
CREATE PROCREP0
< SECTION BASEREP
< Record BASEREP created on 12/10/90 at 09:48
RESET
set ext (20,20), type E
SET REC 44
SET BLOCK 512
CREATE BASEREP
< SECTION UNBASE
< Record UNBASE created on 12/10/90 at 09:48
RESET
set ext (20,20), type K
SET KEYOFF 0
SET KEYLEN 8
SET REC 44
SET BLOCK 512
SET IBLOCK 512
CREATE UNBASE
Example A-3. FINDBCPU Query for Enform Reporting
?DICTIONARY
OPEN cpu, unbase;
FIND UNIQUE unbase
(
BY cpu.loadid
system-name := cpu.system-name
os-version := cpu.os-version
from-timestamp := MIN(cpu.from-timestamp OVER cpu.loadid)
to-timestamp := MAX(cpu.to-timestamp OVER cpu.loadid)
delta-time := MAX(cpu.delta-time OVER cpu.loadid)
cpu-type := cpu.cpu-type
);