CA MICS Hardware and SCP Analyzer (RMF) Queries › Mainframe CPC Configuration › RMFCFH – CPC Engine Configuration by Hour › Query Defaults

Query Defaults

• HARLPC DAYS timespan file: Cycle 01
• Filters: PRSMNAME=’PHYSICAL’ (Select "PHYSICAL" LPAR only)
• User code selects yesterday’s data (IF DATEPART(ENDTS) EQ TODAY()-1 ;
• Derivations:

  DATE

  DATEPART(ENDTS)
  

  CPCID

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