CAP Creating a File Definition Inquiry
Creating a capacity planning database file is easy:
rm
Creating a capacity planning database file is easy:
- You tell the online facility that you are about to create a file definition inquiry.
- You give the file definition inquiry a name and assign it to a catalog group.
- You specify the file definition process you plan to use.
- You decide to save, execute, or cancel the file definition inquiry.
Note:
If you decide to execute the inquiry, 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. The Backups, Restores, and Compression section 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 (see Figure 1-2 in CAP Getting Started with the Online Facility ). The Capacity Planning Data Base Files screen that is shown in the following Figure 1-3 is displayed. You can use this screen to create, modify, and delete capacity planning database files.
Figure 1-3, Capacity Planning Data Base Files Screen - PRIVATE Catalog
/--------------------- 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 ********************************| | | | | | | | | | | | | | | | | | | | | --------------------------------------------------------------------------------
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 that are 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:
- Specify MODIFY to modify an existing file definition.
- 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 that is shown in the following Figure 1-4.
Figure 1-4, Insert Capacity Planning Data Base File Screen
/------------------ 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. | | | ---------------------------------------------------------------------------------
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. If you want to change any of the information about this screen later, first make a copy of the inquiry.
As shown in the previous Insert Capacity Planning Data Base File Screen figure, there are four different types of capacity planning processes that you can use to create a file definition inquiry: For more information, see Sample Planning Applications and Capacity Planning Database.
- Choosing Option 1 allows you to use one of the Capacity Planner sample applications for capacity planning.
- Choosing Option 2 allows you to create capacity planning business element files that contain business activity-related data elements defined by you.
- Choosing Option 3 allows you to create a user-defined capacity planning database file using historical data from theMICSdatabase. However, unlike the sample applications, you must specify ALL file definition parameters.
- 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 theMICSdatabase, meta files use the shared or private Capacity Planner database.
Depending on the option that 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.