CA MICS Hardware and SCP Analyzer (RMF) Queries › Mainframe CPC Memory Use and Paging › RMFFRM – z/OS Central Storage Daily Frame Use by SYSID › Query Defaults

Query Defaults

The following are RMFFRM Query Defaults:

• HARCPU DAYS timespan file: Cycle 01
• SCPPAG DETAIL timespan file: Cycles 01 - 02
• Filters: None
• User code excludes all but yesterday’s data (IF DATEPART(ENDTS) EQ TODAY()-1 ;
• Derivations:

  CPCUID

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

  DATE

  DATEPART(ENDTS);
  

  HHMM

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

  DATEHHMM

  PUT(DATEPART(ENDTS),YYMMDDD10.) || ':' || HHMM ;
  

  DATEHOUR

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