Previous Topic: 3.3.2.2 Modifying a Database SpecificationNext Topic: 3.3.3 Resource Element File Case Studies


3.3.2.3 Executing a Database Specification

 
When you select a resource element file definition, including
standard applications, for execution, the Update Capacity
Planning screen shown in Figure 3-26 is displayed.
/----------------------- 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.                    |
|                                                                               |
\------------------------------------------------------------------------------/
 
 Figure 3-26.  Update Capacity Planning File Screen

The parameters for the Update Capacity Planning File screen
are described below:
 
Type of      The specification for initializing or updating
update:      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 wish to add to an existing
             file, specify UPDATE.
 
             Note that 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      The specification for deleting an old file and
existing     replacing it with a new file.  If you specify
file?        INITIALIZE and the file already exists, you must
             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   The specification for extracting online or
source:      archived data.  Specify ONLINE if the data that
             you wish to extract from the CA MICS files is in
             the online portion of the CA MICS database.
             Specify ARCHIVE if you wish the data to be read
             from a CA MICS history archive tape.
 
             Note:  If any of the input files have an input
             timespan of DETAIL or DAYS, you may only use
             ONLINE as your input data source.

CA MICS file The CA MICS file cycles to be used as input to
cycle(s):    loading the resource element file if you
             specify ONLINE for Data source.

Archive
generation   The archive generations that you wish to use as
number:      input if you specify ARCHIVE for data source.

Update       The start date for date range selection.  If
starting     Start date is specified, only historical
date:        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    The maximum number of days, weeks, or months of
days/weeks/  historical observations to be included in the
months to    analysis.  Note that once you specify the input
select:      file, the field name changes to reflect the
             timespan of the input file.  When used in
             conjunction with the Start date parameter,
             several options are available for date range
             selection control:
 
             o  If you specify only Update start date, all
                historical observations at least as recent as
                the value specified for Update start date
                is selected.

             o  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.

             o  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.

             o  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 the CA MICS
                calendar.

Mode of      The specification for executing the resource
execution:   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         The specification to execute a PROC CONTENTS and
updated      a PROC PRINT of the resource element file to be
file         executed after the database is updated.  To do
contents?    so, specify a Y (YES).

The CA 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 Section 1.5.3.5, Executing a File Definition
Inquiry.