CA MICS Hardware and SCP Analyzer (RMF) Queries › Mainframe MSU Utilization and LPAR Capping › RMFMCL – Daily LPAR MSU Use and Capacity Limits › Query Defaults

Query Defaults

• HARLPC DETAIL timespan file: Cycles 01 - 02
• Filters: PRSMLPTP EQ ‘CP’ or PRSMLPTP EQ ‘PHY’ (select LPARs using CP engines)
• 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.);