3. CAPACITY PLANNING DATABASE › 3.3 Resource Element Files › 3.3.3 Resource Element File Case Studies › 3.3.3.3 JES Spool Activity › 3.3.3.3.2 Control Parameters
3.3.3.3.2 Control Parameters
Figures 3-57 through 3-68 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.: JES - JES Spool 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-57. Specifying Parameters for the Resource Element File
The specifications on the Resource Element File Definition
screen shown in Figure 3-57 do the following:
o Set the primary summarization to MONTHS
o Set the secondary summarization to ZONE
/-------------------------- Resource Element File ----------------------------\
|Option ===> 1 |
| |
|Composing CAP DB file def.: JES - JES Spool 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-58. Specifying Common Data Selection
Option 1, Insert Common Data Selection, is chosen on the
Resource Element File shown in Figure 3-58.
/--------------------------- Common Data Selection ---------------------------\
|Command ===> |
|Enter a ? in any data entry field for more information on valid values. |
|Composing CAP DB File def.: JES - JES Spool Example |
| |
| |
|SYSID ===> TSO1 TSO2 ____ ____ ____ ____ ____ ____ ____ ____ |
| ____ ____ ____ ____ ____ |
| |
|Zone ===> _ _ _ _ _ _ _ _ _ (1 - 9) |
| |
|Hour ===> __ - __ __ - __ __ - __ __ - __ __ - __ (0 - 23) |
| |
|Dayname ===> _________ _________ _________ _________ _________ |
| |
| |
| |
| |
| |
| |
| |
| |
|Specify common data selection SAS statements ===> Y (Y/N/R) |
\------------------------------------------------------------------------------/
Figure 3-59. Common Data Selection Screen
The Common Data Selection screen shown in Figure 3-59
specifies that observations with SYSIDs that are equal to
TSO1 or TSO2 are to be included in the resource element file.
SAS statements are specified to further control data
selection.
/-------------------------- SAS System Statements --------------------------\
|Command ===> Scroll ===> CSR |
| |
|Inquiry Step: File & Data Element Sel.: JES - JES SPOOL |
| |
|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 ROUTE = 000 OR ROUTE = 012 OR ROUTE = 034 OR |
|000002 ROUTE = 080 OR ROUTE = 091 OR ROUTE = 093 OR |
|000003 ROUTE = 096 ; |
|=NOTE= %MEND SELECT; <=== PLEASE DO NOT PLACE LINES AFTER THIS LINE. |
|****** **************************** BOTTOM OF DATA ***************************|
| |
\------------------------------------------------------------------------------/
Figure 3-60. Selecting Common Data
The SAS Statements screen in Figure 3-60 shows the route code
values that were selected to be included in the resource
element file.
/--------------------------- Resource Element File ---------------------------\
|Option ===> 2 |
| |
|Composing CAP DB file def.: JES - JES Spool 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-61. 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-61.
The CA MICS File and Data Element Selection screen shown in
Figures 3-62 and 3-63 specifies that the CA MICS SPL file in
database unit P is to be used. The data elements to be
included in the resource element file or to be used to derive
non-CA MICS data elements are listed. Note that user-defined
logic is to be supplied via one of the CA MICS file
processing exits.
/-------------------- 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.: JES - JES Spool Example |
|CA MICS file ===> SPL (fff) - BATCH USER SPOOL ACTIVITY FILE |
|Input Time-Span ===> MONTHS (DETAIL/DAYS/WEEKS/MONTHS) |
|Data base (s) ===> P |
|Include CAPAPUs ===> N (Y/N) -------Line Commands--------|
|Summarize file by ===> ROUTE___ | I Insert C Copy D Delete ||
|Specify file exits ===> Y (Y/N) | R Repeat E Calculations ||
| | S Depend Clauses & Label ||
| ----------------------------|
| Sum Data |
|Cmd Name Label (long name) D Type Type Order Len Output-Format |
| - -------- ----------------------------- - ---- ---- ----- --- ------------- |
| _ ROUTE Route Number |
| D RET N 050 5 _____________ |
| _ DATE Interval End Date |
| _ RET D 000 7 DATE7________ |
| _ MONTH Month of Year |
| _ RET N 000 2 _____________ |
| _ RMTLOCLR Local Print Lines |
| _ ACCM N 120 7 _____________ |
| _ RMT012LR Remote 012 Lines |
| _ ACCM N 120 7 _____________ |
| _ RMT034LR Remote 034 Lines |
| _ ACCM N 120 7 _____________ |
|******************************* BOTTOM OF DATA *******************************|
| |
\------------------------------------------------------------------------------/\
Figure 3-62. 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.: JES - JES Spool Example |
|CA MICS file ===> SPL (fff) - BATCH USER SPOOL ACTIVITY FILE |
|Input Time-Span ===> MONTHS (DETAIL/DAYS/WEEKS/MONTHS) |
|Data base (s) ===> P |
|Include CAPAPUs ===> N (Y/N) -------Line Commands--------|
|Summarize file by ===> ROUTE___ | I Insert C Copy D Delete ||
|Specify file exits ===> Y (Y/N) | R Repeat E Calculations ||
| | S Depend Clauses & Label ||
| ----------------------------|
| Sum Data |
|Cmd Name Label (long name) D Type Type Order Len Output-Format |
| - -------- ----------------------------- - ---- ---- ----- --- ------------- |
| _ RMT080LR Remote 080 Lines |
| _ ACCM N 120 7 _____________ |
| _ RMT091LR Remote 091 Lines |
| _ ACCM N 120 7 _____________ |
| _ RMT093LR Remote 093 Lines |
| _ ACCM N 120 7 _____________ |
| _ RMT096LR Remote 096 Lines |
| _ ACCM N 120 7 _____________ |
| _ SPLNLR Logical Writer |
| D ACCM N 050 13 _____________ |
| _ SYSID System Identifier |
| _ RET A 000 4 _____________ |
\------------------------------------------------------------------------------/
Figure 3-62. CA MICS File and Data Element Selection Screen - Screen 2
/-------------------- 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.: JES - JES Spool Example |
|CA MICS file ===> SPL (fff) - BATCH USER SPOOL ACTIVITY FILE |
|Input Time-Span ===> MONTHS (DETAIL/DAYS/WEEKS/MONTHS) |
|Data base (s) ===> P |
|Include CAPAPUs ===> N (Y/N) -------Line Commands--------|
|Summarize file by ===> ROUTE___ | I Insert C Copy D Delete ||
|Specify file exits ===> Y (Y/N) | R Repeat E Calculations ||
| | S Depend Clauses & Label ||
| ----------------------------|
| Sum Data |
|Cmd Name Label (long name) D Type Type Order Len Output-Format |
| - -------- ----------------------------- - ---- ---- ----- --- ------------- |
| _ YEAR Year of Century |
| _ RET N 000 2 _____________ |
| _ ZONE Time Zone |
| _ RET A 000 1 _____________ |
|******************************* BOTTOM OF DATA *******************************|
| |
\------------------------------------------------------------------------------/
Figure 3-63. CA MICS File and Data Element Selection Screen - Screen 3
/---------------------- CA MICS File Processing Exits Menu -------------------\
|Command ===> |
| |
|Inquiry Step: File & Data Element Sel.: SPL - BATCH USER SPOOL ACTIVITY FILE |
| |
| |
|Specify file unique data selection SAS stmts. ===> N (Y/N/R) |
| (file level SELECT exit) |
| |
|Specify new data element derivation SAS stmts. ===> Y (Y/N/R) |
| (file transpose and summary exit) |
| |
|Set expression statements for data elements. ===> N (Y/N) |
| (convert SAS stmts to expression stmts) |
| |
| |
| |
| |
| |
| |
| |
| |
| |
| |
\------------------------------------------------------------------------------/
Figure 3-64. CA MICS File Processing Exits Menu
The CA MICS File Processing Exits Menu shown in Figure 3-64
indicates that the data element derivation logic is to be
defined by the user.
/-------------------------- SAS System Statements ---------------------------\
|Command ===> Scroll ===> CSR |
| |
|Inquiry Step: File & Data Element Sel.: JES - JES SPOOL |
| |
|SAS Statements for the CAPSMRY Macro |
|------------------------------------------------------------------------------|
|****** ***************************** TOP OF DATA *****************************|
|==MSG> SPECIFY SAS STATEMENTS FOR TRANSPOSING THE FILE OR TO SET VARIABLES. |
|=NOTE= %MACRO CAPSMRY; <=== PLEASE DO NOT PLACE LINES BEFORE THIS LINE. |
|000001 IF ROUTE = 000 THEN RMTLOCLR + SPNLR ; |
|000002 IF ROUTE = 012 THEN RMT012LR + SPNLR ; |
|000003 IF ROUTE = 034 THEN RMT034LR + SPNLR ; |
|000004 IF ROUTE = 080 THEN RMT080LR + SPNLR ; |
|000005 IF ROUTE = 091 THEN RMT091LR + SPNLR ; |
|000006 IF ROUTE = 093 THEN RMT093LR + SPNLR ; |
|000007 IF ROUTE = 096 THEN RMT096LR + SPNLR ; |
|=NOTE= %MEND CAPSMRY; <=== PLEASE DO NOT PLACE LINES AFTER THIS LINE. |
|****** **************************** BOTTOM OF DATA ***************************|
| |
\------------------------------------------------------------------------------/
Figure 3-65. Selecting File-Unique Data
The SAS Statements screen in Figure 3-65 shows the SAS
statements that are used to subset the input data to ROUTEs
under consideration only, and to derive new data elements to
hold the values for the number of print lines for each of the
remote printers of interest.
/--------------------------- Resource Element File --------Inquiry Validated.-\
|Command ===> Scroll ===> CSR |
| |
|Composing CAP DB File def.: JES - JES Spool 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.: SPL - BATCH USER SPOOL ACTIVITY FILE |
|****************************** BOTTOM OF DATA ********************************|
| |
| |
| |
| |
| |
| |
| |
| |
\------------------------------------------------------------------------------/
Figure 3-66. Validating the Inquiry
After the resource element file definition parameters are
specified, the Resource Element File is used to validate the
inquiry. Figure 3-66 shows this screen after VALIDATE is
typed at the Command prompt.
/----------------------- Update Capacity Planning File -------- Confirm Save.-\
|Command ===> |
| |
|Modifying CAP DB File def.: JES - JES Spool 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-67. Saving the Inquiry
The Update Capacity Planning File screen shown in Figure 3-67
is used to save the inquiry so that it can be executed.
/----------------------- Update Capacity Planning File -------------------------\
|Command ===> |
| |
|Composing CAP DB File def.: JES - JES Spool 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-68. 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-68. The updated resource element file will
be printed after the update is complete.
Copyright © 2014 CA.
All rights reserved.
|
|