Previous Topic: 1.5.4 Capacity Planning Analysis InquiriesNext Topic: 1.5.4.2 Modifying an Existing Analysis Inquiry


1.5.4.1 Creating an Analysis Inquiry


As with creating a capacity planning database file definition
inquiry, the process of creating an analysis inquiry is
straightforward.  You tell the online facility that you are
about to create an inquiry.  Then you give the inquiry a name
and assign it to a catalog group (a discussion on catalog
groups follows).  Next, you define the analysis technique you
plan to use.  At this point, you can choose to cancel, save,
or execute the inquiry.  If you decide to execute the inquiry
before saving it, you will have an opportunity to cancel,
save, or modify it after execution.

To create an analysis inquiry, select Option 2, Capacity
Planning Analysis, from the primary Capacity Planning menu
(refer to Figure 1-2).  The Capacity Planning Analysis screen
shown in Figure 1-13 displays.  You can initiate all of the
manipulations (that is, creating, modifying, and deleting) of
analysis inquiries from this screen.  You can create an
inquiry by inserting an entirely new one, by repeating an
existing one found in your private catalog, or by copying an
existing one from the shared inquiry catalog.  Line commands
exist for each of these functions.


/-------------------------  Capacity Planning Analysis  -------------------------\
|Command ===>                                                  Scroll ===> PAGE  |
|                                                                                |
|Catalog       ===> PRIVATE (PRIVATE/SHARED)   ----------Line Commands --------  |
|Catalog group ===> CAPACITY                   |S Select  M Modify  E Execute |  |
|Select mode   ===> MODIFY  (EXECUTE/MODIFY)   |I Insert  R Repeat  C Copy    |  |
|Name (subset) ===> ________                   |D Delete                      |  |
|                                              --------------------------------  |
|                                                                                |
|Cmd    Name                    Title                       Date    Time   Type  |
| -   --------  ----------------------------------------  --------  ----- ------ |
| _   BEFM1     Business Element Forecast - BEF File      98/05/03  18:16 CAPBEF |
| _   CLUC1     Workload Characterization                 98/05/03  17:27 CAPCLU |
|****************************** BOTTOM OF DATA  ******************************** |
|                                                                                |
|                                                                                |
|                                                                                |
|                                                                                |
|                                                                                |
|                                                                                |
|                                                                                |
|                                                                                |
|                                                                                |
|                                                                                |
\------------------------------------------------------------------------------/

 Figure 1-13.  Capacity Planning Analysis Screen - PRIVATE Catalog

As a user of the online facility, you have your own private
catalog of analysis inquiries.  The SHARED Catalog inquiry
catalog can be displayed by replacing PRIVATE with SHARED in
the Catalog field.  This permits you to copy inquiries from
the shared catalog to your own private inquiry catalog.  When
you enter the Capacity Planning Analysis screen, the default
specification for Catalog is whatever you specified the last
time you accessed either catalog.

The methods for working with the SHARED and PRIVATE catalogs
are similar to those described for file definition inquiries.
For more information on working with SHARED or PRIVATE
catalogs, see Section 1.5.3.1.

To create a new analysis inquiry, type an I (Insert) on any
line in the Cmd column or use the CREATE primary command.
The Insert Capacity Planning Analysis screen shown in Figure
1-14 displays.

/---------------------  Insert Capacity Planning Analysis  ---------------------\
|Option ===>                                                                     |
|                                                                                |
|     Inquiry Name   ===> BEFMI                                                  |
|             Title  ===> Business Element Forecast - BEF File                   |
|             Author ===> Charles Frost                                          |
|                                                                                |
|Catalog Group Name  ===> CAPACITY                                               |
|              Title ===> Capacity Planning                                      |
|                                                                                |
|                                                                                |
|        1 - Workload Characterization                                           |
|            Identify groupings or clusters within a workload.                   |
|        2 - Workload Forecasting                                                |
|            Review workload trends, forecast future workloads, and              |
|            generate graphic reports.                                           |
|                                                                                |
|                                                                                |
|                                                                                |
|                                                                                |
|                                                                                |
|                                                                                |
|                                                                                |
\------------------------------------------------------------------------------/

 Figure 1-14.  Insert Capacity Planning Analysis Screen


On the Insert Capacity Planning Analysis screen, you can
specify the inquiry name (one to six 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 make a copy of the definition to
do so.

As shown in Figure 1-14, there are two different types of
capacity planning processes that you can use to create an
analysis inquiry.

Choosing Option 1 allows you to perform workload
characterization inquiries using the SAS FASTCLUS procedure.
This option, and the subsequent screens and menus, is further
discussed in Chapter 11 of this guide.

Choosing Option 2 displays the Workload Forecasting menu
shown in Figure 1-15.  This menu allows you to specify which
of the workload forecasting techniques you plan to use.  When
you select an option from this menu and press ENTER, the
control screens associated with each of the workload
forecasting techniques available in the CA MICS Capacity
Planner are displayed.  These techniques and the associated
control screens are discussed in Chapters 4 through 10 of
this guide.

/----------------------------  Workload Forecasting  --------------------------\
|Option ===>                                                                   |
|                                                                              |
|Composing CA MICS Inquiry: BEFMI Business Element Forecast - BEF File         |
|                                                                              |
|                                                                              |
|        1 - Profile and Trending Analysis                                     |
|            Report history, growth rates, and trends for multiple measures.   |
|        2 - Simple Regression Analysis                                        |
|            Graph historical values with a linear regression forecast.        |
|        3 - Multivariate Regression Forecasting                               |
|            Forecast based on projected future values of other measures.      |
|        4 - Univariate Model Forecasting                                      |
|            Forecast using time-related regression with smoothing.            |
|        5 - Business Element Forecasting                                      |
|            Forecast based on the business plan.                              |
|        6 - Presentation Graphics                                             |
|            Graph history and forecasts for presentation to management.       |
|        7 - Worksheet Effect Reports                                          |
|            Produce reports showing effect of user forecast from worksheets.  |
|                                                                              |
|                                                                              |
|                                                                              |
\------------------------------------------------------------------------------/

 Figure 1-15.  Workload Forecasting Menu