Previous Topic: 6.15 Track Jobs Printing on Specific JES2 RJE RemoteNext Topic: 6.17 Depict System, Demand, and Swap Paging Relationship


6.16 Produce an z/OS Profile Overview Report


PROBLEM:

    For the PROD LPAR, determine the concurrency of the
    levels of CPU utilization, channel utilization, average
    number of TSO address spaces, average number of batch
    address spaces, and paging, by hour.  It is known that
    this LPAR uses only standard CP processors.


DATABASE FILES TO BE ACCESSED:

    &PHARD..HARCPU01
        Yesterday's CPU Processor Activity File (DAYS)
    &PHARD..HARPCA01
        Yesterday's Physical Channel Activity File (DAYS)
    &PSCPD..SCPPAG01
        Yesterday's z/OS Paging Activity File (DAYS)


SUGGESTED SAS FACILITIES TO BE USED FOR REPORTING:

    SORT to resequence files and prepare them for the merge.

    MERGE facility to pull together the different files and
    PROC PRINT may be used to list the required data.


SAS CODE EXAMPLE:

************************************************************;
* SYSTEM PROFILE OVERVIEW REPORT                           *;
************************************************************;

 /* Find busiest channel in each hour interval */
 DATA HARPCA01;
   SET &RHARD..HARPCA01;
   /* Ensure PROD channel is minimally busy */
   IF SYSID='PROD' AND PCAPCPBY GE 5;
 RUN;
 PROC SORT DATA=HARPCA01 OUT=PCASORT;
   BY YEAR MONTH DAY HOUR PCAPCBSY;
 DATA PCASORT;
   SET PCASORT;
   BY YEAR MONTH DAY HOUR;
   IF LAST.HOUR; /* obs for busiest channel*/
 RUN;
 /* Obs only for LPAR of interest */
 DATA HARCPU;
   SET &RHARD..HARCPU01;
   IF SYSID='PROD';
 RUN;
 DATA SCPPAG;
   SET &RHARD..SCPPAG01;
   IF SYSID='PROD';
 RUN;
 DATA ;
   MERGE PCASORT HARCPU SCPPAG;
 RUN;
 PROC PRINT; VAR SYSID YEAR MONTH DAY HOUR CPUPCBSY
   CPUAVT CPUAVB PCAPCBSY PAGPSSPS;
 TITLE  "z/OS HOURLY SYSTEM PROFILE OVERVIEW";
 TITLE3 "CPUPCBSY - Pct CP Processors Busy";
 TITLE4 "CPUAVT/CPUAVB - Average Number of TSO/Batch Users";
 TITLE5 "PCAPCBSY - Pct Channel Busy (Total of all LPARs)";
 TITLE6 "PAGPSSPS - System Page/Swap Page Rate";
 RUN;


GENERATED OUTPUT REPORT:

    Figure 6-14 illustrates the output reports produced by
    the SAS code illustrated above.

    z/OS HOURLY SYSTEM PROFILE OVERVIEW                                                        12:07 Thursday, September 9, yyyy   1     CPUPCBSY - Pct CP Processors Busy   CPUAVT/CPUAVB - Average Number of TSO/Batch Users   PCAPCBSY - Pct Channel Busy (Total of all LPARs)   PAGPSSPS - System Page/Swap Page Rate     Obs    SYSID    YEAR    MONTH    DAY    HOUR    CPUPCBSY     CPUAVT     CPUAVB    PCAPCBSY    PAGPSSPS       1    PROD      10       9       8       0     60.96 %      20.484    19.1094    29.28 %       94.907     2    PROD      10       9       8       1     69.12 %      23.316    17.9336    26.55 %       98.324     3    PROD      10       9       8       2     55.11 %      27.215    12.3259    32.62 %      138.592     4    PROD      10       9       8       3     45.43 %      44.641     8.1152    31.46 %       84.584     5    PROD      10       9       8       4     21.04 %      52.883     5.2000    23.36 %      114.336     6    PROD      10       9       8       5     20.79 %      52.602     5.4436    24.61 %       21.143     7    PROD      10       9       8       6     37.33 %      55.531     7.5933    21.81 %      121.175     8    PROD      10       9       8       7     36.28 %      64.984     5.9658    22.26 %       57.604     9    PROD      10       9       8       8     49.88 %      94.520     7.8289    25.77 %      192.830    10    PROD      10       9       8       9     50.49 %     145.992     9.1885    23.91 %      252.299    11    PROD      10       9       8      10     48.51 %     189.477    11.9304    24.14 %      321.407    12    PROD      10       9       8      11     49.08 %     200.527    23.2422    20.65 %      387.283    13    PROD      10       9       8      12     48.98 %     193.035    12.1106    24.47 %      419.379    14    PROD      10       9       8      13     47.29 %     176.363    10.3804    31.23 %      300.665    15    PROD      10       9       8      14     52.71 %     188.012    13.6482    26.57 %      381.262    16    PROD      10       9       8      15     56.63 %     192.535    22.8359    20.58 %      339.947    17    PROD      10       9       8      16     68.16 %     176.129    26.7617    25.39 %      209.781    18    PROD      10       9       8      17     59.21 %     136.703    16.5352    27.38 %      290.220    19    PROD      10       9       8      18     48.84 %      89.770    11.2327    25.62 %      253.211    20    PROD      10       9       8      19     31.49 %      62.121     7.4490    22.98 %      132.614    21    PROD      10       9       8      20     30.02 %      46.293     7.0076    21.03 %       47.309    22    PROD      10       9       8      21     25.39 %      38.723     6.7341    21.76 %      148.595    23    PROD      10       9       8      22     53.27 %      36.309    16.0391    29.44 %       48.967    24    PROD      10       9       8      23     43.05 %      30.281    11.0278    22.48 %       64.129    

Figure 6-14.  z/OS Performance Overview Report