Tailoring report tool ISPF skeletons

DFSMSrmm provides several ISPF skeletons that you can modify to suit your installation requirements. For example, you can use the DFSMSrmm-supplied skeletons EDGSGICE or EDGSGSYN to generate JCL to create reports using other report utilities. You can use the DFSMSrmm-supplied skeleton EDGSGEXT to create a job step to create the input for the reporting job step. The existing skeleton can create a DFSMSrmm extract file, extract SMF records, or create a DFSMSrmm ACTIVITY file. You need to tailor the skeleton to perform processing based on the JCL and control statements required for your selected data and reporting utility.

The DFSMShsm supplied skeletons ARCGFSRC and ARCGWFSC are used by the generator to convert FSR and WWFSR records to FSR2 and WFSR2 records respectively. For details about reporting with DFSMShsm and DCOLLECT data, see the DFSMShsm section ofz/OS DFSMSdfp Storage Administration.

Figure 1shows part of the EDGSGEXT skeleton that contains the SMF extract step. The ISPF variable &EDGGFILE contains the name of the input file for the reporting tool step that must be used as the name of the output file of the extract step.

Figure 1. Adding an extract step by tailoring the EDGSGEXT ISPF skeleton

    SYS1.DGTSLIB(EDGSGEXT) - 01.00                     Columns 00001 00072
 ===>                                                 Scroll ===>HALF
      :
      :
)CM *********************************************************
)SEL &EDGGMAC1 = EDGSMFAR ! &EDGGMAC1 = EDGSMFSR
//STEP01  EXEC PGM=IFASMFDP
//INDD1    DD DSN=&EDGGVAR1,
//            DISP=SHR
//OUTDD1   DD DSN=&EDGGFILE,
//            UNIT=SYSALLDA,
//            DISP=(NEW,PASS),SPACE=(TRK,(5,5),RLSE)
//SYSPRINT DD SYSOUT=*
//SYSIN    DD *
 INDD(INDD1,OPTIONS(DUMP))
 OUTDD(OUTDD1,TYPE(248:249))
)ENDSEL
)CM *********************************************************
     :
     :
)SEL &EDGGMAC1 = ANYTHING
)CM  ADD YOUR REPORT DATA CREATION FILE JCL HERE AND CUSTOMIZE THE
)CM  'ANYTHING' TO YOUR MAPPING MACRO NAME OR USE ANY OTHER AVAILABLE
)CM  ISPF VARIABLE TO SELECT THE JCL STEP
    ...
)ENDSEL
**************************** Bottom of Data ****************************

You could, for example, tailor the EDGSGICE skeleton to produce an XMIT job step in the JCL to send the completed report to the correct user on another system as shown in Figure 2.

Figure 2. Adding an XMIT statement to Report JCL

EDGPG022            DFSMSrmm Report Generation - C07005
      :
      :
 Additional skeleton variables, for example if an extract step is included:
 Skeleton Variable_1 . .
 Skeleton Variable_2 . .
 Skeleton Variable_3 . . MAZVM02.WSMITH
 The skeleton selection depends on the reporting macro . . . : EDGRXEXT
                                       and macro keyword . . : TYPE=V
 Enter END command to start the report generation or CANCEL

The skeleton contains an XMIT step as shown in Figure 3.

Figure 3. Setting up notification to a user ID

 :
//WRITE1   EXEC PGM=ICETOOL,REGION=0M
  :
//OUTDD    DD UNIT=SYSALLDA,SPACE=(TRK,(5,25)),DISP=(,PASS)
  :
//**
//TSOBAT   EXEC PGM=IKJEFT01                    XMIT STEP
//SYSTSPRT DD SYSOUT=*
//REPORT   DD DSN=*.WRITE1.OUTDD,DISP=SHR
//SYSTSIN  DD *
 XMIT &EDGGVAR3 FILE(REPORT)
**************************** Bottom of Data ***************************

The DFSMSrmm-supplied skeletons include the DATECONV step where variable dates (&TODAY ...) are converted to real dates to be used in date comparisons. Here is how the dates are converted.

A selection criteria contains &TODAY - 2 Months. DFSMSrmm builds an INCLUDE statement like this:
```
   .. INCLUDE COND=((6,10,CH,LT,'&TODAY-002M')
```
The date format ISO was specified in the DFSMSrmm Report Generation panel.
The report job was run on July 14th, 2013.
The DATECONV step reads all INCLUDE statements and replaces the variable dates:
```
.. INCLUDE COND=((6,10,CH,LT,'2013/05/14')
```
The modified INCLUDE statements are input for the reporting tool step (for example for ICETOOL).

If you use the extract data set as input, you must use the DFSMSrmm date formats AMERICAN, EUROPEAN, ISO, or JULIAN. For other types of input, you can use DFSMSrmm date formats or a free form of the date format that you specify in panel EDGPG022. You must ensure that all date fields in the input data set that are selected with a variable date compare value (&TODAY), are in the same date format.

The DATECONV step issues messages to show the date conversion that took place during processing.

EDGRGDAT. RUNDATE: 26 Mar 2013 TIME: 03:23:45 STARTED
EDGRGDAT. DATE CALCULATIONS WILL BE DONE WITH THIS DATE FORMAT:
EDGRGDAT. DATE PATTERN:YYYY/MM/DD
EDGRGDAT. LINE   4:                ((77,10,CH,GE,C'&TODAY-008M'),
EDGRGDAT.    CHNGD:                ((77,10,CH,GE,C'2012/07/26'),
EDGRGDAT. LINE   6:                (77,10,CH,LE,C'&TODAY-002D')))
EDGRGDAT.    CHNGD:                (77,10,CH,LE,C'2013/03/24')))
EDGRGDAT. 12 CONTROL STATEMENTS CHECKED.  2 WITH &TODAY FOUND.  2 RECORDS MODIFIED.