Screen Operation - Executing a Database Specification
When you select a resource element file definition, including standard applications, for execution, the Update Capacity Planning screen that is shown in Figure 3-26 is displayed.
rm
When you select a resource element file definition, including standard applications, for execution, the Update Capacity Planning screen that is shown in Figure 3-26 is displayed.
Figure 3-26. Update Capacity Planning File Screen
/----------------------- Update Capacity Planning File -------------------------\ |Command ===> | | | |Composing CAP DB File def.: R03 - sample resource element file | | | |Type of update ===> INITIALIZE (INITIALIZE/UPDATE) | |Replace existing file? ===> N (Y/N) | | | |Input data source ===> ARCHIVE (ARCHIVE/ONLINE) | |CA MICS file cycle(s) ===> __ - __ (0 - 99) | |Archive generation number ===> 0 (0 to -99) | | | |Starting date of update ===> _______ (ddmonyy) | |Number of months to select ===> ____ (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. | | | --------------------------------------------------------------------------------
The parameters for the Update Capacity Planning File screen are described below:
Type of update
The specification for initializing or updating the Capacity Planning database file. If the resource element file does not exist or if you plan to overwrite the current file, specify INITIALIZE. If you want to add to an existing file, specify UPDATE.
If you specify INITIALIZE and the file already exists, all historical and forecasted observations that you previously placed in the file will be lost.
Replace existing file?
The specification for deleting an old file and replacing it with a new file. If you specify INITIALIZE and the file already exists, set this parameter to Y (YES) to delete the old version and confirm your intent to initialize and replace. Otherwise, specify N (NO).
Input data source
The specification for extracting online or archived data. Specify ONLINE if the data that you want to extract from the
MICS
files is in the online portion of the MICS
database. Specify ARCHIVE if you want the data to be read from a MICS
history archive tape.
Note:
If any of the input files have an input timespan of DETAIL or DAYS, you might only use ONLINE as your input data source.MICS
file cycle(s)
The
MICS
file cycles to be used as input to loading the resource element file if you specify ONLINE for Data source.Archive generation number
The archive generations that you want to use as input if you specify ARCHIVE for data source.
Update starting date
The start date for date range selection. If Start date is specified, only historical observations at least as recent as this value are included in the analysis. The discussion of the following control parameter describes the options for controlling date range selection.
Number of days/weeks/months to select
The maximum number of days, weeks, or months of historical observations to be included in the analysis. Note that once you specify the input file, the field name changes to reflect the timespan of the input file. When used along with the Start date parameter, several options are available for date range selection control:
- If you specify only Update start date, all historical observations at least as recent as the value specified for Update start date is selected.
- If you specify both Update start date and Number of days/weeks/months, the date range for data selection begins with the specified value for Start date and extends for the specified number of days, weeks, or months.
- If you specify only Number of days/weeks/ months, the date range for data selection includes that number of days, weeks, or months prior to the submit date.
- If you specify neither parameter, then all historical observations are selected when Update type is INITIALIZE. When Update type is UPDATE, the default of 1 for Number of days/weeks/months updates the Capacity Planning database file with data for the last day/week/month, based on theMICScalendar.
Mode of execution
The specification for executing the resource element file update. Specify BATCH to submit the resource element file update as a batch job. Specify FOREGROUND to execute it immediately as an online SAS program.
List updated file contents?
The specification to execute a PROC CONTENTS and a PROC PRINT of the resource element file to be executed after the database is updated. To do so, specify a Y (YES).
The
MICS database
Inquiry Execution screen appears showing the execution parameters that are available before the dataBASE update job is submitted for processing. This screen and its control parameters and options are discussed in detail in the Executing a File Definition Inquiry section.