CA MICS Batch and Operations Analyzer (SMF) Queries › Top 10 Resource Users › SMFUJT – SMF Daily Top 10 Unix SysSrv Jobs › Query Defaults

Query Defaults

• HARCPU DETAIL timespan file: Cycle 01
• BAT_OE DETAIL timespan file: Cycles 01-02
• User code selects yesterday’s data (IF DATEPART(ENDTS) EQ TODAY()-1 ;
• Derivations:

  DATE

  DATEPART(ENDTS)
  

  CPCID

  TRIM(LPCMOD)||'-'||TRIM(CPCMODID)||'-Serial: '||SUBSTR(CPCSEQNB,12,5);
  

  TOTCPU

  SUM(PGMTCBTM,PGMSRBTM,PGMHIPTM,PGMRCTTM,PGMIOITM,
  PGMSPNTM,PGMZPNTM,PGMISRTM,PGMITCTM) ;
  

  INTVLCNT

  INTVLCNT=1 ;
  

  (uses existing data element PGMCOACT=1 in the initial input user code, then after summarization sets INTVLCNT=PGMCOACT to deal with Q&R default of treating Q&R derived elements as retained values in summarization).