CA MICS Hardware and SCP Analyzer (RMF) Queries › Mainframe CPC Memory Use and Paging › RMFPAG – z/OS System Daily Paging Analysis

RMFPAG – z/OS System Daily Paging Analysis

Overview

The RMFPAG query shows paging rates for z/OS LPARs in each Central Processing Complex (CPC). The query produces three data extracts. The first data extract shows the hourly paging rate for all of the z/OS LPARs in each CPC a single chart view, with the contribution of each z/OS system shown in a stacked vertical bar. The second and third charts show the overall paging rate, and system and application page faults using two different views. One view displays the overall paging rate as vertical bars with system and application page faults shown with lines, and another view displays the application and system page faults using a stacked vertical bar and the overall system paging rate is show with a line.

The first chart shows the hourly overall system paging rate for the z/OS LPARs running on an IBM z/10 2097-712 CPC.

The second chart shows overall system per-second paging rate for each hour, for an individual z/OS LPAR using a line. The per-second application and system page fault rates are shown for each hour using stacked vertical bars.

Uses

Paging is essential and normal for the z/OS operating system. High per-second paging rates can indicate insufficient CPC central storage. Page faults result in workload delays. A program must wait for a page to be moved from auxiliary storage to central storage to continue executing. High page fault rates at the LPAR level can indicate insufficient central storage allocation for the LPAR.

Data Extracts

z/OS CPC Daily Paging Rate

Left Y-axis

PAGPSSPC – System Page Rate

X-axis

DATEHOUR – Date Hour

Data element DATEHOUR is derived by concatenating the Date, expressed using the YYMMDDD10. FORMAT with the HOUR, separated by a colon: YY-MM-DD:HH.

z/OS System Daily Page Rate and Faults V1

Left Y-axis

PAGPSAPF – Application Page Fault Rate

PAGPSSPF – System Page Fault Rate

Right Y-axis

PAGPSSPC – System Page Rate

X-axis

DATEHOUR – Date Hour

Data element DATEHOUR is derived by concatenating the Date, expressed using the YYMMDDD10. FORMAT with the HOUR, separated by a colon: YY-MM-DD:HH.

z/OS System Daily Page Rates and Faults V2

Left Y-axis

PAGPSSPC – System Page Rate

Right Y-axis

PAGPSAPF – Application Page Fault Rate

PAGPSSPF – System Page Fault Rate

X-axis

DATEHOUR – Date Hour

Data element DATEHOUR is derived by concatenating the Date, expressed using the YYMMDDD10. FORMAT with the HOUR, separated by a colon: YY-MM-DD:HH.

Query Defaults

• HARCPU DAYS timespan file: Cycle 01
• SCPPAG DAYS timespan file: Cycles 01 - 02
• Filters: None
• User code selects yesterday’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.);
  

Modifications

The following modifications can be made to the RMFPAG query:

• If you want to see interval, rather than hourly level paging and page fault statistics, you can use the HARCPU and SCPPAG DETAIL timespan.
• You can increase the number of cycles to show more than one day’s data on a single chart, but comment out the user code for the SCPPAG initial file selection step that selects only yesterday’s data.
• You can use a filter statement to restrict data to focus on a particular time range (for example, HOUR GE 8 AND HOUR LE 17) or particular time zone (for example, ZONE EQ 1)
• You can add filter statements to select only a single CPC, or set of CPCs using the identifying data elements shown in the CPCID derivation.
• Various time-based derived data elements—HHMM, DATE, DATEHHMM, and DATEHOUR (default)—can be used to display the data in different ways. For example, if you want to display charts for multiple days, with each chart showing one day’s activity, you can insert DATE and substitute HHMM for DATEHOUR in the data extract step KEY selection. The DATE appears in the chart title, and HHMM (Hour Minute) appears on the X-axis.
• The CSVs for the data extract steps include numerous other page rate and page count related data elements. These elements can be plotted if desired by editing the view and selecting the appropriate data elements for charting.