CA MICS Analyzer Option for IMS (IMS) Queries › IMSDAT – IMS Daily Top 10 Workloads › IMSDTR – IMS Daily Tran Count and Response Pct › Query Defaults

Query Defaults

• IMSISY DAYS timespan file: CYCLE 01
• HARCPU DAYS timespan file: CYCLE 01 (Used to determine CPCID<->SYSID mapping)
• User code selects yesterday’s data (IF DATEPART(ENDTS) EQ TODAY()-1 ;
• User code defines response goal targets:
  • Response time goal: One (1) second – MACRO VAR &RESPVAL
  • Pct of transactions to meet Response Time Goal: 95% - MACRO VAR GOALPCT
• Derivations:

  DATE

  DATEPART(ENDTS)
  

  CPCID

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

  MEET_CNT

  if imsrval7 <= &RESPVAL then do;
    MEET_CNT=sum(ISYTDST7,ISYTDST6,ISYTDST5,ISYTDST4,
       ISYTDST3,ISYTDST2,ISYTDST1);
    end;
  else if imsrval6 <= &RESPVAL then do;
    MEET_CNT=sum(ISYTDST6,ISYTDST5,ISYTDST4,ISYTDST3,
       ISYTDST2,ISYTDST1);
  end;
  else if imsrval5 <= &RESPVAL  then do;
     MEET_CNT = sum(ISYTDST5,ISYTDST4,ISYTDST3,ISYTDST2,ISYTDST1);
  end;
  else if imsrval4 <= &RESPVAL then do;
     MEET_CNT = sum(ISYTDST4,ISYTDST3,ISYTDST2,ISYTDST1);
  end;
  else if imsrval3 <= &RESPVAL then do;
     MEET_CNT = sum(ISYTDST3,ISYTDST2,ISYTDST1);
  end;
  else if imsrval2 <= &RESPVAL then do;
     MEET_CNT = sum(ISYTDST2,ISYTDST1);
  end;
  else if imsrval1 <= &RESPVAL then MEET_CNT = ISYTDST1;
  

MISS_CNT

= SUM(ISYTRANS,-MEET_CNT) ;

GOAL_PCT

= &GOALPCT ;

MEET_PCT

= (MEET_CNT / ISYTRANS) * 100