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

Query Defaults

• CICCSU 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) ;
  

  TRANCODE

  TRANCODE=CICACT2 ; ß Must modify to match your settings!
  

  CPCID

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

  DISP_PCT

  DISP_PCT = 100* (CSUPETTM / SUM(CSUPETTM,CSUIOWAT,CSUOTWAT)) ;
  

  IOW_PCT

  IOW_PCT = 100* (CSUIOWAT / SUM(CSUPETTM,CSUIOWAT,CSUOTWAT)) ;
  

  OTHW_PCT

  OTHW_PCT = 100* (CSUOTWAT / SUM(CSUPETTM,CSUIOWAT,CSUOTWAT)) ;