Multilevel Application Summarization

The multilevel application summarization case study shows how to use the
MICS Capacity Planner
to create a meta file that takes information from the Workload Standard Application and summarizes it into broader categories (for example, Department).
micsrm140cd
The multilevel application summarization case study shows how to use the
MICS Capacity Planner
to create a meta file that takes information from the Workload Standard Application and summarizes it into broader categories (for example, Department).

Problem Description

For this case study, a single meta file was created to summarize the activity from the workload standard application into workgroups.
The systems that are used in this study are as follows:
SYSA
Production System W/Claims & Insurance Adjustors
This case study addresses the following areas:
  • Recalculating Data Elements
  • The use of the CAPIAPU internal variable
  • How to use the Meta File Facility to summarize an input Capacity Planner file to a higher level of summarization

Control Parameters

Figures 3-117 through 3-123 show the control screens that were used to create and execute this meta file definition example.
Figure 3-117. Specifying Parameters for the Meta File
/---------------------------  Meta File Definition  ----------------------------\ |Command ===>                                                                   | |Enter a ? in any data entry field for more information on valid values.        | |Composing CAP DB File def.:  MT1 - Multi-Level Meta Ex.                        | |                                                                               | |Summarization Level                                                            | |                 Primary   ===> WEEKS    (DETAIL/DAYS/WEEKS/MONTHS)            | |                 Secondary ===> HOUR     (ZONE/HOUR/ENDTS/DAYNAME)             | |                                                                               | |Capacity Planner Data Base ===> PRIVATE  (Private/Shared)                      | |                                                                               | |Amount of data retained    ===> 60       (1-9999 weeks)                        | |Age of oldest forecast     ===> 24       (1-9999 weeks)                        | |History cycles             ===> 3        (1-99 cycles)                         | |Forecast cycles            ===> 3        (1-99 cycles)                         | |                                                                               | |Enable:                                                                        | |   Notes report            ===> YES      (YES/NO)                              | |   Contents reports        ===> YES      (YES/NO)                              | |                                                                               | |Specify extended options   ===> Y        (Y/N/R)                               | ---------------------------------------------------------------------------------
The specifications on the Meta File Definition screen that is shown in Figure 3-117 do the following:
  • Set the timespan to WEEKS.
  • Set the summary level to HOUR.
  • Indicate that the input standard applications are in the Private Capacity Planner database.
  • Indicate that the optional data element CAPAPU is to be included in the meta file using the extended options (shown in Figure 3-94).
  • Indicate extended options (shown in Figure 3-94) are to be included in the meta file.
Figure 3-118. Setting the CAPAPU
/---------------------------  SAS System Statements  ---------------------------\ |Command ===>                                                  Scroll ===> CSR  | |                                                                               | |Inquiry Step:  File & Data Element Sel.: CPU - CPU PROCESSOR ACTIVITY FILE     | |                                                                               | |SAS Statements for the CAPAURT Macro                                           | |-----------------------------------------------------------------------------  | |*********************************** TOP OF DATA *******************************| |==MSG> SPECIFY SAS STATEMENTS TO SET CAPAPU VALUES.                            | |=NOTE= %MACRO CAPAURT;  <=== PLEASE DO NOT PLACE LINES BEFORE THIS LINE.       | |000001 IF CAPIAPU EQ 'TSO1' THEN CAPAPU = 'CLAIMS';                            | |000002 ELSE IF CAPIAPU EQ 'TSO2' THEN CAPAPU = 'ADJUST';                       | |000003 ELSE IF CAPIAPU EQ 'PROD1' THEN CAPAPU = 'CLAIMS';                      | |000004 ELSE IF CAPIAPU EQ 'PROD2' THEN CAPAPU = 'ADJUST';                      | |000005 ELSE IF CAPIAPU EQ 'SYSTEMS' THEN CAPAPU = 'SYSTEMS';                   | |000006 ELSE CAPAPU = 'OTHER';                                                  | |=NOTE= %MEND CAPAURT;   <=== PLEASE DO NOT PLACE LINES AFTER THIS LINE.        | |****************************** BOTTOM OF DATA  ********************************| |                                                                               | |                                                                               | |                                                                               | |                                                                               | ---------------------------------------------------------------------------------
The SAS code on the SAS Statements screen in Figure 3-118 set the CAPAPU for the first meta file as follows:
  • Workloads belonging to the claims department are all set to a CAPAPU of CLAIMS
  • Workloads belonging to the adjustors are all set to a CAPAPU of ADJUST
