System Workload and Performance Profile (Resource Element Files)

Combine data elements from multiple
MICS
files into a single capacity planning database file.
micsrm140cd
The system workload and performance profile case study illustrates how to combine data elements from multiple
MICS
files into a single capacity planning database file to allow you to track system workload and performance levels.

Problem Description

For this example, we selected the following seven data elements from three
MICS
files:
Data Element
MICS
File
Comments
CPUMPBS
HARCPU
Average CPU multi-processor busy. This user defined data element is computed from CPUPC0BS and CPUPC1BS, which are the percent busy values for CPUs 0 and 1, respectively.
CPUMXT
HARCPU
The maximum number of TSO users
PAGPSSPG
SCPPAG
Average pages per second for the system.
TSONOLOG
TSOTSO
Total number of TSO logons.
TSOUPTM
TSOTSO
TSO up time.
TSOAVSTM
TSOTSO
TSO average short response time.
TSOAVTTM
TSOTSO
Average response time for all TSO commands.
Although these data elements do not provide a complete performance and workload report for the system, they provide an overview of the system's activities and illustrate how you can use the capacity planning database generator to assemble data elements from a variety of
MICS
files.

Control Parameters

Figures 3-80 through 3-91 show the control screens used to create and execute this resource element file example.
Figure 3-80. Resource Element File Definition Screen
/---------------------- Resource Element File Definition ---------------------\ |Command ===> | |Enter a ? in any data entry field for more information on valid values. | | CAP DB File def.: WKL - System Workload Example | | | |Summarization Level | | Primary ===> WEEKS (DAYS/WEEKS/MONTHS) | | Secondary ===> ZONE (ZONE/HOUR/ENDTS/DAYNAME) | | | |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 ===> N (YES/NO) | | Contents reports ===> N (YES/NO) | | | |Specify extended options ===> N (Y/N) | --------------------------------------------------------------------------------
The specifications on the Resource Element File Definition screen that is shown in Figure 3-80 do the following:
  • Set the timespan to WEEKS
  • Set the summary level to ZONE
