Running new reports with report generator

DFSMShsm reports can be run with the DFSMSrmm Report Generator. The reports are based on FSR and WWFSR (SMF) data and DFSMShsm control data set data obtained by DCOLLECT.

For HSM FSR Records
  • ARCGAB01 ABARS ABACKUP Statistics
  • ARCGAR01 ABARS ARECOVER Statistics
  • ARCGS001 Statistics for DFSMShsm
  • ARCGS002 Statistics for Backup
  • ARCGS003 Statistics for Migration
  • ARCGS004 Statistics for Recall
  • ARCGS005 Statistics for Recovery
  • ARCGS006 Statistics for Volume Dump
  • ARCGS007 Statistics for Restore from Dump Copy
  • ARCGS008 Statistics for FRBACKUP
  • ARCGS009 Statistics for FRRECOVER
  • ARCGS010 DFSMShsm Thrashing Report
  • ARCGS011 Statistics for Class Transition
For DCOLLECT Records
  • ARCGDB01 DCOLLECT BACKUP DATA
  • ARCGDD01 DCOLLECT DASD CAPACITY PLANNING
  • ARCGDM01 DCOLLECT MIGRATION DATA
  • ARCGDT01 DCOLLECT TAPE CAPACITY PLANNING
The reporting records are:
ARCFSR2 (SYS1.MACLIB)
Reformatted from ARCFSR for reporting records with DFSMSrmm Report Generator. Maps FSR DS records for DFSMShsm in SMF form. Skeleton is ARCGFSRC.
ARCWFSR2 (SYS1.MACLIB)
Reformatted from ARCWWFSR for reporting records with DFSMSrmm Report Generator. Maps WWFSR for DFSMShsm in SMF form. Skeleton is ARCGWFSC.
ARCGFSRC/ARCGWFSC
Supplied skeletons used by the generator to convert FSR and WWFSR records to FSR2 and WWFSR2 records respectively. Shipped in SYS1.DGTSLIB.
Note: Report generator cannot process DFSMShsm's ARCFSR and ARCWWFSR records. ARCFSR and ARCWWFSR records are converted to ARCFSR2 and ARCWWFSR2, respectively, using ARCGFSRC and ARCGWFSC while running DFSMSrmm report generator. The panels below show how this is done.
ARCUTILP (SYS1.MACLIB)
It is much easier to create and manage reports, within the DFSMSrmm Report Generator, when the TYPE keyword is used to specify a single record type such as TYPE=M. Otherwise, all records are mapped and it can be confusing as to which fields below to which type of record. ARCUTILP provides keywords to map each structure. TYPE=ALL|M|B|C|T is as follows:
  • ALL = For all structures
  • M = Migrate
  • B = Backup
  • C = DASD Capacity Planning
  • T = Tape Capacity Planning
Note: No conversion is needed for ARCUTILP records as each type is uniquely written.

Prior to creating DFSMShsm reports using the DFSMSrmm Report Generator, DFSMShsm FSR and WWFSR records need to be collected. They are written to SMF data sets by DFSMShsm. Following is a JCL sample which collects this data from SMF. In this case SYS1.MANX and SYS1.MANY are the output ds from SMF, but this can vary depending upon setup.

The DFSMSrmm Report Generator includes sample report types for DFSMShsm FSR and DCOLLECT reporting. When DFSMSrmm Report Generator searches for sample report definitions in the installation (SAMPLIB) library it looks for DFMSMhsm sample members with the prefixes ARCG and EDGG.

This sample JCL describes collecting SMF records containing FSR and WWFSR Records for use in running DFSMSrmm Report Generator.

For more information about EFASMFDP and IFASMFDL see z/OS MVS System Management Facilities (SMF).

