CA MICS Hardware and SCP Analyzer (RMF) Queries › Mainframe CPC Configuration › RMFSTO – CPC LPAR Storage Allocation › Query Defaults

Query Defaults

• HARLPC DAYS timespan file: Cycle 01
• User code selects yesterday’s data (IF DATEPART(ENDTS) EQ TODAY()-1 ;
• User code overwrites LPAR=’PHYSICAL’ to represent values for CPC level LPAR: ‘##CPC##’
• Derivations:

  DATE

  DATEPART(ENDTS)
  

  CPCID

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