Running a report generator report

Before you begin: Ask your system programmer or storage administrator for the name of an input data set for the report generator. You need this input data set to run your report. If you are running a DFSMSrmm-supplied report, you need an input data set created during the latest inventory management run. The input data set can be a DFSMSrmm extract data set, an SMF file, or an ACTIVITY report. You can use non-DFSMSrmm input data sets when there is a mapping of the records in the input data set.

You can run a report that is stored in the product library by using this procedure.

Select the REPORT option on the DFSMSrmm User Menu panel as shown in Figure 1. Press the ENTER key. (Another way to select the REPORT option is for a storage administrator to select the 'G' 'Report Generation' option from the ISMF primary selection panel. )

Figure 1. Running a report using the DFSMSrmm User Menu panel

  Panel  Help
 ------------------------------------------------------------------------------
 EDGP@USR                   DFSMSrmm User Menu - z/OS V2R1
 Option ===>R

 0  OPTIONS    - Specify dialog options and defaults
 1  VOLUME     - Display list of volumes
 2  DATA SET   - Display list of data sets
 3  PRODUCTS   - Display list of products
 4  OWNER      - Display or change owner information
 5  REQUEST    - Request a new volume
 6  RELEASE    - Release an owned volume
 R  REPORT     - Work with reports

 Enter selected option or END command. For more info., enter HELP or PF1.

Type S next to the product library on the DFSMSrmm Report Definition Search panel shown in Figure 2. Press the ENTER key.

Figure 2. Select the input data set in the product library using the DFSMSrmm Report Definition search panel

  Panel  Help
 ------------------------------------------------------------------------------
 EDGPG010              DFSMSrmm Report Definition Search
 Command ===>

 Report name . .             May be generic.  Leave blank for all reports.

 User id . . . .             Leave blank for all user ids.

 Select one or more library. Default is all defined libraries.
 Libraries (enter S):        Currently defined Libraries:                       
   S  User                   USER.REPORT.LIB
   S  Installation           LOCAL.REPORT.LIB
   S  Product                SYS1.SAMPLIB
                                                                              
                                                                              
                                                                              
 The following line commands will be available when the list is displayed:     
   A - Add a new report definition      D - Delete a report definition             
   G - Generate and save the JCL        H - View the report help information 
   J - Edit and submit the JCL          L - List macro assembly results  
   M – Browse macros for the report     N - Copy a report definition     
   S – Display/change the report        T - Select a reporting tool

Select a report by typing G in the S column on the DFSMSrmm Report Definitions panel as shown in Figure 3. Press the ENTER key.

Figure 3. Selecting a report using the DFSMSrmm Report Definitions panel

 Panel  Help
-------------------------------------------------------------------------------
EDGPG020                 DFSMSrmm Report Definitions           Row 1 to 2 of 2
Command ===>                                                 Scroll ===>PAGE

The following line commands are valid: A,D,G,H,J,L,M,N,S, and T

S Name     Report title                   Report type                  User id
- -------- ------------------------------ ---------------------------- -------
  EDGGR01  Scratch tapes by volume serial Extended Extract Records     D094746
G SCRVOL   Scratch Volume List            Extract Records for Volumes  D094746
******************************* Bottom of data ********************************

Note: If JCL help information exists for this report, then this information is displayed in a pop-up panel when panel EDGPG022 appears.

Specify these parameters in panel EDGPG022 as shown in Figure 4.
- The input data set name is mandatory. Enter the name of the input data set for the reporting step.
- The date format is optional. Possible date format values are:
  - AMERICAN - dates in format MM/DD/YYYY
  - EUROPEAN - dates in format DD/MM/YYYY
  - ISO - dates in format YYYY/MM/DD
  - JULIAN - dates in format YYYY/DDD
  - free form - The free form has a maximum length of 20 bytes and contains DD and MM (alternatively DDD), and YY or YYYY or CYY. The C (century) is set to 1 for years after 2000. These values can contain separator characters.
  for dates in the year 2000 and or in the 21st century or higher, you can only use the yyyy/ddd format. If you use the yyddd format, DFSMSrmm defaults to the 20th century. DFSMSrmm uses the date format to determine a real date based on the compare value &TODAY and the actual run date.
- Specify Y if you want to create report data rather than use an existing input data set. This adds an extra step in the generated JCL that creates an extract data set. The extract step includes relevant parameters like date format and input data set name. You can use the existing date format and input data set name. You can also change them by entering information in theSkeleton Variable_1,Skeleton Variable_2, andSkeleton Variable_3fields.
  If you are using the &TODAY variable for dates, the date format you specify forSkeleton Variable_1must match the date format specified in panel EDGPG022. If the date formats are not the same, report results can be unpredictable. Julian or ISO format of date must be used for 'greater than' and 'less than' comparison of dates.
  Figure 4. Specifying the report generator parameters
```
EDGPG022            DFSMSrmm Report Generation - SCRVOL
 Command ===>

 Enter or change the skeleton variables for the generated JCL:

 Input data set  . . . . 'RMM.EXTRACT'

 Date format . . . . . . ISO
     (American, European, Iso, Julian, or free form)
     Required if you use variable dates (&TODAY) in your selection criteria.

 Create report data  . . Y  (Y/N)
     Choose Y if you want an extract step included into your generated JCL.

 Additional skeleton variables, for example if an extract step is included:
 Skeleton Variable_1 . . DATEFORM(I)
 Skeleton Variable_2 . . 'D016216.RMMHSKP.MESSAGE'
 Skeleton Variable_3 . .
     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 extract step for inventory management includes the DATEFORM parameter and a name for the DFSMSrmm message data set, which then is pre-allocated by the system, unless it already exists.
Press the END key to create the report.

Type J in the S column on the DFSMSrmm Report Definitions panel as shown in Figure 5. Press the ENTER key.

Figure 5. Running your report using the DFSMSrmm Report Definitions panel

Panel  Help
-------------------------------------------------------------------------------
EDGPG020                 DFSMSrmm Report Definitions           Row 1 to 2 of 2
Command ===>                                                 Scroll ===>PAGE

The following line commands are valid: A,D,G,H,J,L,M,N,S, and T

S Name     Report title                   Report type                  User id
- -------- ------------------------------ ---------------------------- -------
  EDGGR01  Scratch tapes by volume serial Extended Extract Records     D094746
J SCRVOL   Scratch Volume List            Extract Records for Volumes  D094746
******************************* Bottom of data ********************************

Change the DFSMSrmm-generated JCL as required and enter the SAVE command to save it in your JCL library.
Use the SUBMIT command to submit the job for batch processing.