3. CAPACITY PLANNING DATABASE › 3.4 Meta Files › 3.4.2 Screen Operation › 3.4.2.1 Creating a Database Specification › 3.4.2.1.2 Element Selection
3.4.2.1.2 Element Selection
Figure 3-96, Meta File menu, shows the next step in creating
a user-defined meta file definition.
/------------------------------- Meta File -----------------------------------\
|Option ===> |
| |
|Composing CAP DB file def.: SYS - System Activity Tracking File |
| |
| |
| 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-96. Meta File Menu
After you complete specifying the meta file definition
control parameters, you are ready to define the steps to
build your Capacity Planning database file. (Refer to
Figure 3-2 to see how these steps correspond to user
specifications for the selection, summary, and merge phases
of database creation.) The Meta File menu provides you with
the opportunity to define selection criteria that you wish to
apply to each CAP file that you define as an input data
source for your meta file.
You may choose from the following options on the Meta
File menu:
Insert Specify Option 1, Insert Common Data Selection,
Common Data to specify the data selection criteria that you
Selection: wish to apply to every CAP file that provides
input data in building your meta file. The
Common Data Selection screen shown in Figure
3-97 is displayed.
You may specify only one common data selection
step for each meta file. You must complete this
before proceeding with the succeeding steps.
Insert CAP Specify Option 2, Insert CAP File and Data
File and Element Selection, to define a CAP file and
Data Element data element selection step for each CAP file
Selection: that provides input data for your meta file.
The CAP File and Data Element Selection screen
shown in Figure 3-99 is displayed. (Both the
file-unique selection and summary phases shown
in Figure 3-100 occur during this step.) You may
select this option more than once.
Using this screen and its associated exit
screens, you can define the CAP data elements
that will comprise your meta file, along with
any file-unique data selection and/or
summarization logic.
If you wish to define any data elements that are
derived from data elements from a single CAP
file, you can usually specify the data element
derivation SAS statements through one of the
exit screens associated with this screen. If you
are defining data elements that are derived from
data elements from multiple CAP files, you can
specify the data element derivation SAS
statements in the cross-file data element
definition step.
Insert Specify Option 3, Insert Cross-File Data Element
Cross-File Definition, to define any data elements that you
Data Element wish to derive from data elements from multiple
Definition: CAP files. The Cross-File Data Element
Definition screen shown in Figure 3-102 is
displayed. (This step corresponds to the merge
phase shown in Figure 3-2.) You must also
specify the data element derivation SAS
statements that will be used to derive these
data elements.
Since the specifications associated with this
step apply to the merging of data from multiple
CAP files, you may specify a cross-file data
element definition step only if you specify
multiple CAP file and data element selection
steps. In this case, the cross-file data
element definition step is required to create a
valid file definition inquiry.
Each time you complete the specifications for an individual
step, END from the screen to redisplay the Meta File Menu
shown in Figure 3-104. You can then insert another step in
your meta file definition. Repeat this process until you
define all of the steps necessary to build your meta file.
The three options are further discussed in the following
sections:
1 - Insert Common Data Selection
2 - Insert CAP File and Data Element Selection
3 - Insert Cross-File Data Element Definition
3.4.2.1.2.1 Insert Common Data Selection
If you select Option 1, Insert Common Data Selection, on the
Meta File menu, the Common Data Selection screen shown in
Figure 3-97 is displayed.
/--------------------------- Common Data Selection ---------------------------\
|Command ===> |
|Enter a ? in any data entry field for more information on valid values. |
|Composing CAP DB File def.: SYS - System Activity Tracking File |
| |
| |
|SYSID ===> ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ |
| ____ ____ ____ ____ ____ |
| |
|Zone ===> _ _ _ _ _ _ _ _ _ (1 - 9) |
| |
|Hour ===> __ - __ __ - __ __ - __ __ - __ __ - __ (0 - 23) |
| |
|Dayname ===> _________ _________ _________ _________ _________ |
| |
| |
| |
| |
| |
| |
| |
| |
|Specify common data selection SAS statements ===> N (Y/N/R) |
\------------------------------------------------------------------------------/
Figure 3-97. Common Data Selection Screen
The data selection criteria that you specify using this
screen is applied to each CAP file that provides input data
in creating and updating your Capacity Planning database
file.
The parameters for the Common Data Selection screen are
defined below:
SYSID: The SYSIDs that you wish to include in your
Capacity Planning database file. You may
specify a maximum of 15 one- to four-character
SYSIDs. Leave this parameter blank to include
data for all SYSIDs. The standard method is to
create one record for each SYSID that is created
for each day, week, or month processed.
Alternatively, you may wish to summarize
multiple SYSIDs into a single record.
Zone: The zones that you wish to include in your
Capacity Planning database file. You may
specify a maximum of nine one-character zones.
Leave this parameter blank to include data for
all zones. The standard method is to create one
record for each zone that is created for each
week or month processed. Alternatively, you may
wish to summarize multiple zones into a single
record.
Hour: The hours that you wish to include in your
Capacity Planning database file. You may
specify a maximum of five hours or hour ranges.
Leave this parameter blank to include data for
all hours.
Dayname: The specification of up to five daynames to be
included in the Capacity Planner database file.
Leave blank to include all days. Input the
first unique characters and the Capacity Planner
will fill in the rest. Specification of this
parameter is only valid when the input timespan
is DETAIL or DAYS.
Specify The specification for the SYSIDs and zones or
common data hours to be used for data selection from the
selection CAP input file(s). Specify Y (YES) to display
SAS the SAS Statements screen shown in Figure 3-98.
statements: Specify R (Reset) to reset any specifications
you previously made to SYSID and zone or hour.
/--------------------------- SAS System Statements --------------------------\
|Command ===> Scroll ===> CSR |
| |
|SAS Statements for the SELECT Macro |
|------------------------------------------------------------------------------|
|************************************ TOP OF DATA *****************************|
|==MSG> ENTER THE SAS STATEMENTS TO SET CAPAPU VALUES. |
|=NOTE= %MACRO SELECT; <=== PLEASE DO NOT PLACE LINES BEFORE THIS LINE. |
|000001 |
|000002 |
|000003 |
|000004 |
|000005 |
|000006 |
|000007 |
|000008 |
|000009 |
|000010 |
|=NOTE= %MEND SELECT; <=== PLEASE DO NOT PLACE LINES AFTER THIS LINE. |
|*********************************** BOTTOM OF DATA ***************************|
| |
\------------------------------------------------------------------------------/
Figure 3-98. SAS Statements Screen - Selecting Common Data
Using the SAS Statements screen shown above, you can specify
your own data selection logic to apply to each CAP file that
provides input data to your Capacity Planning database file.
The special data element, CAPIFILE, is available to the
SELECT MACRO and can be used in subsetting the input file.
Note that the %MACRO SELECT and %MEND SELECT statements are
provided for you and that they are field-protected from
modification.
3.4.2.1.2.2 Insert Capacity File and Data Element Selection
If you select Option 2, Insert CAP File and Data Element
Selection, on the Meta File menu, the CAP File and Data
Element Selection screen shown in Figure 3-99 is displayed.
/------------- 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.: SYS - System Activity Tracking File |
| |
|CAP file ===> WK1 (fff) - Workload Standard Application |
| -------Line Commands--------|
|Include CAPAPUs ===> N (Y/N) | 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 _____ 7 DATE7. |
| _ MONTH Month of Year |
| _ RET N _____ 2 _____________|
| _ SYSID System Identifier |
| _ RET A _____ 4 _____________|
| _ YEAR Year of Century |
| _ RET N _____ 2 _____________|
| _ ZONE Time Zone |
| _ RET A _____ 1 _____________|
|******************************* BOTTOM OF DATA *******************************|
| |
\------------------------------------------------------------------------------/
Figure 3-99. CAP File and Data Element Selection Screen
The parameters for the CAP File and Data Element Selection
screen are defined as follow:
CAP file: The Capacity Planner file that contains the data
elements that you wish to include in your meta
file or that you wish to use in deriving data
elements. If you are uncertain of the file
name, type a question mark (?) in this field to
obtain a complete selection list for your site.
Include The specification for whether the application
CAPAPUs: unit (CAPAPU) data element is to be included in
the summarization sequence for this file. This
parameter defaults to Y (YES) if CAPAPU is
defined for this meta file. The CAPAPU
derivation exit is invoked for each input file
observation. If you do not want to include
CAPAPU in the summarization sequence, type an N
(NO) in this field.
Specify The specification for CAP file processing
file exits: exits. You must specify a Y (YES) if you intend
to code CAP file-unique data selection, or data
derivation logic. If you specify a Y, the CAP
File Processing Exits Menu shown in Figure 3-100
is displayed.
The display portion of this screen contains a scrollable list
of the data elements that you can either include in your
Capacity Planning database file or use to derive other data
elements. It contains the following fields:
Cmd: The line commands are:
I (insert) to insert a new data element.
R (repeat) to repeat a data element.
S (depend clauses and label) to specify
independent data elements upon which this
data element depends. See Figure 3-14.
C (copy) to copy a data element.
E (expression) to create SAS code to calculate
the value of this specific data element. See
Figure 3-15.
D (delete) to delete a data element.
Name: The name of the data element. This may be
either the name of a data element that exists in
the input CAP file or any valid SAS name, as
described in the SAS manuals. If you wish to
define new data elements, choose variable names
that are descriptive of the values they
represent.
Note that when you first see this screen, it
displays only the control data elements that are
always present in your Capacity Planning
database file. If you attempt to modify these
data elements, an error will occur. Define an
additional row for each data element that you
wish to include in your Capacity Planning
database file by typing an I (INSERT) in the Cmd
column of any existing row.
If you are uncertain of the correct spelling of
a CAP data element or if you would like to see a
complete list of the CAP data elements available
in the Capacity Planner input file, type a
question mark (?) in the name field to display
the screen shown in Figure 3-101.
Data Element The data element label that is displayed on the
Label CAP File and Data Element Selection screen and
(long name): on many reports. This label is supplied
automatically for input data elements.
D: The data element drop flag. Typing a D in this
field makes the corresponding data element
available for use in calculations through the
cross-file data element definition step of the
Capacity Planning database file update, but
drops the data element from the resulting
Capacity Planning database file. Leave the
field blank to keep the corresponding data
element on the Capacity Planning database file.
Sum Type: The summarization type of the data element.
Summarization types are RET (retain), ACCM
(accumulate), MIN (minimum), MAX (maximum), and
COMP (compute).
Date type: The type of data element. This is used to
validate data values and usage for the data
element. Valid types are Alphanumeric (A),
Numeric (N), Money (M), Time (T), Hex (H), Date
(D), Time-of-day (TD), and Date-Time (DT). This
value is supplied automatically for CA MICS data
elements.
Order: Define the execution order of the data elements
you defined by entering ordinal numeric values
greater than 1000.
Note: This is required if you are going to use
this Resource Element file as input to a Meta
file.
The order value is automatically defined for
CA MICS data elements and Capacity Planner
Control elements. Data elements that require
other data elements are automatically included
in the Capacity Planner database file. In
particular, two variables that will not show
up in the output file: @@FIRST and @@LAST.
Len: The length of the data element. This value is
supplied automatically for CA MICS data
elements.
Output The SAS format that is used to print data
Format: element values. This value is supplied
automatically for CA MICS data elements.
/--------------- Capacity Planner File Processing Exits Menu ----------------\
|Command ===> |
| |
|Inquiry Step: File & Data Element Sel.: WK1 - Workload Standard Application |
| |
| |
|Specify file unique data selection SAS stmts. ===> N (Y/N/R) |
| (file level SELECT exit) |
| |
|Specify new data element derivation SAS stmts. ===> N (Y/N/R) |
| (file transpose and summary exit) |
| |
|Set expression statements for data elements. ===> N (Y/N) |
| (convert SAS stmts to Expression stmts) |
| |
| |
| |
| |
\------------------------------------------------------------------------------/
Figure 3-100. CAP File Processing Exits Menu
Figure 3-100 shows the CAP File Processing Exits Menu that is
displayed if you specify a Y (YES) for the Specify CAP file
processing exits parameter on the CAP File and Data Element
Selection screen shown in Figure 3-99.
The following options are available:
Specify
file unique
data Specify a Y (YES) to supply SAS statements in
selection the CAPSLCT macro, used to implement a special
SAS stmts: observation selection method.
Specify Specify a Y (YES) to supply SAS statements in
new data the CAPSMRY macro, used to define new data
element elements for the meta file and to calculate
derivation values for CA MICS derived data elements.
SAS stmts:
Set
expression
statements Set to Y (YES) to convert existing Meta file
for data SAS statements to expression statements or
elements: calculations.
The CAPSMRY exit should only be used for the setting the
initial value of non-Computed variables or to transpose the
CAP file. The SAS Statements necessary to set the value for a
Computed variable should be placed in Expression Statements.
The following illustration describes the CAPSMRY exit.
Data Need SAS Need
Element Code in Expression
Type CAPSMRY? Statement?
Maximum Yes, to set No, handled
initial value automatically
in Meta files
Minimum Yes, to set No, handled
initial value automatically
in Meta files
Accumulated Yes, to set No, handled
initial value automatically
in Meta files
Retained Yes, to set No, handled
initial value automatically
in Meta files
Computed No Yes, Expression
statements used
in Meta files
when variable
is created and
in subsequent
Meta Files.
/---------------- Converting Macros to Expression Statements ----------------\
|Command ===> Scroll ===> CSR |
| |
|Enter the variable names that are associated with the SAS statements shown |
|below. |
| |
|Variable SAS Statements in Macro |
|-------- ------------------------------------------------------------------ |
|MYVAR2__ IF CPUAVB GT 10 /* IF THE AVERAGE NUMBER OF BATCH JOBS */ |
|MYVAR2__ THEN MYVAR2 = 'CHECK'; /* IS GREATER THAN 10 WE SHOULD */ |
|MYVAR2__ ELSE MYVAR2 = 'OK'; /* CHECK IT OUT */ |
|****************************** BOTTOM OF DATA ********************************|
\------------------------------------------------------------------------------/
Figure 3-101. Converting Macros to Expression Statements
You use this screen (see Figure 3-101) to convert existing
MACRO statements into Expression Statements that calculate
the value of a particular variable. In the example shown in
Figure 3-101, the variable MYVAR2 is a user-created data
element that is used to warn the user of this file whenever
CPUAVB is larger than 10. This variable was originally
created using the CAPSMRY MACRO. By placing "MYVAR2" in the
Variable Column of this screen the Capacity Planner will
automatically associate these SAS Statements with MYVAR2.
When you End from this display the Capacity Planner will
remove the statements from the MACRO and move them into the
Expression Statement table for the variable MYVAR2.
/--------------------------- Data Element Selection --------------------------\
|Command ===> Scroll ===> CSR |
| |
|Inquiry Step: Common Data Selection |
|Input File: WK1 - Workload Standard Application |
| |
|Line Cmds: S Select H Data Dictionary Display |
| |
| Select Data Elements |
|Cmd Element Data Element Label (long name) |
| - -------- ---------------------------------------- |
| _ CAPAPU Workload Group |
| _ CPUDUR Recording Interval Time |
| _ CPUTOBTM Total Time Processor Busy |
| _ CPUTOUTM Total Processor Up Time |
| _ DATE Interval End Date |
| _ DESCRIPT Workload Group Long Name |
| _ HOUR Hour of Day |
| _ MVSLEVEL MVS Software Level |
| _ PAGPIN Non-VIO Non-Swap Page-Ins |
| _ PCATRCPU Percent of CPU Attributable to Workload |
| _ PCTOTCPU Percent Total CPU Time Consumed |
| |
\------------------------------------------------------------------------------/
Figure 3-102. Data Element Selection Screen
If you enter a question mark (?) in the Data Element Label
field of the CAP File and Data Element Selection screen shown
in Figure 3-99, the Data Element Selection screen (Figure
3-102), which is the final screen in this series, is
displayed. This screen lists the data elements in the CAP
file that you specified. To include data elements in the
meta file, place an S (SELECT) in the Cmd column to the left
of the data element you want to include in your meta file.
3.4.2.1.2.3 Insert Cross-File Data Element Definition
If you specify data selection from more than one CAP file
(using Option 2 on the Meta File menu shown in Figure 3-96),
you must also insert a cross-file data element definition
step in your meta file definition. Select Option 3, Insert
Cross-File Data Element Definition from the Meta File Menu,
to define data elements that are calculated from data
elements contained in more more than one file. This screen
displays all the data elements, including the control data
elements, that you selected from all CAP files.
/--------------------- Cross-File Data Element Definition -------------------\
|Command ===> Scroll ===> CSR |
|Enter a ? in any data entry field for more information on valid values. |
|Composing CAP DB File def.: SYS - System Activity Tracking File |
| |
|Specify: -------Line Commands--------|
| SAS exit stmts. ===> N (Y/N/R) | I Insert C Copy D Delete ||
| | R Repeat E Calculations ||
| Expression stmts. ===> N (Y/N) | S Depend Clauses & Label ||
| ----------------------------|
| Sum Data |
|Cmd Name Label (long name) D Type Type Order Len Output Format|
| - -------- ----------------------------- - ---- ---- ----- --- -------------|
| _ CPUAVT Workload Group |
| _ RET N 000 5 _____________|
| _ DATE Workload Group 2 |
| _ RET D 000 7 DATE7._______|
| _ JOBCPUTM Workload Group 3 |
| _ RET T 000 10 TIME14.2_____|
| _ MONTH Workload Group 4 |
| _ RET N 000 2 _____________|
| _ SYSID Workload Group 5 |
| _ RET A 000 4 _____________|
| _ YEAR Workload Group 6 |
| _ RET N 000 2 _____________|
| _ ZONE Workload Group 7 |
| _ RET A 000 1 _____________|
|****************************** BOTTOM OF DATA *******************************|
\------------------------------------------------------------------------------/
Figure 3-103. Cross-File Data Element Definition Screen
The parameters for the Cross-File Data Element Definition
screen are defined below:
Specify The specification for assigning SAS statements
SAS exit to derive cross-file elements. Specify a Y
stmts: (YES) if you wish to define cross-file data
elements. (See Figure 3-103.)
Specify The specification for defining Expression
Expression statements. Specify a Y (YES) if you wish to
stmts: define expression statements.
Cmd: The line commands are:
I (insert) to insert a new data element.
R (repeat) to repeat a data element.
S (depend clauses and label) to specify
independent data elements upon which this
data element depends. See Figure 3-14.
C (copy) to copy a data element.
E (expression) to create SAS code to calculate
the value of this specific data element. See
Figure 3-15.
D (delete) to delete a data element.
Name: The name of the data element. This may be
either the name of a CA MICS data element that
exists in the input CAP file or any valid SAS
name, as described in the SAS manuals. If you
wish to define new data elements, choose
variable names that are descriptive of the
values they represent.
Note that the screen displays the CA MICS
control data elements that are always present in
your meta file. If you attempt to modify these
data elements, an error will occur. Define an
additional row for each data element that you
wish to include in your meta file by typing an I
(INSERT) in the Cmd column of any existing row.
Data Element The data element label that is displayed on the
Label CAP File and Data Element Selection screen and
(long name): on many reports. This label is supplied
automatically for CA MICS data elements.
D: The data element drop flag. Typing a D in this
field makes the corresponding data element
available for use in calculations through the
cross-file data element definition step of the
Capacity Planning database file update, but
drops the data element from the resulting
Capacity Planning database file. Leave the
field blank to keep the corresponding data
element on the Capacity Planning database file.
Sum Type: The summarization type of the data element:
RET (retain), ACCM (accumulate), MIN (minimum),
MAX (maximum), and COMP (compute).
Date type: The type of data element. This is used to
validate data values and usage for the data
element. Valid types are Alphanumeric (A),
Numeric (N), Money (M), Time (T), Hex (H), Date
(D), Time-of-day (TD), and Date-Time (DT). This
value is supplied automatically for CA MICS data
elements.
Order: Define the execution order of the data elements
you defined by entering ordinal numeric values
greater than 3000.
Note: This is required if you are going to use
this Resource Element file as input to a Meta
file.
The order value is automatically defined for
CA MICS data elements and Capacity Planner
Control elements. Data elements that require
other data elements are automatically included
in the Capacity Planner database file. In
particular, two variables could appear that will
not show up in the output file: @@FIRST and
@@LAST.
Len: The length of the data element. This value is
supplied automatically for CA MICS data
elements.
Output The SAS format that is used to print data
Format: element values. This value is supplied
automatically for CA MICS data elements.
/-------------------------- SAS System Statements ---------------------------\
|Command ===> Scroll ===> CSR |
| |
|Inquiry Step: Cross-file data element derivation |
| |
|SAS Statements for the CAPMERG Macro |
|------------------------------------------------------------------------------|
|****** ***************************** TOP OF DATA *****************************|
|==MSG> ENTER THE SAS STATEMENTS TO SET VARIABLES IN THE CROSS-FILE MERGE. |
|=NOTE= %MACRO CAPMERG; <=== PLEASE DO NOT PLACE LINES BEFORE THIS LINE. |
|000001 |
|000002 |
|000003 |
|000004 |
|000005 |
|000006 |
|000007 |
|000008 |
|000009 |
|000010 |
|=NOTE= %MEND CAPMERG; <=== PLEASE DO NOT PLACE LINES AFTER THIS LINE. |
|****************************** BOTTOM OF DATA *******************************|
| |
\------------------------------------------------------------------------------/
Figure 3-104. SAS Statements Screen - Deriving Cross-file Data Elements
Using the SAS Statements screen shown in Figure 3-104 above,
you can code any valid SAS statements that conform to the
syntax described in the SAS manuals to derive new data
elements.
Note that the %MACRO CAPMERG and %MEND CAPMERG statements are
provided for you and that they are field protected from
modification.
/---------------- Converting Macros to Expression Statements ----------------\
|Command ===> Scroll ===> CSR |
| |
|Enter the variable names that are associated with the SAS statements shown |
|below. |
| |
|Variable SAS Statements in Macro |
|-------- ------------------------------------------------------------------ |
|RATIO___ IF CPUTOBTM GT 0 |
|RATIO___ THEN RATIO = PGACPUTM / CPUTOBTM; |
|RATIO___ ELSE RATIO = .; |
|________ |
|****************************** BOTTOM OF DATA ********************************|
\------------------------------------------------------------------------------/
Figure 3-105. Converting Macros to Expression Statements
You use this screen (see Figure 3-105) to convert existing
MACRO statements into Expression Statements that calculate
the value of a particular variable. In the example shown in
Figure 3-105, the variable RATIO is a user-created data
element that corresponds to the ratio of Performance Group
Activity (PGA) file CPU time consumed and the total Busy time
of the processor. By placing "RATIO" in the Variable Column
of this screen the Capacity Planner will automatically
associate these SAS Statements with RATIO. When you End from
this display the Capacity Planner will remove the statements
from the MACRO and move them into the Expression Statement
table for the variable RATIO.
Copyright © 2014 CA.
All rights reserved.
|
|