CA MICS Analyzer Option for DB2 (DB2) Queries › DB2T10 – DB2 Daily Top Ten Plans by Thread Count › Query Defaults

Query Defaults

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

  DATE

  DATEPART(ENDTS) ;
  

  PLANEXEC

  MAX(DSNPTHRD,SUM(DSPCOMM2,DSPABORT));
  

  AVTCB

  DSPTCBTM / COUNT ;
  

  AVELAPSE

  DSPTELPT / COUNT ;
  

  AVGETPG

  DSPSGPGR / COUNT ;
  

  AVSYNCRD

  DSPSRIO / COUNT ;
  

  AVSYQPF

  DSPSPRFH / COUNT ;
  

  AVMXPGLK

  DSPMXPL / COUNT ;
  

  AVUPDPG

  DSPSSPRU / COUNT ;