Multilevel Application Summarization

Use the
MICS Capacity Planner
to create a meta file that takes information from the Workload Standard Application and summarizes it into broader categories.
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