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

  CPCID = PUT(SYSID,$CPCFMT.) ;
  

  JOBRANK

  PUT(COUNT,Z2.) || ' - ' || JOB ;
  

  where COUNT is the rank of resource use (e.g., 01 is largest resource user)
  

  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).