CA MICS Hardware and SCP Analyzer (RMF) Queries › Mainframe MSU Utilization and LPAR Capping › RMFMC4 – Daily z/OS LPAR MSU Use Cap and 4 Hour Avg › Query Defaults

Query Defaults

• HARCPU DETAIL timespan file: Cycles 01 - 02
• Filters: PRSMUSCT GT 0 (only PR/SM managed LPARs)
• User code excludes today’s data (IF DATEPART(ENDTS) EQ TODAY()-1 ;
• Derivations:

  CPCID

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

  DATE

  DATEPART(ENDTS);
  

  HHMM

  PUT(HOUR(ENDTS),Z2.) || ':' || PUT(MINUTE(ENDTS),Z2.);