Figure 3-81. Specifying Common Data
/--------------------------- Resource Element File ---------------------------\ |Option ===> 1 | | | |Composing CAP DB file def.: WKL - System Workload Example | | | | | | 1 - Insert Common Data Selection | | Specify data selection criteria to apply to ALL files. | | 2 - Insert
MICS
File and Data Element Selection | | Select a
MICS
file and data elements. | | 3 - Insert Cross-File Data Element Definition | | Specify cross-file data element derivations. | | | | | | | | | | | | | | | | | | | | | | | --------------------------------------------------------------------------------
Option 1, Insert Common Data Selection, is chosen on the Resource Element File screen that is shown in Figure 3-81.
Figure 3-82. Common Data Selection Screen
/--------------------------- Common Data Selection ---------------------------\ |Command ===> | |Enter a ? in any data entry field for more information on valid values. | |Composing CAP DB File def.: WKL - System Workload Example | | | | | |SYSID ===> TSO1 ____ ____ ____ ____ ____ ____ ____ ____ ____ | | ____ ____ ____ ____ ____ | | | |Zone ===> 1 _ _ _ _ _ _ _ _ (1 - 9) | | | |Hour ===> __ - __ __ - __ __ - __ __ - __ __ - __ (0 - 23) | | | |Dayname ===> _________ _________ _________ _________ _________ | | | | | | | | | | | | | | | | | |Specify common data selection SAS statements ===> N (Y/N/R) | --------------------------------------------------------------------------------
The Common Data Selection screen that is shown in Figure 3-82 specifies that observations with SYSIDs equal to TSO1 and with ZONE 1 are to be included in the resource element data file.
Figure 3-83. Specifying
MICS
Files and Data Elements
/--------------------------- Resource Element File ---------------------------\ |Option ===> 2 | | | |Composing CAP DB file def.: WKL - System Workload Example | | | | | | 1 - Insert Common Data Selection | | Specify data selection criteria to apply to ALL files. | | 2 - Insert
MICS
File and Data Element Selection | | Select a
MICS
file and data elements. | | 3 - Insert Cross-File Data Element Definition | | Specify cross-file data element derivations. | | | | | | | | | | | | | | | | | | | | | | | --------------------------------------------------------------------------------
Option 2, Insert
MICS
File and Data Element Selection, is chosen on the Resource Element File screen that is shown in Figure 3-83.
The
MICS
File and Data Element Selection screen that is shown in Figure 3-84 specifies that the
MICS
CPU file in database unit P is to be used. The data elements to be included in the resource element file or to be used to derive non-
MICS data element
s are listed.
Figure 3-84.
MICS
File and Data Element Selection Screen - Screen 1
/--------------------
MICS
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.: WKL - System Workload Example | |
MICS
file ===> CPU (fff) - CPU PROCESSOR ACTIVITY FILE | |Input Time-Span ===> WEEKS (DETAIL/DAYS/WEEKS/MONTHS) | |Data base (s) ===> P | |Include CAPAPUs ===> N (Y/N) -------Line Commands--------| |Summarize file by ===> ________ | I Insert C Copy D Delete || |Specify file exits ===> N (Y/N) | R Repeat E Calculations || | | S Depend Clauses & Label || | ----------------------------| | Sum Data | |Cmd Name Label (long name) D Type Type Order Len Output-Format | | - -------- ----------------------------- - ---- ---- ----- --- ------------- | | _ CPUMPBS Avg Pct Busy 0-1 | | _ COMP N 120 7 MAPCT._______ | | _ CPUMXT Max TSO Users | | _ MAX N 050 7 _____________ | | _ CPUPCOBS Pct Busy CPU 0 | | D COMP N 050 7 MAPCT._______ | | _ CPUPC1BS Pct Busy CPU 1 | | D COMP N 050 7 MAPCT._______ | | _ DATE Interval End Date | | _ RET D 000 7 DATE7._______ | | _ MONTH Month of Year | | _ RET N 000 2 _____________ | | _ SYSID System Identifier | | _ RET A 000 4 _____________ | |******************************* BOTTOM OF DATA *******************************| | | --------------------------------------------------------------------------------
Figure 3-84.
MICS
File and Data Element Selection Screen - Screen 2
/--------------------
MICS
File and Data Element Selection ------------------\ |Command ===> Scroll ===> CSR | |Enter a ? in any data entry field for more information on valid values. | |Modifying CAP DB File def.: WKL - System Workload Example | |
MICS
file ===> CPU (fff) - CPU PROCESSOR ACTIVITY FILE | |Input Time-Span ===> WEEKS (DETAIL/DAYS/WEEKS/MONTHS) | |Data base (s) ===> P | |Include CAPAPUs ===> N (Y/N) -------Line Commands--------| |Summarize file by ===> ________ | I Insert C Copy D Delete || |Specify file exits ===> N (Y/N) | R Repeat E Calculations || | | S Depend Clauses & Label || | ----------------------------| | Sum Data | |Cmd Name Label (long name) D Type Type Order Len Output-Format | | - -------- ----------------------------- - ---- ---- ----- --- ------------- | | _ YEAR Year of Century | | _ RET N 000 2 _____________ | | _ ZONE Time Zone | | _ RET A 000 1 _____________ | --------------------------------------------------------------------------------
Figure 3-85.
MICS
File Processing Exits Menu
/----------------------
MICS
File Processing Exits Menu ----------------------\ |Command ===> | | | |Inquiry Step: File & Data Element Sel.: CPU - CPU PROCESSOR ACTIVITY FILE | | | | | |Specify file unique data selection SAS stmts. ===> N (Y/N/R) | | (file level SELECT exit) | | | |Specify new data element derivation SAS stmts. ===> Y (Y/N/R) | | (file transpose and summary exit) | | | |Set expression statements for data elements. ===> N (Y/N) | | (convert SAS stmts to expression stmts) | | | | | | | | | | | | | | | | | | | | | --------------------------------------------------------------------------------
The
MICS
File Processing Exits Menu that is shown in Figure 3-85 indicates that the data element derivation logic is to be defined by the user.
Figure 3-86. Creating a User-defined Data Element
/-------------------------- SAS System Statements ---------------------------\ |Command ===> Scroll ===> CSR | | | |Inquiry Step: File & Data Element Sel.: CPU - CPU PROCESSOR ACTIVITY FILE | | | |SAS Statements for the CAPSMRY Macro | |------------------------------------------------------------------------------| |****** ***************************** TOP OF DATA *****************************| |==MSG> SPECIFY SAS STATEMENTS FOR TRANSPOSING THE FILE OR TO SET VARIABLES. | |=NOTE= %MACRO CAPSMRY; <=== PLEASE DO NOT PLACE LINES BEFORE THIS LINE. | |000001 CPUMPBS = (CPUPCOBS + CPUPC1BS) /2 ; | |=NOTE= %MEND CAPSMRY; <=== PLEASE DO NOT PLACE LINES AFTER THIS LINE. | |****** **************************** BOTTOM OF DATA ***************************| | | --------------------------------------------------------------------------------
The SAS Statements screen in Figure 3-86 shows the SAS statement that is used to compute the user-defined data element, CPUMBPS.
Figure 3-87.
MICS
File and Data Element Selection Screen
/--------------------
MICS
File and Data Element Selection ------------------\ |Command ===> Scroll ===> CSR | |Enter a ? in any data entry field for more information on valid values. | |Modifying CAP DB File def.: WKL - System Workload Example | |
MICS
file ===> PAG (fff) - MVS PAGING ACTIVITY FILE | |Input Time-Span ===> WEEKS (DETAIL/DAYS/WEEKS/MONTHS) | |Data base (s) ===> P | |Include CAPAPUs ===> N (Y/N) -------Line Commands--------| |Summarize file by ===> ________ | I Insert C Copy D Delete || |Specify file exits ===> N (Y/N) | R Repeat E Calculations || | | S Depend Clauses & Label || | ----------------------------| | Sum Data | |Cmd Name Label (long name) D Type Type Order Len Output-Format | | - -------- ----------------------------- - ---- ---- ----- --- ------------- | | _ DATE Interval End Date | | _ RET D 000 7 DATE7._______ | | _ MONTH Month of Year | | _ RET N 000 2 _____________ | | _ PAGPSSPG Sys Paging/Second | | _ COMP N 050 7 _____________ | | _ SYSID System Identifier | | _ RET A 000 4 _____________ | | _ YEAR Year of Century | | _ RET N 000 2 _____________ | | _ ZONE Time Zone | | _ RET A 000 1 _____________ | --------------------------------------------------------------------------------
The
MICS
File and Data Element Selection screen that is shown in Figure 3-87 specifies that the
MICS
PAG File in database unit P is to be used. The data elements to be included in the resource element file are listed.
The
MICS
File and Data Element Selection screen that is shown in Figure 3-88 specifies that the
MICS
TSO file in database unit P is to be used. The data elements to be included in the resource element file are listed.
Figure 3-88.
MICS
File and Data Element Selection Screen - Screen 1
/--------------------
MICS
File and Data Element Selection -------------------\ |Command ===> Scroll ===> CSR | |Enter a ? in any data entry field for more information on valid values. | |Modifying CAP DB File def.: WKL - System Workload Example | |
MICS
file ===> TSO (fff) - TSO SYSTEM ACTIVITY FILE | |Input Time-Span ===> WEEKS (DETAIL/DAYS/WEEKS/MONTHS) | |Data base (s) ===> P | |Include CAPAPUs ===> N (Y/N) -------Line Commands--------| |Summarize file by ===> ________ | I Insert C Copy D Delete || |Specify file exits ===> N (Y/N) | R Repeat E Calculations || | | S Depend Clauses & Label || | ----------------------------| | Sum Data | |Cmd Name Label (long name) D Type Type Order Len Output-Format | | - -------- ----------------------------- - ---- ---- ----- --- ------------- | | _ DATE Interval End Date | | _ RET D 000 7 DATE7._______ | | _ MONTH Month of Year | | _ RET N 000 2 _____________ | | _ SYSID System Identifier | | _ RET A 000 4 _____________ | | _ TSOAVSTM Avg Short Response | | _ COMP N 050 7 TIME.________ | | _ TSOAVTTM Avg Response All | | _ COMP N 050 7 TIME.________ | | _ TSONOLOG User Logons | | _ ACCM N 050 7 _____________ | | _ TSOUPTM TSO Avail Time | | _ ACCM N 050 7 TIME.________ | --------------------------------------------------------------------------------
Figure 3-88.
MICS
File and Data Element Selection Screen - Screen 2
/--------------------
MICS
File and Data Element Selection ------------------\ |Command ===> Scroll ===> CSR | |Enter a ? in any data entry field for more information on valid values. | |Modifying CAP DB File def.: WKL - System Workload Example | |
MICS
file ===> TSO (fff) - TSO SYSTEM ACTIVITY FILE | |Input Time-Span ===> WEEKS (DETAIL/DAYS/WEEKS/MONTHS) | |Data base (s) ===> P | |Include CAPAPUs ===> N (Y/N) -------Line Commands--------| |Summarize file by ===> ________ | I Insert C Copy D Delete || |Specify file exits ===> N (Y/N) | R Repeat E Calculations || | | S Depend Clauses & Label || | ----------------------------| | Sum Data | |Cmd Name Label (long name) D Type Type Order Len Output-Format | | - -------- ----------------------------- - ---- ---- ----- --- ------------- | | _ YEAR Year of Century | | _ RET N 000 2 _____________ | | _ ZONE Time Zone | | _ RET A 000 1 _____________ | --------------------------------------------------------------------------------
Figure 3-89. Validating the Inquiry
/--------------------------- Resource Element File --------Inquiry Validated.-\ |Command ===> Scroll ===> CSR | | | |Composing CAP DB File def.: WKL - System Workload Example | | | |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 | | - ------------------------------------------------------------------ | | _ Resource Element File Definition | | _ Common Data Selection | | _ File & Data Element Sel.: CPU - CPU PROCESSOR ACTIVITY FILE | | _ File & Data Element Sel.: PAG - MVS PAGING ACTIVITY FILE | | _ File & Data Element Sel.: TSO - TSO SYSTEM ACTIVITY FILE | | _ Cross-File Data Element Definition | |****************************** BOTTOM OF DATA ********************************| | | | | | | | | | | --------------------------------------------------------------------------------
After the resource element file definition parameters are specified, the Resource Element File screen is used to validate the inquiry. Figure 3-89 shows this screen after VALIDATE is typed at the Command prompt.
Figure 3-90. Saving the Inquiry
/----------------------- Update Capacity Planning File -------- Confirm Save.-\ |Command ===> | | | |Modifying CAP DB File def.: WKL - System Workload Example | | | | | |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-90 is used to save the inquiry so that it can be executed.
Figure 3-91. Executing the Inquiry
/----------------------- Update Capacity Planning File -------------------------\ |Command ===> | | | |Composing CAP DB File def.: WKL - System Workload Example | | | |Type of update ===> INITIALIZE (INITIALIZE/UPDATE) | |Replace existing file? ===> N (Y/N) | | | |Input data source ===> ONLINE (ARCHIVE/ONLINE) | |
MICS
file cycle(s) ===> 01 - 26 (0 - 99) | |Archive generation number ===> ___ (0 to -99) | | | |Starting date of update ===> _______ (ddmonyy) | |Number of months to select ===> 26__ (1 to 9999) | | | |Mode of execution ===> BATCH (BATCH/FOREGROUND) | | | |List updated file contents? ===> YES (YES/NO) | | | | | |Press END to invoke MICF inquiry execution to update the resource element file.| |Enter CANCEL to terminate the resource element file update. | | | --------------------------------------------------------------------------------
Cycles 1 through 26 are specified as input to the database loading process on the Update Capacity Planning File screen that is shown in Figure 3-91. The updated resource element file will be printed after the update is complete.

