3. CAPACITY PLANNING DATABASE › 3.4 Meta Files › 3.4.3 Meta File Case Studies › 3.4.3.2 Multilevel Application Summarization › 3.4.3.2.2 Control Parameters
3.4.3.2.2 Control Parameters
Figures 3-117 through 3-123 show the control screens that
were used to create and execute this meta file definition
example.
/--------------------------- 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) |
\------------------------------------------------------------------------------/
Figure 3-117. Specifying Parameters for the Meta File
The specifications on the Meta File Definition screen shown
in Figure 3-117 do the following:
o Set the timespan to WEEKS.
o Set the summary level to HOUR.
o Indicate that the input standard applications are in the
Private Capacity Planner database.
o Indicate that the optional data element CAPAPU is to be
included in the meta file using the extended options
(shown in Figure 3-94).
o Indicate extended options (shown in Figure 3-94) are to be
included in the meta file.
/--------------------------- 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 ********************************|
| |
| |
| |
| |
\------------------------------------------------------------------------------/
Figure 3-118. Setting the CAPAPU
The SAS code on the SAS Statements screen in Figure 3-118 set
the CAPAPU for the first meta file as follows:
o Workloads belonging to the claims department are all set
to a CAPAPU of CLAIMS
o Workloads belonging to the adjustors are all set to a
CAPAPU of ADJUST
/------------------------------ 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. |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
\------------------------------------------------------------------------------/
Figure 3-119. Selecting CAP Files and Data Elements
Option 2, Insert CAP File and Data Element Selection, is
chosen on the Meta File screen 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.
Note that since you are doing summarization, you need to set
an exit for those data elements that need to be recalculated.
/-------------- 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 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|
| - -------- ----------------------------- - ---- ---- ----- --- -------------|
| _ 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 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|
| - -------- ----------------------------- - ---- ---- ----- --- -------------|
| _ 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 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|
| - -------- ----------------------------- - ---- ---- ----- --- -------------|
| _ 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 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|
| - -------- ----------------------------- - ---- ---- ----- --- -------------|
| _ 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-120. CAP File and Data Element Selection Screen--Screen 5 (Part 5 of 5)
/--------------------------------- 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 *******************************|
| |
| |
| |
| |
| |
| |
| |
| |
\------------------------------------------------------------------------------/
Figure 3-121. Validating the Inquiry
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.
/----------------------- 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. |
| |
| |
| |
\------------------------------------------------------------------------------/
Figure 3-122. Saving the Inquiry
The Update Capacity Planning File screen shown in Figure
3-122 is used to save the inquiry so that it can be executed.
/----------------------- 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. |
\------------------------------------------------------------------------------/
Figure 3-123. Executing the Inquiry
Cycle 1 is specified as input to the database loading process
on the Update Capacity Planning File screen shown in Figure
3-123. Since 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.
Copyright © 2014 CA.
All rights reserved.
|
|