CA MICS Hardware and SCP Analyzer (RMF) Queries › Mainframe MSU Utilization and LPAR Capping › RMFMSU – Daily CPC MSU Use with Stacked LPARs › Query Defaults

Query Defaults

• HARLPC DAYS timespan file: Cycles 01 - 03
• Filters: PRSMLPTP EQ ‘CP’ or PRSMLPTP EQ ‘PHY’ (select LPARs using CP engines)
• Derivations:

  CPCID

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

  DATE

  DATEPART(ENDTS);
  

  HHMM

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

  DATEHOUR

  DATEHOUR = PUT(DATEPART(ENDTS),YYMMDDD10.) || ':' || PUT(HOUR,Z2.) ;
  

  DATEHHMM

  DATEHHMM = PUT(DATEPART(ENDTS),YYMMDDP10.) || '-' || HHMM ;