ASAP 2.8 Server Manual

ASAP Data Definitions
HP NonStop ASAP Server Manual—522303-007
B-11
SQL/MX Query Statistics Definitions
02 Rmsgs type binary 32 redefines MsgsRcvd.
02 MsgsSent type binary 16 occurs 2 times.
02 Smsgs type binary 32 redefines MsgsSent.
02 userinfo type binary 16 unsigned.
02 rfe2 type binary 16 unsigned.
02 rfe3 type binary 16 unsigned.
02 rfe4 type binary 16 unsigned.
02 Elapsedtime type binary 64.
02 PgmFileName type binary 16 occurs 12 times.
02 ProgramName type character 24 redefines PgmFileName.
02 Hometerminal type binary 16 occurs 12 times.
02 HomeTerm type character 24 redefines Hometerminal.
02 ErrorState type binary 16 unsigned.
02 Busy-State type binary 16 unsigned.
02 RcvQLen-State type binary 16 unsigned.
02 MsgsRcvd-State type binary 16 unsigned.
02 MsgsSent-State type binary 16 unsigned.
02 Pages-State type binary 16 unsigned.
02 Lcbs-State type binary 16 unsigned.
02 Spare1 type binary 16 unsigned.
02 Spare2 type binary 16 unsigned.
02 Spare3 type binary 16 unsigned.
02 Spare4 type binary 16 unsigned.
02 Spare5 type binary 16 unsigned.
END.
SQL/MX Query Statistics Definitions
* This defines the structure written to ASAPCOL by the SQL/MX SGP.
DEF QUERY.
02 StartTime type character 20. ! Start time
02 Word type binary 16 redefines StartTim
02 EndTime type character 20. ! End time
02 DataSource type character 48. ! Data Source
02 UserID type character 24. ! UserName
02 Role type binary 32. ! UserID x,y
02 ClientID type character 48. ! Client ID
02 ApplID type character 48. ! Application ID}
02 WallTime type float 64. ! Elapsed time minutes
02 WallTime-State type binary 16. ! Elapsed time minutes
02 SPri type binary 16. ! Start Priority
02 SPri-State type binary 16. ! Start Priority
02 MPri type binary 16. ! Minimum Priority
02 MPri-State type binary 16. ! Minimum Priority
02 Cost type binary 64. ! Estimated cost
02 Cost-State type binary 16. ! Estimated cost
02 TotalBusy type binary 64. ! Busy of all processes cumulative
02 TotalBusy-State type binary 16. ! Busy of all processes cumulative
02 IntTotalBusy type binary 64. ! Busy of all processes for interval
02 IntTotalBusy-State type binary 16. ! Busy of all processes for interval
02 Parallelism type binary 16. ! Parallelism
02 Parallelism-State type binary 16. ! Parallelism
02 ESPs type binary 32. ! Count of ESPs
02 ESPs-State type binary 16. ! Count of ESPs
02 BusyESPs type binary 32. ! Count of Busy ESPs
02 BusyESPs-State type binary 16. ! Count of Busy ESPs
02 BusyVal type binary 16. ! Value ESP considered busy
02 BusyVal-State type binary 16. ! Value ESP considered busy
02 OSrvrBusy type binary 64. ! Busy of OSrvr cumulative
02 OSrvrBusy-State type binary 16. ! Busy of OSrvr cumulative
02 IntOSrvrBusy type binary 16. ! Busy of OSrvr for interval
02 IntOSrvrBusy-State type binary 16. ! Busy of OSrvr for interval
02 ESPBusy type binary 64. ! Busy sum of all ESPs cumulative