Figure 3-119. Selecting CAP Files and Data Elements
/------------------------------  Meta File  ------------------------------------\ |Option ===> 2                                                                  | |                                                                               | |Composing CAP DB file def.:  MT1 - Multi-Level Meta Ex.                        | |                                                                               | |                                                                               | |        1 - Insert Common Data Selection                                       | |            Specify data selection criteria to apply to ALL files.             | |        2 - Insert CAP File and Data Element Selection                         | |            Select a Capacity Planner file and data elements.                  | |        3 - Insert Cross-File Data Element Definition                          | |            Specify cross-file data element derivations.                       | |                                                                               | |                                                                               | |                                                                               | |                                                                               | |                                                                               | |                                                                               | |                                                                               | |                                                                               | |                                                                               | |                                                                               | |                                                                               | ---------------------------------------------------------------------------------
Option 2, Insert CAP File and Data Element Selection, is chosen on the Meta File screen that is shown in Figure 3-113.
The CAP File and Data Element Selection screens shown in Figure 3-120 specify that the CAP File WK1 is being used. The data elements to be included in the meta file are listed. As you are doing summarization, set an exit for those data elements that must be recalculated.
Figure 3-120. CAP File and Data Element Selection Screen--Screen 1 (Part 1 of 5)
/--------------  Capacity Planner File and Data Element Selection  ------------\ |Command ===>                                                  Scroll ===> CSR | |Enter a ? in any data entry field for more information on valid values        | |                                                                              | |Composing CAP DB File def.:  MT1 - Multi-Level Meta Ex.                       | |                                                                              | |CAP file ===> WK1 (fff) -  Workload SA - Prod. Workloads                      | |                                                  -------Line Commands--------| |Include CAPAPUs    ===> Y (Y/N)                   | I Insert C Copy D Delete || |Specify file exits ===> Y (Y/N)                   | R Repeat E Calculations  || |                                                  | S Depend Clauses & Label || |                                                  ----------------------------| |                                             Sum  Data                        | |Cmd  Name    Label (long name)             D Type Type Order Len Output Format| | -  -------- ----------------------------- - ---- ---- ----- --- -------------| | _  CAPAPU   Workload Group                                                   | |                                             RET  A    000   12               | | _  CPUDUR   Recording Interval Time                                          | |                                             ACCM T    120   13  TIME13.2     | | _  CPUTOBTM Total Time Processor Busy                                        | |                                             ACCM T    050   13  TIME12.2     | | _  CPUTOUTM Total Processor Up Time                                          | |                                             ACCM T    050   13  TIME12.2     | | _  DATE     Interval End Date                                                | |                                             RET  D    000   7   DATE7.       | | _  DESCRIPT Workload Group Long Name                                         | |                                             RET  A    120   40               | | _  HOUR     Hour of Day                                                      | |                                             RET  N    000   2                | | _  MVSLEVEL MVS Software Level                                               | |                                             RET  A    050   8                | -------------------------------------------------------------------------------- 
Figure 3-120. CAP File and Data Element Selection Screen--Screen 2 (Part 2 of 5)
/--------------  Capacity Planner File and Data Element Selection  ------------\ |Command ===>                                                  Scroll ===> CSR | |Enter a ? in any data entry field for more information on valid values        | |                                                                              | |Composing CAP DB File def.:  MT1 - Multi-Level Meta Ex.                       | |                                                                              | |CAP file ===> WK1 (fff) -  Workload SA - Prod. Workloads                      | |                                                  -------Line Commands--------| |Include CAPAPUs    ===> Y (Y/N)                   | I Insert C Copy D Delete || |Specify file exits ===> Y (Y/N)                   | R Repeat E Calculations  || |                                                  | S Depend Clauses & Label || |                                                  ----------------------------| |                                             Sum  Data                        | |Cmd  Name    Label (long name)             D Type Type Order Len Output Format| | -  -------- ----------------------------- - ---- ---- ----- --- -------------| | _  PAGPIN   Non-VIO Non-Swap Page-Ins                                        | |                                             ACCM N    050   13               | | _  PCATRCPU Percent of CPU Attributable to Workload                          | |                                             COMP N    120   3   MAPCT.       | | _  PCTOTCPU Percent Total CPU Time Consumed                                  | |                                             COMP N    120   3   MAPCT.       | | _  PCTOTSRB Percent Total SRB Time Consumed                                  | |                                             COMP N    120   3   MAPCT.       | | _  PCTOTTCB Percent Total TCB Time Consumed                                  | |                                             COMP N    120   3   MAPCT.       | | _  PCTTOTPG Percent Total Pagein Rate Consumed                               | |                                             COMP N    120   3   MAPCT.       | | _  PGAAVAFT Average Real+Expanded Frames                                     | |                                             COMP N    050   10               | | _  PGAAVETM Avg Time of Ended Transactions                                   | |                                             COMP T    050   10  TIME9.3      | | _  PGAAVSTM Avg Transaction Service Time                                     | |                                             COMP T    050   10  TIME9.3      | --------------------------------------------------------------------------------
Figure 3-120. CAP File and Data Element Selection Screen--Screen 3 (Part 3 of 5)
/--------------  Capacity Planner File and Data Element Selection  ------------\ |Command ===>                                                  Scroll ===> CSR | |Enter a ? in any data entry field for more information on valid values        | |                                                                              | |Composing CAP DB File def.:  MT1 - Multi-Level Meta Ex.                       | |                                                                              | |CAP file ===> WK1 (fff) -  Workload SA - Prod. Workloads                      | |                                                  -------Line Commands--------| |Include CAPAPUs    ===> Y (Y/N)                   | I Insert C Copy D Delete || |Specify file exits ===> Y (Y/N)                   | R Repeat E Calculations  || |                                                  | S Depend Clauses & Label || |                                                  ----------------------------| |                                             Sum  Data                        | |Cmd  Name    Label (long name)             D Type Type Order Len Output Format| | -  -------- ----------------------------- - ---- ---- ----- --- -------------| | _  PGAAVWTM Avg Transaction Wait for Service Time                            | |                                             COMP T    050   10  TIME9.3      | | _  PGACPUTM Total CPU Time                                                   | |                                             ACCM T    050   13  TIME12.2     | | _  PGAHIN   Hiperspace Page-Ins                                              | |                                             ACCM N    050   13               | | _  PGAHMS   ESO Hiperspace Read Misses                                       | |                                             ACCM N    050   13               | | _  PGAITS   I/O Service Units                                                | |                                             ACCM N    050   13               | | _  PGAMPL   Multi-Programming Level                                          | |                                             RET  N    050   5                | | _  PGAMTS   Main Storage Service Units                                       | |                                             ACCM N    050   13               | --------------------------------------------------------------------------------
Figure 3-120. CAP File and Data Element Selection Screen--Screen 4 (Part 4 of 5)
/--------------  Capacity Planner File and Data Element Selection  ------------\ |Command ===>                                                  Scroll ===> CSR | |Enter a ? in any data entry field for more information on valid values        | |                                                                              | |Composing CAP DB File def.:  MT1 - Multi-Level Meta Ex.                       | |                                                                              | |CAP file ===> WK1 (fff) -  Workload SA - Prod. Workloads                      | |                                                  -------Line Commands--------| |Include CAPAPUs    ===> Y (Y/N)                   | I Insert C Copy D Delete || |Specify file exits ===> Y (Y/N)                   | R Repeat E Calculations  || |                                                  | S Depend Clauses & Label || |                                                  ----------------------------| |                                             Sum  Data                        | |Cmd  Name    Label (long name)             D Type Type Order Len Output Format| | -  -------- ----------------------------- - ---- ---- ----- --- -------------| | _  PGAPIN   Number of Page-Ins                                               | |                                             ACCM N    050   13               | | _  PGAPSHIN Hiperspace Page-Ins per Second                                   | |                                             COMP N    050   5                | | _  PGAPSHMS ESO Hiperspace Read Misses per Second                            | |                                             COMP N    050   5                | | _  PGAPSINS Interval Service Rate                                            | |                                             COMP N    050   5                | | _  PGAPSPIN Page-Ins per Second                                              | |                                             COMP N    050   5                | | _  PGASER   Total Service Units                                              | |                                             ACCM N    050   13               | | _  PGASPP   Swap Sequences                                                   | |                                             ACCM N    050   13               | --------------------------------------------------------------------------------
Figure 3-120. CAP File and Data Element Selection Screen--Screen 5 (Part 5 of 5)
/--------------  Capacity Planner File and Data Element Selection  ------------\ |Command ===>                                                  Scroll ===> CSR | |Enter a ? in any data entry field for more information on valid values        | |                                                                              | |Composing CAP DB File def.:  MT1 - Multi-Level Meta Ex.                       | |                                                                              | |CAP file ===> WK1 (fff) -  Workload SA - Prod. Workloads                      | |                                                                              | |                                                  -------Line Commands--------| |Include CAPAPUs    ===> Y (Y/N)                   | I Insert C Copy D Delete || |Specify file exits ===> Y (Y/N)                   | R Repeat E Calculations  || |                                                  | S Depend Clauses & Label || |                                                  ----------------------------| |                                             Sum  Data                        | |Cmd  Name    Label (long name)             D Type Type Order Len Output Format| | -  -------- ----------------------------- - ---- ---- ----- --- -------------| | _  PGASRBTM SRB CPU Time                                                     | |                                             ACCM T    050   13  TIME12.2     | | _  PGATAT   Residency Time                                                   | |                                             ACCM T    050   13  TIME9.3      | | _  PGATCBTM TCB CPU Time                                                     | |                                             ACCM T    050   13  TIME12.2     | | _  PGATTX   Transactions Terminated                                          | |                                             ACCM N    050   13               | | _  SYSID    System Identifier                                                | |                                             RET  A    050   4                | | _  TOTSRBTM Total SRB Time Consumed This System                              | |                                             ACCM T    120   13  TIME12.2     | | _  TOTTCBTM Total TCB Time Consumed This System                              | |                                             ACCM T    120   13  TIME12.2     | | _  WEEK     Week of Year                                                     | |                                             RET  N    000   2                | | _  YEAR     Year of Century                                                  | |                                             RET  N    000   2                | --------------------------------------------------------------------------------
Figure 3-121. Validating the Inquiry
/---------------------------------  Meta File  --------------Inquiry Validated.\ |Command ===>                                                  Scroll ===> CSR | |                                                                              | |Composing CAP DB File def.:  MT1 - Multi-Level Meta Ex.                       | |                                                                              | |Update the capacity planning data base file ===> Y (Y/N)                      | |                                                                              | |Line Cmds: S Select  I Insert  D Delete  R Repeat                             | |                                                                              | |Cmd                 Data Base File Definition Step                            | | -   ------------------------------------------------------------------       | | _   Meta File Definition                                                     | | _   CAP File & Data Element Sel.: WK1 - Workload SA - Prod. Workloads        | |****************************** BOTTOM OF DATA  *******************************| |                                                                              | |                                                                              | |                                                                              | |                                                                              | |                                                                              | |                                                                              | |                                                                              | |                                                                              | --------------------------------------------------------------------------------
After the meta file definition parameters are specified, the meta file is used to validate the inquiry. Figure 3-121 shows this screen after VALIDATE is typed at the Command prompt.
Figure 3-122. Saving the Inquiry
/-----------------------  Update Capacity Planning File  -------- Confirm Save.\ |Command ===>                                                                  | |                                                                              | |Composing CAP DB File def.:  MT1 - Multi-Level Meta Ex.                       | |                                                                              | |                                                                              | |This file definition has been changed and must be saved before updating the   | |file.                                                                         | |                                                                              | |                                                                              | |Do you wish to save the file definition and update the file? ===> YES (YES/NO)| |                                                                              | |                                                                              | |                                                                              | |                                                                              | |Instructions:                                                                 | |                                                                              | |   Press ENTER key to save the file definition and update the file.           | |                                                                              | |   Reply NO and press enter key to cancel the file update request.            | |                                                                              | |                                                                              | |                                                                              | --------------------------------------------------------------------------------
The Update Capacity Planning File screen that is shown in Figure 3-122 is used to save the inquiry so that it can be executed.
Figure 3-123. Executing the Inquiry
/-----------------------  Update Capacity Planning File  ----------  DST Saved.-\ |Command ===>                                                                   | |                                                                               | |Composing CAP DB File def.:  MT1 - Multilevel Meta Ex.                         | |                                                                               | |Update type                                 ===> INITIALIZE (INITIALIZE/UPDATE)| |Replace existing                            ===> N (Y/N)                       | |                                                                               | |PRIVATE Capacity Planner data base cycle(s) ===> 01 - __                       | |                                                                               | |Update start date                           ===> _______ (ddmonyy)             | |Number of weeks                             ===> ____ (1-9999)                 | |                                                                               | |Execution mode                              ===> BATCH      (BATCH/FOREGROUND) | |                                                                               | |List updated CAP DB file contents           ===> YES (YES/NO)                  | |                                                                               | |                                                                               | |                                                                               | |                                                                               | |                                                                               | |                                                                               | |Press END to invoke MICF inquiry execution to update the meta file.            | |Enter CANCEL to terminate the meta file update.                                | ---------------------------------------------------------------------------------
Cycle 1 is specified as input to the database loading process on the Update Capacity Planning File screen that is shown in Figure 3-123. As  you are doing an INITIALIZE, all data in the PRIVATE Capacity Planning database for this standard application will be copied to the new meta file. The updated meta file will be printed after the update is complete.

