Previous Topic: 3.4.2.2 Modifying a Database SpecificationNext Topic: 3.4.3 Meta File Case Studies


3.4.2.3 Executing a Database Specification

 
When you select a meta file definition a special Update
Capacity Planning Meta File screen is displayed (an example
is shown in Figure 3-108).
 
 
/-------------------  Update Capacity Planning Meta File  ----------------------\
|Command ===>                                                                   |
|                                                                               |
|Composing CAP DB File def.:  SYS - System Activity Tracking File               |
|                                                                               |
|Update type                               ===> INITIALIZE (INITIALIZE/UPDATE)  |
|Replace existing                          ===> N (Y/N)                         |
|Private Capacity Planner data base cycle  ===> 01                              |
|Update start date                         ===> _______ (ddmonyy)               |
|Number of months                          ===> ____ (1-9999)                   |
|Execution mode                            ===> BATCH      (BATCH/FOREGROUND)   |
|                                                                               |
|List updated CAP DB file contents         ===> YES (YES/NO)                    |
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
|                                                                               |
|Press END to invoke MICF inquiry execution to update the meta file.            |
|Enter CANCEL to terminate the meta file update.                                |
\------------------------------------------------------------------------------/
  
 Figure 3-108.  Update Capacity Planning Meta File Screen

The parameters for the Update Capacity Planning File screen
are described below:
 
Update type: The specification for initializing or updating
             the Capacity Planning database file.  If the
             meta 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
             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).
 
 
Capacity
Planner      The Private (or Shared) Capacity Planner
Database     database file cycle you wish to use as input
Cycle:       into the meta file update run.
 
Update       The start date for date range selection.  If
start date:  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    The maximum number of days, weeks, or months of
days/        historical observations to be included in the
weeks/       analysis.  Note that once you specify the input
months:      file, the field name changes to reflect the
             time-span 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 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 is 1 for Number of
                days/weeks/months, based on the CA MICS
                calendar.
 
Execution    The specification for executing the meta file
mode:        update.  Specify BATCH to submit the meta file
             update as a batch job. Specify FOREGROUND to
             execute it immediately as an online SAS program.
 
List updated The specification to execute a PROC CONTENTS and
CAP DB file  a PROC PRINT of the meta file to be executed
contents:    after the database is updated.  To do so,
             specify a Y (YES).
 
The CA MICS Database Inquiry Execution screen shows 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.