SMF dump sample JCL:
//SMFDUMP JOB ,
//* USE D SMF TO SEE DS STATUS
//* USE D SMF,O TO SEE SMF SETTINGS
//* USE SWITCH SMF TO SWAP THE ACTIVE AND INACTIVE DS
//*  NOTE OPTIONS = DUMP | CLEAR | ALL
//*       ONLY INACTIVE DS CAN BE CLEARED
//*       DEFAULT ALL = DUMP AND CLEAR
//DUMPSMF EXEC PGM=IFASMFDP,REGION=512K
//INDD0    DD  DSN=SYS1.MANX,DISP=SHR
//INDD1    DD  DSN=SYS1.MANY,DISP=SHR
//DUMPOUT  DD DSN=DFHSM.EXTRACT,UNIT=SYSALLDA,
//            DISP=(NEW,CATLG),SPACE=(CYL,(50,5),RLSE)
//SYSPRINT DD  SYSOUT=*
//SYSIN    DD  *
  INDD(INDD0,OPTIONS(DUMP))
  INDD(INDD1,OPTIONS(DUMP))
  OUTDD(DUMPOUT,TYPE(xxx))
/* 

Where xxx is the DFSMShsm SMF type you used. Refer to the startup procedure for DFSMShsm or issue QUERY SETSYS.

For more information about IFASMFDL and IFASMFDP see Dumping SMF log streams - IFASMFDL and Dumping SMF log streams - IFASMFDP in Using the SMF Dump Programs in z/OS MVS System Management Facilities (SMF).

This is sample JCL for collecting DCOLLECT records for possible use when running DFSMSrmm Report Generator.

The DCOLLECT job step can be generated within the DFSMShsm Report Generator by selecting Create report data...Y (Y/N) in the JCL generation panel (EDGPG022).

DCOLLECT sample JCL:
//DCOLLECT JOB ,
//STEP1 EXEC PGM=IDCAMS
//OUTDS    DD DSN=DFHSM.DCOLLECT.DATA,DISP=(NEW,CATLG),
//            UNIT=SYSALLDA,
//            DCB=(LRECL=644,BLKSIZE=0,RECFM=VB),SPACE=(CYL,(50,2)),
//            AVGREC=K
//SYSPRINT DD SYSOUT=A
//MCDS DD DSN=DFHSM.MCDS,DISP=SHR
//BCDS DD DSN=DFHSM.BCDS,DISP=SHR
//SYSIN DD *
     DCOLLECT -
          OUTFILE(OUTDS) -
          MIGRATEDATA -
          BACKUPDATA -
          CAPD
/*  

To start the DFSMSrmm report generator use option, G - Report Generation, on the ISMF Storage Administrator Primary Panel.

Set up need only be done once for a given user.

Select 0-Options. This only needs to be done once.

Panel  Help

                           DFSMSrmm Report Generator
 Option ===>

 0  OPTIONS         - Specify dialog options and defaults
 1  REPORT          - Work with reports
 2  REPORT TYPE     - Work with report types
 3  REPORTING TOOL  - Work with reporting tools
 X  EXIT            - Exit DFSMSrmm dialog
 Enter selected option or END command. For more info., enter HELP or PF1.
The options menu has three selections:
  • USER - Sets up basics and must be done by all users at least one time.
  • SORT - Specifies sort information for DFSMSrmm report users.
  • REPORT - Specifies Report options.

See Figure 8. Selecting the Options Option on the DFSMSrmm Dialog Options Menu Panel in Chapter 2, Using the DFSMSrmm Report Generator in z/OS DFSMSrmm Reporting for specifying libraries for the report generator.

At a minimum the JCL job card should be added. This will be used by all jobs submitted by Report Generator. If the job card is not supplied, the JCL generation uses the ISPF job card if it exists. If not, it generates a default job card.

Panel  Help

                         DFSMSrmm Dialog User Options
Command ===>

Date format . . . . . JULIAN           ( American, European, Iso or Julian )
Time zone . . . . . .       LOCAL      ( zone  offsetHH:MM:SS )

Confirm deletes . . . YES              ( Yes or No )

Processing option . . F                 F - Foreground, B - Background

Eject option  . . . . C                 C - Convenience, B - Bulk

Variable reuse  . . . Y                 Y - Yes, N - No

Job statement information:-

 ===> //HSMREPT  JOB ,CLASS=A,MSGCLASS=H.MSGLEVEL(1,1)
 ===> //*
 ===> //*
 ===> //*

      Enter END command to save changes, or CANCEL to end without saving.

Add the name of the target data sets for this user.

Panel  Help

                           DFSMSrmm Report Options
Command ===>

Report definition libraries:
  User . . . . . . . . . . . 'USER001.REPORT.LIB'
  Installation . . . . . . . 'TEAM001.REPORT.LIB'
  Product  . . . . . . . . . 'SYS1.SAMPLIB'

User report JCL library  . . 'USER001.REPORT.JCL'

Before running reports, select Reporting Tool using Option 3.

Panel  Help

                           DFSMSrmm Report Generator
 Option ===>

 0  OPTIONS         - Specify dialog options and defaults
 1  REPORT          - Work with reports
 2  REPORT TYPE     - Work with report types
 3  REPORTING TOOL  - Work with reporting tools
 X  EXIT            - Exit DFSMSrmm dialog
 Enter selected option or END command. For more info., enter HELP or PF1.

Notice the number of columns between each heading is set on the Reporting Tool Panel.

Report Types are provided by DFSMShsm as the outline for creating reports.
Table 1. Report Types Supplied by DFSMShsm
Name Description
ARCGWFSR DFSMShsm ABARS Report
ARCGDBCK DFSMShsm DCOLLECT BACKUP
ARCGDDSD DFSMShsm DCOLLECT DASD CAP
ARCGDMIG DFSMShsm DCOLLECT MIGRATION
ARCGDTAP DFSMShsm DCOLLECT TAPE CAP
ARCGFSR2 DFSMShsm FSR-SMF Records

Report Type has predefined types but the user may modify and add their own, however, it is not necessary since sample reports are also provided.

Panel  Help

                           DFSMSrmm Report Generator
 Option ===>

 0  OPTIONS         - Specify dialog options and defaults
 1  REPORT          - Work with reports
 2  REPORT TYPE     - Work with report types 
 3  REPORTING TOOL  - Work with reporting tools
 X  EXIT            - Exit DFSMSrmm dialog
 Enter selected option or END command. For more info., enter HELP or PF1.

Report Types is sufficient for all reports but users may modify or add their own. DFSMShsm has already supplied types for all currently provided records.

Panel  Help
                             DFSMSrmm Report Types             Row 2 to 7 of 32
 Command ===>                                                  Scroll ===> CSR

 The following line commands are valid: A,C,D,L,M,R, and S

 S Name     Description
 - -------- -------------------------------------------------------------------
   ARCGWFSR DFSMShsm ABARS Report
     Macro library . . :  'SYS1.MACLIB'
     Applicable macros :  ARCWFSR2
     Input data set. . :  'DFHSM.EXTRACT.ABARS.REFORMAT'
   ARCGDBCK DFSMShsm DCOLLECT BACKUP
     Macro library . . :  'SYS1.MACLIB'
     Applicable macros :  ARCUTILP
      Input data set. . :  'DFHSM.DCOLLECT.DATA'
   ARCGDDSD DFSMShsm DCOLLECT DASD CAP
     Macro library . . :  'SYS1.MACLIB'
     Applicable macros :  ARCUTILP
      Input data set. . :  'DFHSM.DCOLLECT.DATA'
   ARCGDMIG DFSMShsm DCOLLECT MIGRATION
     Macro library . . :  'SYS1.MACLIB'
     Applicable macros :  ARCUTILP
      Input data set. . :  'DFHSM.DCOLLECT.DATA'
   ARCGDTAP DFSMShsm DCOLLECT TAPE CAP
     Macro library . . :  'SYS1.MACLIB'
     Applicable macros :  ARCUTILP
      Input data set. . :  'DFHSM.DCOLLECT.DATA'
   ARCGFSR2 DFSMShsm FSR-SMF Records
     Macro library . . :  'SYS1.MACLIB'
     Applicable macros :  ARCFSR2
     Input data set. . :  'DFHSM.EXTRACT.REFORMAT'

Line commands M and L allow viewing the source macros and the results of the compiles. There are other commands that may be seen in the Help screen. These allow the user to modify and create new report types.

Panel  Help

                           DFSMSrmm Report Generator
 Option ===>

 0  OPTIONS         - Specify dialog options and defaults
 1  REPORT          - Work with reports  
 2  REPORT TYPE     - Work with report types
 3  REPORTING TOOL  - Work with reporting tools
 X  EXIT            - Exit DFSMSrmm dialog
 Enter selected option or END command. For more info., enter HELP or PF1.

Sample reports definitions supplied by DFSMShsm include two WWFSR reports, four DCOLLECT reports, and nine FSR reports. These reports are provided to be used as is or can be customized to create new reports.

Panel  Help

                         DFSMSrmm Report Definitions         Row 1 to 31 of 40
Command ===>                                                  Scroll ===> CSR

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

S Name     Report title                   Report type                  User id
- -------- ------------------------------ ---------------------------- -------
  ARCGAB01 ABARS ABACKUP Statistics       DFSMShsm ABARS Report        HSM
  ARCGAR01 ABARS ARECOVER Statistics      DFSMShsm ABARS Report        HSM
  ARCGDB01 DCOLLECT BACKUP DATA           DFSMShsm DCOLLECT BACKUP     HSM
  ARCGDD01 DCOLLECT DASD CAPACITY PLANNIN DFSMShsm DCOLLECT DASD CAP   HSM
  ARCGDM01 DCOLLECT MIGRATION DATA        DFSMShsm DCOLLECT MIGRATION  HSM
  ARCGDT01 DCOLLECT TAPE CAPACITY PLANNIN DFSMShsm DCOLLECT TAPE CAP   HSM
  ARCGS001 Statistics for DFSMShsm        DFSMShsm FSR-SMF Records     HSM
  ARCGS002 Statistics for Backup          DFSMShsm FSR-SMF Records     HSM
  ARCGS003 Statistics for Migration       DFSMShsm FSR-SMF Records     HSM
  ARCGS004 Statistics for Recall          DFSMShsm FSR-SMF Records     HSM
  ARCGS005 Statistics for Recovery        DFSMShsm FSR-SMF Records     HSM
  ARCGS006 Statistics for Volume Dump     DFSMShsm FSR-SMF Records     HSM
  ARCGS007 Statistics for Restore from Du DFSMShsm FSR-SMF Records     HSM
  ARCGS008 Statistics for FRBACKUP        DFSMShsm FSR-SMF Records     HSM
  ARCGS009 Statistics for FRRecover       DFSMShsm FSR-SMF Records     HSM
  ARCGS010 DFSMShsm Thrashing Report      DFSMShsm FSR-SMF Records     HSM
  ARCGS011 Statistics for Class Transitio DFSMShsm FSR-SMF Records     HSM 

The DFSMSrmm report generator selection option is where sample reports may be viewed, modified, and created.

The DFSMSrmm Report Definition Panel shows the select columns for general DFSMShsm reports. It shows the selected fields (CO) having a grouping (G), search criteria (S), and the sorted columns (SO). These fields may be changed to create custom reports.

Panel  Help

                     DFSMSrmm Report Definition - ARCGS001    Row 1 to 26 of 80
 Command ===>                                                  Scroll ===> CSR

 Report title . . . Statistics for DFSMShsm
 Report footer  . .
 Reporting tool . : ICETOOL                                  Report width:  209

 Use END to save changes or CANCEL
 Select a field name with S to specify a field selection criterion

 S CO SO  Field name           Column header text                   CW  Len Typ
 - -- --- -------------------- ------------------------------------ --- --- ---
    G  1A FSR2HOST             HOSTID                                 6   2  C
    1  2A FSR2TYPE             FUNC (hex)                            10   1  B
 *  2  3A FSR2DATR             DATE                                   8   8  C
    3  4A FSR2DSN              DSN OR CP NAME                        44  44  C
    4     FSR2FVOL             SOURCE                                 6   6  C
    5     FSR2TVOL             TARGET                                 6   6  C
    6     FSR2NENT1            # TAPE                                 6   2  N
    7     FSR2NENT2            # RCY OUT                              9   2  N
    8     FSR2BYTR             KB RD                                  5   4  N
    9     FSR2BYTW             KB WR                                  5   4  N
   10     FSR2JBN              JOB NAME                               8   8  C
   11     FSR2UID              USERID                                 8   8  C
   12     FSR2MCNAM            MC NAME                                8   8  C
   13     FSR2SCNAM            SC NAME                                8   8  C
   14     FSR2RC               RC (hex)                               8   4  B
 *        FSR2RTY              SMF RECORD TYPE                       15   1  B

The search criteria must be met in each record selected for inclusion in the report.

Panel  Help

                      DFSMSrmm Report Criteria - ARCGS001       Row 1 to 2 of 2
 Command ===>                                                  Scroll ===> CSR

 Report title : Statistics for DFSMShsm


 Use END to save changes or CANCEL
 The following line commands are valid: B,D,N,P,R,T, and I (for details)
 Comparison operators: EQ =, NE <>, GT >, GE >=, LT <, LE <=, IN, BW, SE, SN
 Conjunction: AND, OR, AND(, )AND

 S Field name           Op Compare value(s)                        Conj Len Typ
 - -------------------- -- --------------------------------------- ---- --- ---
   FSR2DATR             BW &TODAY; - 7 Days,&TODAY;                         8  C
   FSR2RTY              EQ X'FF'                                          1  B

This panel defines the search criteria which must be met in each record selected for inclusion in the report.

Panel  Help

                         DFSMSrmm Report Definitions         Row 1 to 3
Command ===>                                                  Scroll ==

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

S Name     Report title                   Report type
- -------- ------------------------------ ----------------------------
  ARCGAB01 ABARS ABACKUP Statistics       DFSMShsm ABARS Report
  ARCGAR01 ABARS ARECOVER Statistics      DFSMShsm ABARS Report
  ARCGDB01 DCOLLECT BACKUP DATA           DFSMShsm DCOLLECT BACKUP
  ARCGDD01 DCOLLECT DASD CAPACITY PLANNIN DFSMShsm DCOLLECT DASD CAP
  ARCGDM01 DCOLLECT MIGRATION DATA        DFSMShsm DCOLLECT MIGRATION
  ARCGDT01 DCOLLECT TAPE CAPACITY PLANNIN DFSMShsm DCOLLECT TAPE CAP
G ARCGS001 Statistics for DFSMShsm        DFSMShsm FSR-SMF Records
  ARCGS002 Statistics for Backup          DFSMShsm FSR-SMF Records
  ARCGS003 Statistics for Migration       DFSMShsm FSR-SMF Records
  ARCGS004 Statistics for Recall          DFSMShsm FSR-SMF Records

After selecting generate report the following panel variables should be entered:

input data set
The set of records for the report that must be made up of ARCFSR2, ARCWFSR2, or ARCUTILP (DCOLLECT). These records are previously converted except ARCUTILP records which do not need to be converted.
date format
YYYYDDD is specific to DFSMShsm FSR records.
create report data
When Y tells Report Generator that Skeleton_Variable_2 has source data ARCFSR or ARCWWFSR that must be converted to ARCFSR2 or ARCWFSR2. If this is the case, the Skeleton_Variable_1 must provide the FSR record type as defined in DFSMShsm's command SETSYS SMF(xx). This step will also create the temporary data set named in input data set. This may be changed to a non-temporary data set by modifying the generated JCL. Using a non-temporary data set allows preservation of the input data set for other reports.
Panel  Help

                    DFSMSrmm Report Generation - ARCGS001
Command ===>

Enter or change the skeleton variables for the generated JCL:

Input data set  . . . . 'DFHSM.EXTRACT.REFORMAT'

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

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

Additional skeleton variables, if an extract step is included:
Skeleton Variable_1 . . X'FF'
Skeleton Variable_2 . . DFHSM.EXTRACT
Skeleton Variable_3 . .
    The skeleton selection depends on the reporting macro . . . : ARCFSR2
                                          and macro keyword . . :
  Enter END command to start the report generation or CANCEL

The J line command tell Report Generator to display the JCL for editing and submission.

Panel  Help

                         DFSMSrmm Report Definitions         Row 1 to
Command ===>                                                  Scroll =

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

S Name     Report title                   Report type
- -------- ------------------------------ ----------------------------
  ARCGAB01 ABARS ABACKUP Statistics       DFSMShsm ABARS Report
  ARCGAR01 ABARS ARECOVER Statistics      DFSMShsm ABARS Report
  ARCGDB01 DCOLLECT BACKUP DATA           DFSMShsm DCOLLECT BACKUP
  ARCGDD01 DCOLLECT DASD CAPACITY PLANNIN DFSMShsm DCOLLECT DASD CAP
  ARCGDM01 DCOLLECT MIGRATION DATA        DFSMShsm DCOLLECT MIGRATION
  ARCGDT01 DCOLLECT TAPE CAPACITY PLANNIN DFSMShsm DCOLLECT TAPE CAP
J ARCGS001 Statistics for DFSMShsm        DFSMShsm FSR-SMF Records
  ARCGS002 Statistics for Backup          DFSMShsm FSR-SMF Records
  ARCGS003 Statistics for Migration       DFSMShsm FSR-SMF Records
  ARCGS004 Statistics for Recall          DFSMShsm FSR-SMF Records      

Report JCL has the job card defined previously. The conversion JCL will also be visible if selected.

File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help

EDIT       USER001.REPORT.JCL(ARCGS001) - 01.01                    Columns 00001 00080
Command ===>                                                          Scroll ===> CSR
****** ********************************* Top of Data **********************************
000001 //HSMREPT  JOB ,CLASS=A,MSGCLASS=H.MSGLEVEL(1,1)
000002 //*
000003 //*********************************************************************
000004 //**    SKELETON MEMBER EDGSGICE
000005 //**    TAILORED BY THE RMM REPORT GENERATOR
000006 //*********************************************************************
000007 //ARCGFSRC EXEC PGM=SORT
000008 //**********************************************************************
000009 //* z/OS DFSMShsm V1R10                                                *
000010 //*                                                                    *
000011 //* PROPRIETARY V3 STATEMENT                                           *
000012 //* LICENSED MATERIALS - PROPERTY OF IBM                               *
000013 //* "RESTRICTED MATERIALS OF IBM"                                      *
000014 //* 5694-A01                                                           *
000015 //* COPYRIGHT 2008 IBM CORP.                                           *
000016 //* END PROPRIETARY V3 STATEMENT                                       *
000017 //**********************************************************************
000018 //*                                                                    *
000019 //*  FUNCTION    - THIS JCL CONVERTS ARCFSR SMF RECORDS TO ARCFSR2     *
000020 //*                RECORDS TO BE USED AS INPUT FOR REPORT GENERATOR    *
000021 //*                                                                    *
000022 //*  METHOD OF ACCESS                                                  *
000023 //*              - INCLUDED AS AN EXTRACT STEP WHEN GENERATING REPORTS *
000024 //*                                                                    *
000025 //*  Change History:                                                   *
000026 //*                                                                    *
000027 //* $P0=HSMPR,Z1A,072307,THMB: NEW CONVERSION SKELETON             @PRA*

Data sets previously named input data set and Skeleton_Variable_2 are source and target data sets of the conversion part of the JCL.

Note: DISP=(NEW,PASS) may be changed to create a non-temporary data set if desired.
File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help

EDIT       USER001.REPORT.JCL(ARCGS001) - 01.01                    Columns 00001 00080
Command ===>                                                          Scroll ===> CSR
000032 //SYSPRINT DD  SYSOUT=*
000033 //SORTIN   DD  DISP=SHR,
000034 //             DSN=DFHSM.EXTRACT
000035 //SORTOUT  DD  DISP=(NEW,PASS),
000036 //             UNIT=SYSALLDA,
000037 //             LIKE=DFHSM.EXTRACT,
000038 //             DSN=DFHSM.EXTRACT.REFORMAT
000039 //MSGOUT1  DD  SYSOUT=*
000040 //SYSOUT   DD  SYSOUT=*
000041 //SYSIN    DD  *
000042    OPTION VLSHRT,VLSCMP
000043    INCLUDE COND=((6,1,BI,EQ,X'FF'),  DFSMSHSM FSR
000044             AND,(43,1,CH,NE,X'0F'),
000045             AND,(43,1,CH,NE,X'10'))
000046    RECORD TYPE=V
000047    INREC IFTHEN=(WHEN=INIT,
000048      BUILD=(1,18, 1 FM  1 x 18 - CH  FSRHDR
000049        19,8,     19 FM 19 x  8 - CH  FSRJBN
000050        27,4,     27 FM 27 x  4 - BI  FSRRST
000051        31,4,4X'00',  31x4+4          FSRRSD
000052        35,8,     39 FM 35 x  8 - CH  FSRUID
000053        43,1,     47 FM 43 x  1 - BI  FSRTYPE
000054        44,1,     48 FM 44 x  1 - BI  FSRFLAGS
000055        45,44,    49 FM 45 x 44 - CH  FSRDSN
000056        89,6,     93 FM 89 x  6 - CH  FSRTVOL
000057        95,4,     99 FM 95 x  4 - CH  FSRDEVT
000058        99,6,    103 FM 99 x  6 - CH  FSRFVOL 

The date form in the sample report and the selection criteria are part of the generated JCL.

File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help

EDIT       USER001.REPORT.JCL(ARCGS001) - 01.01                    Columns 00001 00080
Command ===>                                                          Scroll ===> CSR
000179 //*********************************************************************
000180 //**  DATE CALCULATION STEP
000181 //**  COMPARE VALUES CONTAINING  ARE CALCULATED BASED ON RUN DATE
000182 //*********************************************************************
000183 //DATECONV EXEC PGM=IKJEFT01,PARM='%EDGRGDAT'
000184 //SYSPROC  DD DISP=SHR,DSN=SYS1.SEDGEXE1
000185 //SYSTSPRT DD SYSOUT=*
000186 //DATEFMT  DD *
000187 DATE PATTERN:YYYYDDD
000188 //INCLIN   DD *
000189  OPTION VLSHRT,VLSCMP
000190  INCLUDE COND=(((161,8,CH,GE,C'&TODAY-007D;'),
000191         AND,
000192                (161,8,CH,LE,C'&TODAY-000D;')),
000193         AND,
000194                (6,1,CH,EQ,X'FF'))
000195  INREC FIELDS=(1,4,
000196            369,2,C' ', 

The input data set, whether created as a temporary data set by the conversion JCL, or pre-existing, is used by the DFSMSrmm Report Generator when extracting data for the report.

The OUTDD card may be changed to a DSN.

File  Edit  Edit_Settings  Menu  Utilities  Compilers  Test  Help

 EDIT       USER001.REPORT.JCL(ARCGS001) - 01.01                    Columns 00001 00080
 Command ===>                                                          Scroll ===> CSR
 000240 //WRITE1   EXEC PGM=ICETOOL,REGION=0M
 000241 //SYSPRINT DD SYSOUT=*
 000242 //TOOLMSG  DD SYSOUT=*
 000243 //DFSMSG   DD SYSOUT=*
 000244 //INDD     DD DSN=DFHSM.EXTRACT.REFORMAT, 
 000245 //            DISP=SHR
 000246 //OUTDD    DD SYSOUT=*   
 000247 //TEMP     DD UNIT=SYSALLDA,SPACE=(TRK,(5,25))
 000248 //TOOLIN   DD *
 000249  SORT FROM(INDD)  TO(TEMP) USING(INCL)
 000250  DISPLAY FROM(TEMP) LIST(OUTDD) -
 000251  TITLE('Statistics for DFSMShsm') -
 000252  PAGE DATE(4MD/) TIME -
 000253  HEADER('FUNC (hex)') ON(8,1,HEX) -
 000254  HEADER('DATE') ON(10,8,CH) -
 000255  HEADER('DSN OR CP NAME') ON(19,44,CH) -
 000256  HEADER('SOURCE') ON(64,6,CH) -
 000257  HEADER('TARGET') ON(71,6,CH) - 

The report may be run by issuing SUB after the line command J displays the JCL in edit or from the Report Generator JCL library as defined in the set up panels. The report may be viewed in the output of the JCL or in an output data set if one was defined.

A thrashing report (ARCGS010) is created from the DFSMSrmm Report Definition (ARCGS004) panel to demonstrate the simplicity of creating new reports from the supplied reports.

Add new selection criteria by entering the S line command by FSR2AGE.

Panel  Help

                    DFSMSrmm Report Definition - ARCGS004    Row 1 to 26 of 80
Command ===>                                                  Scroll ===> CSR

Report title . . . Statistics for Recall
Report footer  . .
Reporting tool . : ICETOOL                                  Report width:  200

Use END to save changes or CANCEL
Select a field name with S to specify a field selection criterion

S CO SO  Field name           Column header text                   CW  Len Typ
- -- --- -------------------- ------------------------------------ --- --- ---
*  1  1A FSR2DATR             DATE                                   8   8  C
   2     FSR2TIMR             TIME REQ                               8   4  B
   3  3A FSR2TIME             TIME COMP                              9   4  B
   4  2A FSR2DSN              DSN                                   44  44  C
s  5     FSR2AGE              AGE                                    3   2  B
   6     FSR2TVOL             TARGET                                 6   6  C
   7     FSR2BYTR             KB READ                                7   4  N
   8     FSR2BYTW             KB WRITE                               8   4  N
   9     FSR2SCNAM            SC NAME                                8   8  C
  10     FSR2MCNAM            MC NAME                                8   8  C
  11     FSR2RECALL_RETRIES   RETRIES                                7   1  B
  12     FSR2HOST             HOST                                   4   2  C
  13     FSR2ORGNL_HID        REQHOST                                7   2  C
  14     FSR2RC               RC (hex)                               8   4  B
*        FSR2TYPE             FUNCTION TYPE - Use browse (M) macro  36   1  B

In this example we are adding thrashing criteria, which in this case is two days between migrate and recall. The report job will then include any records indicating that recall occurred within two days of migration. Each installation should define the number of days between migration and recall which constitute thrashing.

Panel  Help

                     DFSMSrmm Report Criteria - ARCGS004       Row 1 to 4 of 4
Command ===>                                                  Scroll ===> CSR

Report title : Statistics for Recall


Use END to save changes or CANCEL
The following line commands are valid: B,D,N,P,R,T, and I (for details)
Comparison operators: EQ =, NE <>, GT >, GE >=, LT <, LE <=, IN, BW, SE, SN
Conjunction: AND, OR, AND(, )AND

S Field name           Op Compare value(s)                        Conj Len Typ
- -------------------- -- --------------------------------------- ---- --- ---
  FSR2DATR             BW &TODAY; - 7 Days,&TODAY;                  AND(   8  C
  FSR2TYPE             EQ X'04'                                   OR     1  B
  FSR2TYPE             EQ X'05'                                   )AND   1  B
  FSR2AGE              LE X'0002'                                        2  B 
Note:
  1. Date criteria needs adjustment

    Sample reports all have a relative date specified for reporting. This date needs to be changed prior to generating reports.

  2. Reports are provided as the foundation for creating user defined reports.

    Sample report definitions and report types are provided as the foundation for creating your own installation and user-defined reports.

  3. DCOLLECT reports require IDCAMS DCOLLECT be run first to generate source data

    The DCOLLECT job step is generated as part of the J option to generate JCL - if the user specifies Create report data . . Y.

Reporting on DFSMShsm FSR and WWFSR records requires that you use the ARCFSR2 and ARCWFSR2 macros in the report generator with converted SMF data before use or select Create report data . . Y and use the generator to create the JCL to convert the records inline.

For more details about the DFSMSrmm Report Generator see Chapter 2, Using the DFSMSrmm Report Generator in z/OS DFSMSrmm Reporting.