CAP 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 name the the inquiry and assign it to a catalog group. Next, you define the analysis technique you plan to use. At this point, you can decided 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.
rm
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 name the inquiry and assign it to a catalog group. Next, you define the analysis technique you plan to use. At this point, you can decided 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 in CAP Getting Started with the Online Facility). The Capacity Planning Analysis screen shown the following figure 1-13 Capacity Planning Analysis Screen - PRIVATE Catalog. You can initiate all 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.
Figure 1-13 Capacity Planning Analysis Screen - PRIVATE Catalog
/------------------------- 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 ******************************** | | | | | | | | | | | | | | | | | | | | | --------------------------------------------------------------------------------
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 about working with SHARED or PRIVATE catalogs, see the Creating a File Definition Inquiry section .
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 that is shown in the following figure.
Figure 1-14 Insert Capacity Planning Analysis Screen
/--------------------- 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. | | | | | | | | | | | | | | | ----------------------------------------------------------------------------------
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. If you want to change any of the information about this screen later, 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 detailed in Workload Characterization.
Choosing Option 2 displays the Workload Forecasting menu that is 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
MICS Capacity Planner
are displayed.Figure 1-15 Workload Forecasting Menu
/---------------------------- 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. | | | | | | | --------------------------------------------------------------------------------