3. CAPACITY PLANNING DATABASE › 3.3 Resource Element Files › 3.3.3 Resource Element File Case Studies › 3.3.3.4 Tracking Applications › 3.3.3.4.2 Control Parameters
3.3.3.4.2 Control Parameters
Figures 3-70 through 3-78 show the control screens that we
used to create and execute this resource element file
example.
/---------------------- Resource Element File Definition ---------------------\
|Command ===> |
|Enter a ? in any data entry field for more information on valid values. |
| CAP DB File def.: PAY - Payroll Application Example |
| |
|Summarization Level |
| Primary ===> MONTHS (DAYS/WEEKS/MONTHS) |
| Secondary ===> ZONE (ZONE/HOUR/ENDTS/DAYNAME) |
| |
|Amount of data retained ===> 60 (1-9999 months) |
|Age of oldest forecast ===> 24 (1-9999 months) |
|History cycles ===> 3 (1-99 cycles) |
|Forecast cycles ===> 3 (1-99 cycles) |
| |
|Enable: |
| Notes report ===> N (YES/NO) |
| Contents reports ===> N (YES/NO) |
| |
|Specify extended options ===> N (Y/N) |
\------------------------------------------------------------------------------/
Figure 3-70. Resource Element File Definition Screen
The specifications on the Resource Element File Definition
screen shown in Figure 3-70 do the following:
o Set the timespan to MONTHS
o Set the summary level to ZONE
/--------------------------- Resource Element File ---------------------------\
|Option ===> 1 |
| |
|Composing CAP DB file def.: PAY - Payroll Application Example |
| |
| |
| 1 - Insert Common Data Selection |
| Specify data selection criteria to apply to ALL files. |
| 2 - Insert CA MICS File and Data Element Selection |
| Select a CA MICS file and data elements. |
| 3 - Insert Cross-File Data Element Definition |
| Specify cross-file data element derivations. |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
\------------------------------------------------------------------------------/
Figure 3-71. Selecting Common Data
Option 1, Insert Common Data Selection, is chosen on the
Resource Element File screen shown in Figure 3-71.
/--------------------------- Common Data Selection ---------------------------\
|Command ===> |
|Enter a ? in any data entry field for more information on valid values. |
|Composing CAP DB File def.: PAY - Payroll Application Example |
| |
| |
|SYSID ===> TSO1 TSO2 ____ ____ ____ ____ ____ ____ ____ ____ |
| ____ ____ ____ ____ ____ |
| |
|Zone ===> _ _ _ _ _ _ _ _ _ (1 - 9) |
| |
|Hour ===> __ - __ __ - __ __ - __ __ - __ __ - __ (0 - 23) |
| |
|Dayname ===> _________ _________ _________ _________ _________ |
| |
| |
| |
| |
| |
| |
| |
| |
|Specify common data selection SAS statements ===> Y (Y/N/R) |
\------------------------------------------------------------------------------/
Figure 3-72. Common Data Selection Screen
The Common Data Selection screen shown in Figure 3-72
specifies that observations with SYSIDs that are equal to
TSO1 or TSO2 are to be included in the resource element data
file. SAS statements are specified to further control data
selection.
/-------------------------- SAS System Statements ---------------------------\
|Command ===> Scroll ===> CSR |
| |
|Inquiry Step: File & Data Element Sel.: PAY - PAYROLL APPLICATION |
| |
|SAS Statements for the SELECT Macro |
|------------------------------------------------------------------------------|
|****** ***************************** TOP OF DATA *****************************|
|==MSG> SPECIFY SAS STATEMENTS TO SUBSET THE CAPACITY PLANNING DATA BASE FILE. |
|=NOTE= %MACRO SELECT; <=== PLEASE DO NOT PLACE LINES BEFORE THIS LINE. |
|000001 IF ACCTN01 = 'P39' AND ACCTN02 = '028' ; |
|=NOTE= %MEND SELECT; <=== PLEASE DO NOT PLACE LINES AFTER THIS LINE. |
|****** **************************** BOTTOM OF DATA ***************************|
| |
\------------------------------------------------------------------------------/
Figure 3-73. Common Data Selection Screen
The Common Data Selection screen shown in Figure 3-73 is
specified to further subset the input file by selecting
observations for a particular pair of account numbers only.
/--------------------------- Resource Element File ---------------------------\
|Option ===> 2 |
| |
|Composing CAP DB file def.: PAY - Payroll Application Example |
| |
| |
| 1 - Insert Common Data Selection |
| Specify data selection criteria to apply to ALL files. |
| 2 - Insert CA MICS File and Data Element Selection |
| Select a CA MICS file and data elements. |
| 3 - Insert Cross-File Data Element Definition |
| Specify cross-file data element derivations. |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
\------------------------------------------------------------------------------/
Figure 3-74. Selecting CA MICS Files and Data Elements
Option 2, Insert CA MICS File and Data Element Selection, is
chosen on the Resource Element File screen shown in Figure
3-74.
The CA MICS File and Data Element Selection screen shown in
Figure 3-75 specifies that the CA MICS JOB file in database
complex P is to be used. The data elements to be included in
the resource element file are listed.
/-------------------- CA MICS File and Data Element Selection ---------------\
|Command ===> Scroll ===> CSR |
|Enter a ? in any data entry field for more information on valid values. |
|Composing CAP DB File def.: PAY - Payroll Application Example |
|CA MICS file ===> JOB (fff) - BATCH USER JOB ACTIVITY FILE |
|Input Time-Span ===> MONTHS (DETAIL/DAYS/WEEKS/MONTHS) |
|Data base (s) ===> P |
|Include CAPAPUs ===> N (Y/N) -------Line Commands--------|
|Summarize file by ===> ________ | I Insert C Copy D Delete ||
|Specify file exits ===> N (Y/N) | R Repeat E Calculations ||
| | S Depend Clauses & Label ||
| ----------------------------|
| Sum Data |
|Cmd Name Label (long name) D Type Type Order Len Output-Format |
| - -------- ----------------------------- - ---- ---- ----- --- ------------- |
| _ DATE Interval End Date |
| _ RET D 000 7 DATE7________ |
| _ JOBCOUNT Job Executions |
| _ ACCM N 050 5 _____________ |
| _ JOBMXWSS Max Step Work Set |
| _ MAX N 050 5 _____________ |
| _ JOBNLR Total Log. Writer |
| _ ACCM N 050 13 _____________ |
| _ JOBSRBTM Job SRB CPU Time |
| _ ACCM T 050 10 TIME14.2_____ |
| _ JOBSTEPS Number of Steps |
| _ ACCM N 050 10 _____________ |
| _ JOBSYSAB Job System Abends |
| _ ACCM N 050 5 _____________ |
|******************************* BOTTOM OF DATA *******************************|
| |
\------------------------------------------------------------------------------/
Figure 3-75. CA MICS File and Data Element Selection Screen - Screen 1
/-------------------- CA MICS File and Data Element Selection ---------------\
|Command ===> Scroll ===> CSR |
|Enter a ? in any data entry field for more information on valid values. |
|Modifying CAP DB File def.: PAY - Payroll Application Example |
|CA MICS file ===> JOB (fff) - BATCH USER JOB ACTIVITY FILE |
|Input Time-Span ===> MONTHS (DETAIL/DAYS/WEEKS/MONTHS) |
|Data base (s) ===> P |
|Include CAPAPUs ===> N (Y/N) -------Line Commands--------|
|Summarize file by ===> ________ | I Insert C Copy D Delete ||
|Specify file exits ===> N (Y/N) | R Repeat E Calculations ||
| | S Depend Clauses & Label ||
| ----------------------------|
| Sum Data |
|Cmd Name Label (long name) D Type Type Order Len Output-Format |
| - -------- ----------------------------- - ---- ---- ----- --- ------------- |
| _ JOBTCBTM Job TCB CPU Time |
| _ ACCM T 050 10 TIME14.2_____ |
| _ JOBUSRAB Job User Abends |
| _ ACCM N 050 5 _____________ |
| _ MONTH Month of Year |
| _ RET N 000 2 _____________ |
| _ SYSID System Identifier |
| _ RET A 000 4 _____________ |
| _ YEAR Year of Century |
| _ RET N 000 2 _____________ |
| _ ZONE Time Zone |
| _ RET A 000 1 _____________ |
\------------------------------------------------------------------------------/
Figure 3-75. CA MICS File and Data Element Selection Screen - Screen 2
/--------------------------- Resource Element File --------Inquiry Validated.-\
|Command ===> Scroll ===> CSR |
| |
|Composing CAP DB File def.: PAY - Payroll Application Example |
| |
|Update the capacity planning data base file ===> Y (Y/N) |
| |
|Line Cmds: S Select I Insert D Delete R Repeat |
| |
|Cmd Data Base File Definition Step |
| - ------------------------------------------------------------------ |
| _ Resource Element File Definition |
| _ Common Data Selection |
| _ File & Data Element Sel.: JOB - BATCH USER JOB ACTIVITY FILE |
|****************************** BOTTOM OF DATA ********************************|
| |
| |
| |
| |
| |
| |
| |
| |
\------------------------------------------------------------------------------/
Figure 3-76. Validating the Inquiry
After the resource element file definition parameters are
specified, the Resource Element File screen is used to
validate the inquiry. Figure 3-76 shows this screen after
VALIDATE is typed at the Command prompt.
/----------------------- Update Capacity Planning File -------- Confirm Save.-\
|Command ===> |
| |
|Modifying CAP DB File def.: PAY - Payroll Application Example |
| |
| |
|This file definition has been changed and must be saved before updating the |
|file. |
| |
| |
|Do you wish to save the file definition and update the file? ===> YES (YES/NO) |
| |
| |
| |
| |
|Instructions: |
| |
| Press ENTER key to save the file definition and update the file. |
| |
| Reply NO and press enter key to cancel the file update request. |
| |
| |
| |
\------------------------------------------------------------------------------/
Figure 3-77. Saving the Inquiry
The Update Capacity Planning file screen shown in Figure 3-77
is used to save the inquiry so that it can be executed.
/----------------------- Update Capacity Planning File -------------------------\
|Command ===> |
| |
|Composing CAP DB File def.: PAY - Payroll Application Example |
| |
|Type of update ===> INITIALIZE (INITIALIZE/UPDATE) |
|Replace existing file? ===> N (Y/N) |
| |
|Input data source ===> ONLINE (ARCHIVE/ONLINE) |
|CA MICS file cycle(s) ===> 01 - 05 (0 - 99) |
|Archive generation number ===> ___ (0 to -99) |
| |
|Starting date of update ===> _______ (ddmonyy) |
|Number of months to select ===> 5___ (1 to 9999) |
| |
|Mode of execution ===> BATCH (BATCH/FOREGROUND) |
| |
|List updated file contents? ===> YES (YES/NO) |
| |
| |
|Press END to invoke MICF inquiry execution to update the resource element file.|
|Enter CANCEL to terminate the resource element file update. |
| |
\------------------------------------------------------------------------------/
Figure 3-78. Executing the Inquiry
Cycles 1 through 5 are specified as input to the database
loading process on the Update Capacity Planning File screen
shown in Figure 3-78. The updated resource element file
will be printed after the update is complete.
Copyright © 2014 CA.
All rights reserved.
|
|