ASAP 2.8 Server Manual

ASAP Data Definitions
HP NonStop ASAP Server Manual—522303-007
B-12
SQL/MX Query Statistics Definitions
02 ESPBusy-State type binary 16. ! Busy sum of all ESPs cumulative
02 IntESPBusy type binary 32. ! Busy sum of all ESPs for interval
02 IntESPBusy-State type binary 16. ! Busy sum of all ESPs for interval
02 BusyESP type binary 16. ! Busiest ESP
02 BusyESP-State type binary 16. ! Busiest ESP
02 BusyESPSeg type binary 16. ! Busiest ESP's Segment
02 BusyESPSeg-State type binary 16. ! Busiest ESP's Segment
02 BusyESPCPU type binary 16. ! Busiest ESP's CPU
02 BusyESPCPU-State type binary 16. ! Busiest ESP's CPU
02 BusyESPPIN type binary 16. ! Busiest ESP's PIN
02 BusyESPPIN-State type binary 16. ! Busiest ESP's PIN
02 CompTime type float 64. ! Compile time secs
02 CompTime-State type binary 16. ! Compile time secs
02 ExecTime type float 64. ! Execution time secs
02 ExecTime-State type binary 16. ! Execution time secs
02 ErrorCode type binary 64. ! ErrorCode
02 ErrorCode-State type binary 16. ! ErrorCode
02 NumRows type binary 64. ! Rows ins/del/upd
02 NumRows-State type binary 16. ! Rows ins/del/upd
02 RowsAcc type binary 64. ! Rows accessed
02 RowsAcc-State type binary 16. ! Rows accessed
02 RowsRetr type binary 64. ! Rows retrieved
02 RowsRetr-State type binary 16. ! Rows retrieved
02 DiskReads type binary 64. ! Disk reads
02 DiskReads-State type binary 16. ! Disk reads
02 DiskMsgs type binary 64. ! Disk msgs
02 DiskMsgs-State type binary 16. ! Disk msgs
02 DiskBytes type binary 64. ! Disk bytes
02 DiskBytes-State type binary 16. ! Disk bytes
02 LockWaits type binary 64. ! Lock waits
02 LockWaits-State type binary 16. ! Lock waits
02 LockEscal type binary 64. ! Lock escalations
02 LockEscal-State type binary 16. ! Lock escalations
02 Executes type binary 64. ! Total executes
02 Executes-State type binary 16. ! Total executes
02 Type type character 6. !1-insert 2-delete 3-update 4-select
02 Type-State type binary 16. !1-insert 2-delete 3-update 4-select
02 Color type binary 16. ! Color control Attribute
02 Color-State type binary 16. ! Color control attribute
02 StatementID type character 32. ! Statement ID
02 Statement type character 10. !1-execute 2-execdirect 3-prepare 4-fetch
02 SessionID type character 30. ! Session ID
02 QueryID type character 128. ! Query ID
02 SQLText type character 2048. ! SQL Statement
END.
DEFINITION Qry-Stats.
!Description.............Sect
02 system type binary 16 occurs 4 times. ! system name
02 word type binary 16 redefines system.! word alignment handle
02 sysname type character 8 redefines system.
02 P-key-x type *. ! sysno, domain & its 8.3
02 Q-key-x type * redefines P-key-x. ! enform q-key extended
02 event type *. ! ts, interval & info
02 Pid type character 8. ! the process' name
02 Pin type binary 16. ! Pin or 0
02 Type type binary 16. ! Record type
02 AggRec type binary 16. ! AggRec indicator
02 Spare type binary 16 occurs 6 times. ! reserved
02 OpText type binary 16 occurs 10 times. ! Op state text
02 Status type character 1 redefines OpText.
02 OpState type binary 16. ! Operational state
02 Error type binary 64. ! Error (if any)
02 ErrorState type binary 16. ! Error state (or remove)