CA MICS Analyzer Option for CICS (CIC) Queries › CICMAT – CICS Monthly Top 10 Workloads › Query Defaults

Query Defaults

• CICCAU MONTHS timespan file: Cycle 01
• Derivations:

  YRMONTH

  IF DAY(DATEPART(ENDTS)) NE 1
   THEN YRMONTH =DATEPART(ENDTS)-DAY(DATEPART(ENDTS)) +1;
   ELSE YRMONTH = DATEPART(ENDTS) ;
  

  CPCID

  CPCID = TRIM(CPUMOD) || '-' || TRIM(CPCMODID) || '-Serial: ' || SUBSTR(CPCSEQNB,12,5) ;
  

  DISP_PCT

  DISP_PCT = 100* (CAUPETTM / SUM(CAUPETTM,CAUIOWAT,CAUOTWAT)) ;
  

  IOW_PCT

  IOW_PCT = 100* (CAUIOWAT / SUM(CAUPETTM,CAUIOWAT,CAUOTWAT)) ;
  

  OTHW_PCT

  OTHW_PCT = 100* (CAUOTWAT / SUM(CAUPETTM,CAUIOWAT,CAUOTWAT)) ;