CA MICS Analyzer Option for MQSeries (MQS) Queries › MQSBPA – MQ Daily Buffer Pool Analysis › Query Defaults

Query Defaults

• MQSBMS DAYS timespan file: Cycles 01 and 02
• User code selects yesterday’s data (IF DATEPART(ENDTS) EQ TODAY()-1 ;
• Derivations:

  DATE

  DATEPART(ENDTS)
  

  BMSTGETS

  SUM(BMSGETN, BMSGETP, BMSSTL);