Appendix B. QUICK START TUTORIAL › B.1 Quick Start Tutorial for CPU Planning › B.1.2 Generate the CPU Forecast
B.1.2 Generate the CPU Forecast
You can use the following procedure to create a forecast
using the CA MICS Capacity Planner database as input.
Assumptions:
o The input data are stored within the shareprefix.CAPACITY
database.
o Linear Univariate Modeling will be used in this exercise.
o The forecast may fail if there are not enough historical
data.
1. Go to Capacity Planning Analysis or Option 2 on the
Capacity Planner main screen to create a forecast.
2. Insert a new inquiry. Code an Inquiry Name and Title.
Write the Inquiry Name here: ____________.
Choose Workload Forecasting (option 2) and press ENTER.
3. Choose 4 for Univariate Model Forecasting and press ENTER.
4. Enter the parameters necessary for Univariate modeling.
See Figure B-3.
Use the same database that you used in the Section C.1.1.
(Build Capacity Database). You recorded information in
Step 2 in the Build Capacity Database section.
/------------------------ Univariate Model Forecasting -----------------------\
|Command ===> |
| |
|Composing CA MICS Inquiry: QC1F1 - Quick Start Forecast for CPU |
| |
|Report title ===> Quick Start Forecast for CPU |
| |
|Selection criteria: |
| Input file ===> QC1 - Quick Start Exercise |
| Start date ===> _________ (ddmonyyyy) |
| SYSID ===> XAD1 |
| Zone ===> 1 |
| No. months ===> 8 (1-9999) |
| Save forecast ===> AGE (YES/NO/AGE) |
| Specify CAPAPU Values ===> N (Y/N) |
|Forecast data element ===> CPUPCBSY |
|Forecast length (months) ===> 18 (1-9999) |
|Confidence limits (percent) ===> 90 (70/90/95) |
| |
|Time element terms: Linear ===> YES (YES/NO) |
| Quadratic ===> NO (YES/NO) |
| Cubic ===> NO (YES/NO) |
|Specify extended options ===> N (Y/N) |
\------------------------------------------------------------------------------/
Figure B-3. Univariate Model Forecasting Control Parameters
If you code Y after "Specify extended options", then an
"Extended Options Menu" will appear. The last line of
this menu has the option "Transform historical
observations". If you code Y for this, another panel will
appear. This panel provides the following options for the
user to enter SAS code that will modify the historical
data:
- Statements to transform historical data
- Statements to reverse history transformations
fit changes in your hardware environment as in these
examples:
When the first option is chosen, the original data
could be transformed to show a 30% faster CPU
processor on June 9.
IF DATE GE '09JUN02'D
THEN _TRAN_ = 1.3 * &VNAME;
ELSE _TRAN_V_ = &VNAME;
Note that the symbolic variable names used here are
&VNAME = the original dependent variable
_TRAN_V_ = the transformed dependent variable
When the second option is chosen, the transformation
from the first option could be reversed by these
statements:
IF DATE GE '09JUN02'D THEN DO:
_ESTS = _ESTS / 1.3;
_LCL = _LCL / 1.3;
_UCL = _UCL / 1.3;
END;
You can END out of the "Transform Historical Observations"
screen to go back to the "Extended Options Menu".
If there are specific data points that you would like to
delete from the historical data, you can choose the
"Delete historical data observations" screen. This screen
allows you to enter the dates for those observations that
need to be deleted. Press END twice to go back to the
"Univariate Model Forecasting" screen.
5. Press END again to bring up the "Inquiry Processing"
screen. Choose EXECUTE and press ENTER.
6. Go to MWF 2;4;2 to copy this PRIVATE query to SHARED MICF
query catalog.
NOTE: You may need to ask the CA MICS Administrator to
copy this query to the CA MICS complex SHARED MICF
catalog. Only inquires in the SHARED MICF catalog can
update data within sharedprefix.CAPACITY.
7. Go to MWF 4;3;2 and execute this query (as recorded in
Step 2 of this section). Ensure that the query you are
running is from the SHARED MICF catalog. On the
execution, specify update SHARED database forecast:
/------------------------- Execution-Time Parameters -------------------------\
|Command ===> Scroll ===> CSR |
|Press END to execute the inquiry. Enter CANCEL to cancel inquiry execution. |
|Executing CA MICS Inquiry: QC1F1 - Quick Start Forecast for CPU |
| |
|-------------------------------------------------------------------------------|
| Update forecast file (YES/NO/AGE)? Save forecast to Private or Shared DB. |
|AGE - SHARED ____________________________ |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
\------------------------------------------------------------------------------/
Figure B-4. Execution-Time Parameters Screen
The shareprefix.CAPACITY should now contain a FORECAST and
HISTORY.
Copyright © 2014 CA.
All rights reserved.
|
|