Output Report

Figure 3-92 Resource Element File Contents Report shows the output that is created by the PROC PRINT of the updated data set.
Figure 3-92. Resource Element File Contents Report
MICS
Capacity Planner OBS DATE CPUMXT SYSID WEEK YEAR ZONE CPUMPBS PAGPSSPG TSONOLOG TSOUPTM TSOAVSTM TSOAVTTM 1 23APR98 129 TSO1 17 98 1 61.4238 33.2198 14592 246:41:13.63 0:00:00.37 0:00:00.79 2 30APR98 167 TSO1 18 98 1 58.6719 32.8897 14406 247:26:18.19 0:00:00.56 0:00:00.89 3 07MAY98 138 TSO1 19 98 1 64.3906 35.1352 15830 245:41:18.13 0:00:00.38 0:00:00.78 4 14MAY98 146 TSO1 20 98 1 63.8496 34.2255 15348 247:06:19.88 0:00:00.44 0:00:00.86 5 21MAY98 148 TSO1 21 98 1 63.3184 36.5478 15486 247:51:21.15 0:00:00.36 0:00:00.85 6 28MAY98 133 TSO1 22 98 1 59.0957 31.8148 14422 247:56:19.52 0:00:00.36 0:00:00.73 7 04JUN98 125 TSO1 23 98 1 59.9043 30.9136 11020 197:55:55.96 0:00:00.39 0:00:00.79 8 11JUN98 148 TSO1 24 98 1 57.8789 34.2631 15092 247:51:23.49 0:00:00.39 0:00:00.76 9 18JUN98 208 TSO1 25 98 1 59.2773 36.3417 15040 244:21:18.72 0:00:00.43 0:00:00.88 10 25JUN98 159 TSO1 26 98 1 59.1797 33.9071 14786 238:22:05.21 0:00:00.41 0:00:00.78 11 02JUL98 139 TSO1 27 98 1 66.5547 47.0149 15744 242:06:34.54 0:00:00.55 0:00:00.98 12 09JUL98 136 TSO1 28 98 1 53.3340 33.6379 11890 236:46:54.05 0:00:00.50 0:00:00.89 13 16JUL98 182 TSO1 29 98 1 69.8828 63.7973 16778 247:42:56.80 0:00:00.78 0:00:01.26 14 23JUL98 149 TSO1 30 98 1 67.2285 53.0309 15504 246:19:56.86 0:00:00.66 0:00:01.13 15 30JUL98 196 TSO1 31 98 1 71.9414 64.2385 14598 246:56:42.68 0:00:00.74 0:00:01.22 16 06AUG98 133 TSO1 32 98 1 64.1016 42.4233 14620 247:51:18.95 0:00:00.40 0:00:00.76 17 13AUG98 242 TSO1 33 98 1 63.3496 46.0162 14476 242:50:34.61 0:00:00.50 0:00:01.07 18 20AUG98 132 TSO1 34 98 1 64.4785 45.5301 14484 242:11:34.16 0:00:00.47 0:00:00.96 19 27AUG98 115 TSO1 35 98 1 63.3281 46.4081 14020 247:36:16.22 0:00:00.44 0:00:00.88 20 03SEP98 150 TSO1 36 98 1 65.8555 46.0491 14532 245:41:21.55 0:00:00.47 0:00:00.92 21 08SEP98 122 TSO1 37 98 1 76.2949 47.3450 11130 187:51:25.56 0:00:01.01 0:00:01.86 22 16SEP98 123 TSO1 38 98 1 60.0039 47.9458 12872 230:56:22.15 0:00:00.65 0:00:01.46 23 20SEP98 136 TSO1 39 98 1 66.7480 48.3453 14008 246:01:32.37 0:00:00.80 0:00:01.45 24 28SEP98 119 TSO1 40 98 1 67.2891 45.1462 11718 194:41:15.07 0:00:00.80 0:00:01.42 25 04OCT98 136 TSO1 41 98 1 69.3281 49.2254 15534 249:46:46.15 0:00:00.72 0:00:01.47 26 12OCT98 123 TSO1 42 98 1 64.3730 44.5164 11774 200:31:19.81 0:00:00.66 0:00:01.33