1. OVERVIEW › 1.5 Online Facility Tutorial › 1.5.3 Capacity Planning Database File Definition Inquiries › 1.5.3.1 Creating a File Definition Inquiry
1.5.3.1 Creating a File Definition Inquiry
Creating a capacity planning database file is easy:
o You tell the online facility that you are about to create a
file definition inquiry.
o You give the file definition inquiry a name and assign it
to a catalog group. (A discussion of catalog groups
follows.)
o You specify the file definition process you plan to use.
o You choose to save, execute, or cancel the file definition
inquiry.
Note: If you decide to execute the inquiry, you must save
it first.
As a user of the online facility, you will have your own
private catalog of file definition inquiries. Before you
create your first file definition inquiry, there is no
PRIVATE capacity planning database for your user ID, but the
first time you try to store data for a file definition
inquiry, a PRIVATE capacity database is allocated
automatically. This is illustrated below.
This database is a SAS Data Library with your user ID as the
high-level prefix. The historical data and forecasts for the
first and for all future inquiries will be stored in this
PRIVATE capacity database. Section 12.2 of this guide
provides backup and restore procedures that should be applied
to your PRIVATE database.
To create a file definition inquiry, select Option 1,
Capacity Planning Data Base Files, from the primary Capacity
Planner menu (refer to Figure 1-2). The Capacity Planning
Data Base Files screen shown in Figure 1-3 is displayed. You
can use this screen to create, modify, and delete capacity
planning database files.
/--------------------- Capacity Planning Data Base Files ---------------------\
|Command ===> Scroll ===> PAGE |
| |
|Catalog ===> PRIVATE (PRIVATE/SHARED) ---------Line Commands-----------|
|Catalog group ===> CAPACITY |A Add Notes B Browse S Select ||
|Select mode ===> EXECUTE (EXECUTE/MODIFY) |M Modify E Execute I Insert ||
|Name (subset) ===> ___ |R Repeat C Copy D Delete ||
| ---------------------------------|
| |
|Cmd Name Title Type Status |
| - -------- ---------------------------------------- - -----------------|
| _ DAS DASD Sample Application S Updated 05/11/30|
|****************************** BOTTOM OF DATA ********************************|
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
\------------------------------------------------------------------------------/
Figure 1-3. Capacity Planning Data Base Files Screen - PRIVATE Catalog
When you enter the Capacity Planning Data Base Files screen,
the default specification for Catalog is PRIVATE. The SHARED
catalog facility permits you to copy inquiries that exist in
the shared catalog into your private catalog.
Each catalog is divided into catalog groups. These groups
contain the actual database file definition inquiries. When
the Catalog group field contains no specification, the lower
part of the screen displays the names of the various catalog
groups that have been defined.
When you select a catalog group, either by typing an S
(Select) in the Cmd column or by typing a catalog group name
after the Catalog group prompt, the display portion of the
screen shows the database file definition inquiries
contained in that catalog group. To see the list of all file
definition inquiries in your catalog, place an asterisk (*)
after the Catalog group prompt. To see the list of all
inquiries in all catalog groups starting with the same
sequence of characters, code the sequence, followed by an
asterisk, after the Catalog group prompt. For example,
Catalog Group ====> S*
If you type S*, as shown in the example, you will see all
the definitions in all catalog groups starting with the
letter S.
If the list of inquiries is long, you can scroll through it
using the standard ISPF DOWN and UP commands. You can subset
the list of inquiries by entering the beginning characters
of the names you are interested in after the Name prompt.
Only inquiries with names starting with these characters are
shown.
The Select mode controls the action of the S (Select) line
command and the SELECT primary command. The two possible
values are EXECUTE or MODIFY, which default to the last value
specified for this parameter:
o Specify MODIFY to modify an existing file definition.
o Specify EXECUTE to update a capacity planning database file
(that is, execute the file definition inquiry).
The information about each file definition inquiry is
displayed on a single line and includes the inquiry name,
title, type of inquiry process (discussed below), and current
status of the inquiry.
To create a new database file definition inquiry, type an I
(Insert) on any line in the Cmd column. The Insert Capacity
Planning Data Base File screen shown in Figure 1-4 is
displayed.
/------------------ Insert Capacity Planning Data Base File ------------------\
|Option ===> |
| |
| File Name ===> ___ |
| Title ===> _______________________________________ |
| Author ===> CA |
| |
|Catalog Group Name ===> SAMPLES |
| Title ===> Sample Application Files |
| |
| |
| 1 - Sample Applications |
| Specify file definition parameters for one of the |
| capacity planning sample applications. |
| 2 - Business Element File |
| Specify file definition parameters for a file of user |
| specified business element data. |
| 3 - Resource Element File |
| Specify file definition parameters for a file of actuals |
| from the CA MICS database. |
| 4 - Meta File |
| Specify file definition parameters for a file of actuals |
| from the Capacity Planner database. |
| |
\------------------------------------------------------------------------------/
Figure 1-4. Insert Capacity Planning Data Base File Screen
On the Insert Capacity Planning Data Base File screen, you
can specify the inquiry name (one to three characters),
title, and author. The catalog group name and title are
copied from the information that applies to the line on which
you entered the I. If you want to change either of them, you
can do so here. Note that if you want to change any of the
information on this screen later, you must first make a copy
of the inquiry.
As shown in Figure 1-4, there are four different types of
capacity planning processes that you can use to create a file
definition inquiry: (Each of these is discussed in detail in
Chapters 2 and 3 of this guide.)
o Choosing Option 1 allows you to use one of the Capacity
Planner sample applications for capacity planning.
o Choosing Option 2 allows you to create capacity planning
business element files that contain business activity
related data elements defined by you.
o Choosing Option 3 allows you to create a user-defined
capacity planning database file using historical data from
the CA MICS database. However, unlike the sample
applications, you must specify ALL file definition
parameters.
o Choosing Option 4 allows you to create a user-defined meta
capacity planning database file. Meta files are similar to
Resource Element files; however, rather than using data
from the CA MICS database, meta files use the shared or
private Capacity Planner database.
Depending on the option you specify on this screen, pressing
ENTER will give you a series of screens that allow you to
complete the specifications for your file definition inquiry.
Copyright © 2014 CA.
All rights reserved.
|
|