B examples of record statements and find queries, B. examples of record statements and find queries, Example b-1 – HP NonStop G-Series User Manual

Page 177: Ddl record statement for unstructured cpu file, Examples of record statements and find queries, Appendix b, examples of record statements and find, Queries

Advertising
background image

Measure User’s Guide 520560-003

B- 1

B

Examples of RECORD Statements
and FIND Queries

This appendix contains examples of Data Definition Language (DDL) RECORD
statements and Enform FIND queries for the CPU and PROCESS entities. The FIND
queries and RECORD statements can be used to create new fields for uninterpreted
counter values. This appendix also contains examples of DDL RECORD statements
that can be used to create alternate-key files for these new fields.

Example B-1. DDL RECORD Statement for Unstructured CPU File (page 1 of 2)

RECORD uncpu. FILE IS uncpu.

02 loadid TYPE character 8.
02 load-id Redefines loadid.
03 prefix-id TYPE character 5.
03 interval-id TYPE character 3.
02 system-name TYPE character 8.
02 os-version.
03 letter TYPE character 1.
03 number TYPE binary 8.
02 cpu-num TYPE binary 16 unsigned.
02 from-timestamp TYPE binary 64.
02 to-timestamp TYPE binary 64.
02 delta-time TYPE binary 64.
02 cpu-type TYPE binary 16 unsigned.
02 cpu-busy TYPE binary 64,3.
02 cpu-qlen TYPE binary 64,3.
02 cpu-qlenm TYPE binary 16 unsigned.
02 mem-qlen TYPE binary 64,3.
02 mem-qlenm TYPE binary 16 unsigned.
02 disp-rate TYPE binary 64,3.
02 swap-rate TYPE binary 64,3.
02 send-busy TYPE binary 64,3.
02 disc-rate TYPE binary 64,3.
02 chit-rate TYPE binary 64,3.
02 tran-rate TYPE binary 64,3.
02 resp-time 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 meminit-lock TYPE binary 32 unsigned.
02 pagereq-rate TYPE binary 64,3.
02 pagescan-rate TYPE binary 64,3.
02 Start-freemem TYPE binary 32 unsigned.
02 End-freemem TYPE binary 32 unsigned.
02 Start-UCME TYPE binary 32 unsigned.
02 End-UCME TYPE binary 32 unsigned.
02 Start-UDS TYPE binary 32 unsigned.
02 End-UDS TYPE binary 32 unsigned.
02 Start-SDS TYPE binary 32 unsigned.

Advertising