Output Report

The following figure 3-124 Meta File Contents Report shows the output that is created by the PROC PRINT of the updated data set.
Figure 3-124. Meta File Contents Report
OBS ZONE SYSID WEEK YEAR  TOTSRBTM    TOTTCBTM     PAGPIN MVSLEVEL  CPUTOBTM        CPUTOUTM     CPUDUR      PGACPUTM    PGASRBTM    1    1  S008  22    98  3:59:35.36  27:30:38.31   906574 SP3.1.3  67:29:12.21    72:00:00.46  36:00:00.23  0:55:19.74  0:02:22.93  2    1  S008  23    98  5:10:17.51  33:56:44.00  1019275 SP3.1.3  79:56:41.09    85:56:58.52  42:58:29.26  1:35:43.93  0:02:09.00  3    1  S008  24    98  4:57:04.90  35:55:17.02  1240731 SP3.1.3  86:40:29.48    89:59:58.83  44:59:59.42  1:00:20.99  0:02:10.33  4    1  S008  25    98  5:07:26.89  34:19:17.26  1011178 SP3.1.3  79:36:11.11    87:45:45.03  43:52:52.51  1:10:19.13  0:03:49.15  5    1  S008  26    98  5:00:42.75  31:27:56.51  1032329 SP3.1.3  77:34:18.14    87:10:11.38  43:35:05.69  1:41:37.26  0:02:25.11  6    1  S008  27    98  4:20:26.15  23:51:01.77   685754 SP3.1.3  54:49:03.94    68:55:44.56  34:27:52.28  0:40:42.06  0:02:08.89  7    1  S008  28    98  5:26:01.29  38:24:19.89   804749 SP3.1.3  65:58:42.67    93:43:22.54  34:04:26.55  0:36:46.46  0:01:46.11  8    1  S008  29    98  6:57:12.86  50:57:28.49  1242727 SP3.1.3  90:05:32.84   128:41:02.73  42:53:40.91  0:42:25.66  0:02:14.69     PGATAT     PGATCBTM  PGAHIN  PGAHMS PGAITS    PGAMTS  PGAPIN   PGASER PGASPP PGATTX   PGAMPL PGAPSHIN PGAPSHMS PGAPSINS  PGAPSPIN   12:16:08.  0:52:56.81      0        0 1750522  55223196  35154  93633125 44620  43187  0.31660 0.00000      0      671.2       0.3 12:02:43.  1:33:34.93      0        0 3130124  69569898  26425 136129461 23333  22501  0.28067 0.00000      0      881.1       0.2 13:36:36.  0:58:10.67      0        0 2554919  39096333  31459  81637362 19068  18274  0.26604 0.00000      0      443.3       0.2 18:54:52.  1:06:29.98      0        0 2416498  80720366  46920 129728096 57476  53864  0.43361 0.00000      0      826.1       0.3 17:13:26.  1:39:12.15   5776        0 1982346 131697964  41152 201011453 34966  31419  0.40919 0.03812      0     1326.5       0.3 7:08:01.4  0:38:33.18      0        0 2183431  59773809  17443  87455660 12763  12363  0.23659 0.00000      0      805.7       0.2 11:33:07.  0:35:00.35      0        0 1307131  35971094  18012  58719809 17742  17719  0.33751 0.00000      0      476.5       0.1 7:13:15.2  0:40:10.98    385        0 1746471  44277734  24456  70615541 20919  21716  0.16478 0.00244      0      447.6       0.2    PGAAVAFT  PGAAVETM   PGAAVSTM PGAAVTRN  PGAAVWTM CAPAPU      DESCRIPT    PCATRCPU  PCTOTCPU  PCTOTSRB  PCTOTTCB  PCTTOTPG   DATE     480.71 0:00:01.3  0:33:43.4   0.3317 0:00:00.0 ADJUST  ALL Adjustors    46.68 %    1.36 %    0.99 %    3.20 %    3.87 %  29MAY98   453.99 0:00:02.5  0:49:08.8   0.2988 0:00:00.1 ADJUST  ALL Adjustors    48.93 %    1.99 %    0.69 %    4.59 %    2.59 %  05JUN98   388.16 0:00:03.4  0:27:01.7   0.2733 0:00:00.0 ADJUST  ALL Adjustors    47.15 %    1.16 %    0.73 %    2.69 %    2.53 %  12JUN98   445.13 0:00:01.8  0:28:21.1   0.4856 0:00:00.1 ADJUST  ALL Adjustors    49.55 %    1.47 %    1.24 %    3.22 %    4.64 %  19JUN98   480.59 0:00:03.3  0:48:56.4   0.4517 0:00:00.3 ADJUST  ALL Adjustors    47.02 %    2.18 %    0.80 %    5.25 %    3.98 %  26JUN98   514.21 0:00:03.5  0:51:19.1   0.2617 0:00:00.3 ADJUST  ALL Adjustors    51.42 %    1.23 %    0.82 %    2.69 %    2.54 %  03JUL98   370.03 0:00:02.7  0:20:02.7   0.3962 0:00:00.4 ADJUST  ALL Adjustors    66.44 %    0.92 %    0.54 %    1.51 %    2.23 %  10JUL98   388.88 0:00:01.6  0:42:22.2   0.1761 0:00:00.1 ADJUST  ALL Adjustors    64.28 %    0.78 %    0.53 %    1.31 %    1.96 %  24JUL98