2. SAMPLE PLANNING APPLICATIONS › 2.11 DB2 Resource Planning › 2.11.2 Control Parameters
2.11.2 Control Parameters
Relatively few parameters are needed to implement the DB2
Planning Sample Application. The control screens included in
the online facility allow you to quickly enter the required
information.
/--------------------------- DB2 Resource Planning ----------------------------\
|Command ===> |
|Enter a ? in any data entry field for more information on valid values. |
|Composing CAP DB File def.: DB2 - DB2 Resource Planning Sample Application |
| |
|Summarization Level |
| Primary ===> MONTHS (DAYS/WEEKS/MONTHS) |
| Secondary ===> ZONE (ZONE/HOUR/DAYNAME) |
| |
|Input File Time-Span ===> DETAIL (DETAIL/DAYS/WEEKS/MONTHS) |
| |
|Amount of data retained ===> 60 (1-9999 months) |
|Age of oldest forecast ===> 24 (1-9999 months) |
|History cycles ===> 3 (1-99 cycles) |
|Forecast cycles ===> 3 (1-99 cycles) |
| |
|Data base ID (s) ===> ___________________________ |
| |
|DB2 workload definition (CAPAPU) ===> DB2ID (DB2ID/NONE) |
| |
| |
|Specify extended options ===> Y (Y/N) |
\------------------------------------------------------------------------------/
Figure 2-11.01. DB2 Resource Planning Screen
Figure 2-11.01 shows the DB2 Resource Planning screen, which
is the main control screen for the DB2 Resource Planning
Sample Application. It contains the following fields:
Summariza- The output summarization corresponds to the
tion level: combination of the primary and secondary
summarization levels. These control how the
output file is summarized in your capacity
Planning database.
Input file The timespan (either DETAIL, DAYS, WEEKS or
timespan: MONTHS) of the DB2DSU, DB2DSD, and DB2DSY files
that you want to use as input when creating the
capacity Planning database file.
Amount of The number of days, weeks or months of
data historical data to be retained in the CAPxxx01
retained cycle of the capacity planning database file.
Any historical observations older than what you
specify for this parameter are dropped from the
file during the file update.
Age of The number of days, weeks or months that you
oldest want to retain a forecast after it is generated.
forecast: Any forecast older than what you specify for
this parameter is dropped when a new forecast is
generated and saved.
History The number of cycles or versions of the
cycle: historical data you want to retain. A new cycle
is created when the file is updated and the
existing cycles aged (for example, Cycle 01 is
aged to Cycle 02 and Cycle 02 becomes Cycle 03).
Forecast The number of cycles or versions of the forecast
cycle: data you want to retain. A new cycle is created
when you specify forecast aging in one of the
workload forecasting routines and the existing
cycles are aged (for example, Cycle 01 is aged
to Cycle 02 and Cycle 02 becomes Cycle 03).
Database The database unit identifier(s) (up to fourteen
ID(s): units) that contain the DB2DSU, DB2DSD, and
DB2DSY files to be used with this Sample
application. If you are not sure where the
DB2DSU, DB2DSD and DB2DSY files reside, type a
question mark (?) in this field to display a
listing of the valid database unit identifiers
for this Sample application.
DB2 The options for defining workload groups (see
workload Section 2.11.1, Usage Guidelines).
definition
(CAPAPU):
Specify If you want extended options, enter Y (YES), and
extended the Extended Options Menu (Figure 2-11.02) is
options: displayed.
/--------------------------- Extended Options Menu ---------------------------\
|Command ===> |
| |
|Inquiry Step: DB2 Resource Planning Sample Application |
| |
| |
| |
|Combine all SYSIDs into a composite ===> N (Y/N) |
| Composite SYSID ===> ____ |
| |
|Combine all zones into a composite ===> N (Y/N) |
| Composite zone ===> _________ |
| |
|Specify: |
| Common data selection parameters ===> N (Y/N/R) |
| Global data selection exit ===> N (Y/N/R) |
| Notes report enabled ===> YES (YES/NO) |
| Contents reports enabled ===> YES (YES/NO) |
| |
| |
| |
| |
| |
\------------------------------------------------------------------------------/
Figure 2-11.02. DB2 Resource Planning Extended Options Menu
The extended options available with the DB2 Resource Planning
Sample Application are as follows:
Combine all You can combine SYSIDs in the capacity planning
SYSIDs into database file. Enter Y (YES) if you wish data
a composite: for all of the SYSIDs to be summarized into a
single observation with the Composite SYSID
value.
Combine all You can combine zones, hours, and daynames in
zones/hours/ the capacity planning database file. The prompt
daynames for this field changes to zones or hours or
into a daynames depending on what you specify for the
composite: summary level parameter. Enter Y (YES) if you
want all of the zones, hours, and daynames to be
summarized into a single observation with the
composite value.
Specify Specify the SYSIDs and zones, hours or daynames
common data to select data from the CA MICS input file(s).
selection Enter Y (YES) to display the Common Data
parameters: Selection screen (Figure 2-11.03). Enter R
(RESET) to reset selections you previously made
to SYSID and zone, hour or dayname.
Specify You can use your own SAS statements to select
global data data from the CA MICS input file(s). Enter Y
selection (YES) to display the SAS System Statements
exit: screen (Figure 2-11.04). Enter R (RESET) to
reset any selections you previously made to the
default of no user-specified data selection.
Notes If you have entered notes associated with the
report capacity planning database file definition, a
enabled: Yes in this field prints the note as part of
file updating.
Contents A Yes in this field prints the contents of the
reports Capacity Planner database file as part of file
enabled: updating.
/--------------------------- Common Data Selection ---------------------------\
|Command ===> |
| |
|Inquiry Step: DB2 Resource Planning Sample Application |
| |
| |
|SYSID ===> ____ ____ ____ ____ ____ ____ ____ ____ ____ ____ |
| ____ ____ ____ ____ ____ |
| |
|Zone ===> _ _ _ _ _ _ _ _ _ (1 - 9) |
| |
|Hour ===> __ - __ __ - __ __ - __ __ - __ __ - __ (0 - 23) |
| |
|Dayname===> _________ _________ _________ _________ _________ |
| |
| |
| |
| |
| |
| |
| |
| |
| |
\------------------------------------------------------------------------------/
Figure 2-11.03. Common Data Selection Screen - DB2 Resource Planning
The Common Data Selection screen (Figure 2-11.03) allows you
to define the following data selection criteria:
SYSID: The SYSIDs you want to include in your capacity
Planning database file. You can specify a
maximum of 15 one- to four-character SYSIDs.
Leave this parameter blank to include data for
all SYSIDs.
Zone: Specify up to nine zones to be included in the
capacity planning database file. Leave this
parameter blank to include data for all zones.
Hour: Specify the five hours or hour ranges to be
included in the capacity planning database file.
Selection of this parameter is valid only if you
specify the DETAIL, DAYS, or WEEKS timespan on
the DB2 Resource Planning screen (Figure
2-11.01). Leave this parameter blank to include
data for all hours. You must enter the value to
the left of the dash for singular hour entries.
Dayname: Specify up to five daynames to be included in
the capacity planning database file. Leave
blank to include all days. Input the first
unique characters and the application will fill
in the rest. Selection of this parameter is only
valid when the input timespan is DETAIL or DAYS.
/-------------------------- SAS System Statements ---------- COLUMNS 001 072--\
|Command ===> Scroll ===> PAGE |
| |
|SAS Statements for the SELECT Macro |
|-------------------------------------------------------------------------------|
|****** ***************************** TOP OF DATA ******************************|
|==MSG> SPECIFY SAS STATEMENTS TO SUBSET THE CAPACITY PlanNING DATA BASE FILE. |
|=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 2-11.04. SAS System Statements Screen - DB2 Resource Planning Global Data Selection
The SAS System Statements screen (Figure 2-11.04) lets you
define your own data selection logic. You can code any valid
SAS statements as described in the SAS manuals. The %MACRO
SELECT and %MEND SELECT statements are already provided and
field protected from modification.
Note: This is a PDF/EDIT screen. All PDF/EDIT commands are
available.
Copyright © 2014 CA.
All rights reserved.
|
|