Recovery job statistics report

Edit online

The recovery job statistics report is a stand-alone batch job that can process system management facility (SMF) records and produce a report showing the elapsed time, CPU time, and I/O counts for an IMS Database Recovery Facility recovery.

This report includes not only the IMS Database Recovery Facility master job but also all associated address spaces that are spawned by IMS Database Recovery Facility or any of the auxiliary utilities driven by IMS Database Recovery Facility. This report lists each individual address space (jobs and started tasks) that is involved in the recovery, and also provides: 1) overall totals, and 2) totals by address space type.

Setting up and running the report job

The JCL to produce this report can be found in SBSYSAMP(BSY#RSRP). The job includes comments on how to provide the input and other job customization. After a successful IMS Database Recovery Facility recovery has been completed, you can run this job to produce the report.

The first time this report is run, you must specify a valid SMF data set for the //SMFIN DD statement that contains the SMF records encompassing the IMS Database Recovery Facility recovery job and associated tasks.

You must also specify input parameter EXTRACT-SMF Y to tell the utility to read the records from the //SMFIN DD.

If you code the //SMFDATA DD on this run and specify a permanent data set to be created (for example, DISP=(NEW,CATLG)), then the SMF records that are needed are written to the SMFDATA data set and saved for subsequent runs. This action allows you to:

Comment out the //SMFIN DD,
Code the //SMFDATA DD to the data set created in the prior run (for example, DISP=SHR), and
Set EXTACT-SMF N on subsequent runs.

This adjustment saves time because the job now reads only those records needed from the SMFDATA data set, and avoids the re-reading of all records in the SMFIN data set.

Parameter reference for job statistics report

The following parameters are used by the report.

EXTRACT-SMF

This parameter indicates whether you want the job to extract the SMF records from either a live SMF data set or an offloaded data set, and then place the needed records in the data sets specified by the SMFDATA DD.

If EXTRACT-SMF=Y, then SMFDATA can specify either a temporary or permanent data set.

If SMFDATA specifies a temporary data set, any re-run of this job must specify EXTRACT-SMF=Y and must specify the SMFIN DD.

If you specify EXTRACT-SMF=Y and specify a new, permanent data set for SMFDATA, the records needed by this job are saved in the SMFDATA data set. Subsequent job runs can specify EXTRACT-SMF=N and the permanent data set for SMFDATA, and avoid re-reading the original SMF data.

START-TIMESTAMP

This parameter specifies the starting range that the utility uses to locate the start of the IMS Database Recovery Facility master recovery job, and must be specified.

This parameter limits the records used in the report and can prevent accumulating incorrect jobs when the same IMS Database Recovery Facility job name is used by multiple runs.

Set this parameter to a date/time that is just prior to the IMS Database Recovery Facility master job start time.

Timestamp format:

YYYY-MM-DD-HH.MM.SS.HHHHHH

END-TIMESTAMP

This parameter specifies the ending range that the utility uses to locate the end of the IMS Database Recovery Facility master recovery job, and must be specified.

This parameter limits the records used in the report and can prevent accumulating incorrect jobs when the same IMS Database Recovery Facility job name is used by multiple runs.

Set this parameter to a date/time that is just after the IMS Database Recovery Facility master job end time.

Timestamp format:

YYYY-MM-DD-HH.MM.SS.HHHHHH

DRF-JOBNAME

This parameter specifies the fully qualified job name of the IMS Database Recovery Facility master job, and is required.

The following parameters are optional but should have the same value specified by the IMS Database Recovery Facility master job. Otherwise all associated recovery jobs will not be reported and accumulated.

ASPREF: This parameter specifies the ASPREF() value, which is used as the prefix for the Recovery Sort Subordinate (RSS) address spaces.
FSPREF: This parameter specifies the FSPREF() value, which is used as the prefix for the Fast Path Secondary Index address spaces.
PRPREF: This parameter specifies the PRPREF() value, which is used as the prefix for the IMS DFSPREC0 utility HALDB index rebuild address spaces.
IBPREF: This parameter specifies the IBPREF() value, which is used as the prefix for the IMS Index Builder index rebuild address spaces.
PCPREF: This parameter specifies the PCPREF() value, which is used as the prefix for the IMS High Performance Pointer Checker (full function) address spaces.
IBSORT: This parameter specifies the name of the sort started task used by the IMS Index Builder when rebuilding indexes.
This value is specified either in the IMS Index Builder IIURPRMS module, or if not specified, IIUSORTS is used by IMS Index builder.
IBAPI: This parameter specifies the name of the API started task used by the IMS Index Builder when rebuilding indexes.
This value is specified either in the IMS Index Builder IIURPRMS module, or if not specified, IIUAPIFC is used by IMS Index builder.

Sample report output

Input Control Cards:
 START-TIMESTAMP     2021-07-10-16.48.00.000000
 END-TIMESTAMP       2021-07-10-17.00.00.000000
 EXTRACT-SMF         N
 DRF-JOBNAME         TSMXDMXD
 ASPREF              RMXD
 FSPREF              FMXD
 PRPREF              XMXD
 IBPREF              BMXD
 PCPREF              PMXD
 IBSORT              IIUSORTS
 IBAPI               IIUAPIFC

User Requested Range Specified:
 Requested Range Start       Day: 2021.191  Time: 16:48:00
 Requested Range End         Day: 2021.191  Time: 17:00:00


SMF Input Records Range Determined:
 Earliest SMF job found      Day: 2021.191  Time: 16:42:14
 Latest SMF job found        Day: 2021.191  Time: 16:53:58


DRF Recovery Job Report:

        JOB         JES       START     START         END       END        ELAPSED       CPU TIME       TOTAL         JOB
       NAME          ID        DATE      TIME        DATE      TIME           TIME         (SECS)        EXCP        TYPE
   --------    --------    --------  --------    --------  --------    -----------    -----------    --------    --------
   TSMXDMXD    J0718228    2021.191  16:48:17    2021.191  16:50:39    00:02:21.32           1.89       20908      DRFMAS
   RMXD0001    S0718230    2021.191  16:48:30    2021.191  16:48:33    00:00:03.34           0.69        4205      ASPREF
   RMXD0002    S0718231    2021.191  16:48:30    2021.191  16:48:33    00:00:02.53           0.59        3568      ASPREF
   RMXD0003    S0718232    2021.191  16:48:30    2021.191  16:48:32    00:00:02.42           0.57        3930      ASPREF
   RMXD0004    S0718233    2021.191  16:48:30    2021.191  16:48:33    00:00:02.54           0.58        4077      ASPREF
   IIUAPIFC    S0718240    2021.191  16:48:45    2021.191  16:48:59    00:00:14.45           0.07         370      FPSORT
   IIUAPIFC    S0718241    2021.191  16:48:45    2021.191  16:49:00    00:00:15.37           0.07         370      FPSORT
   IIUAPIFC    S0718242    2021.191  16:48:45    2021.191  16:49:03    00:00:17.08           0.07         370      FPSORT
   IIUAPIFC    S0718246    2021.191  16:48:46    2021.191  16:49:04    00:00:16.50           0.07         370      FPSORT
   IIUAPIFC    S0718244    2021.191  16:48:45    2021.191  16:49:08    00:00:22.57           0.07         371      FPSORT
   IIUAPIFC    S0718248    2021.191  16:48:46    2021.191  16:49:08    00:00:20.42           0.06         371      FPSORT
   IIUAPIFC    S0718243    2021.191  16:48:45    2021.191  16:49:10    00:00:24.45           0.06         371      FPSORT
   IIUAPIFC    S0718247    2021.191  16:48:46    2021.191  16:49:10    00:00:22.12           0.07         372      FPSORT
   IIUAPIFC    S0718255    2021.191  16:49:20    2021.191  16:50:04    00:00:43.09           0.04         182      FPSORT
   IIUAPIFC    S0718256    2021.191  16:49:20    2021.191  16:50:04    00:00:43.10           0.05         185      FPSORT
   IIUAPIFC    S0718260    2021.191  16:49:27    2021.191  16:50:04    00:00:37.40           0.04         182      FPSORT
   IIUAPIFC    S0718259    2021.191  16:49:27    2021.191  16:50:04    00:00:37.43           0.05         185      FPSORT
   IIUAPIFC    S0718262    2021.191  16:49:36    2021.191  16:50:05    00:00:29.25           0.04         183      FPSORT
   IIUAPIFC    S0718263    2021.191  16:49:36    2021.191  16:50:05    00:00:29.24           0.03         182      FPSORT
   IIUAPIFC    S0718269    2021.191  16:50:15    2021.191  16:50:29    00:00:12.34           0.04         182      FPSORT
   IIUAPIFC    S0718270    2021.191  16:50:15    2021.191  16:50:29    00:00:12.35           0.04         182      FPSORT
   FMXD0001    S0718234    2021.191  16:48:34    2021.191  16:49:14    00:00:38.35           0.48        9037      FSPREF
   FMXD0002    S0718235    2021.191  16:48:34    2021.191  16:49:14    00:00:38.32           0.41        8746      FSPREF
   BMXD0001    S0718236    2021.191  16:48:34    2021.191  16:49:13    00:00:37.36           0.38        5043      IBPREF
   BMXD0001    S0718251    2021.191  16:49:13    2021.191  16:50:09    00:00:55.57           0.61        7576      IBPREF
   BMXD0001    S0718266    2021.191  16:50:09    2021.191  16:50:32    00:00:23.45           0.66        7601      IBPREF
   BMXD0002    S0718237    2021.191  16:48:34    2021.191  16:49:19    00:00:43.03           0.44        6544      IBPREF
   BMXD0002    S0718253    2021.191  16:49:19    2021.191  16:50:11    00:00:52.11           0.62        7564      IBPREF
   BMXD0002    S0718267    2021.191  16:50:12    2021.191  16:50:22    00:00:09.24           0.28        5047      IBPREF
   BMXD0003    S0718238    2021.191  16:48:34    2021.191  16:49:13    00:00:37.44           0.37        5154      IBPREF
   BMXD0003    S0718252    2021.191  16:49:13    2021.191  16:49:25    00:00:11.53           0.27        4512      IBPREF
   BMXD0003    S0718258    2021.191  16:49:25    2021.191  16:50:12    00:00:47.20           0.68        7620      IBPREF
   BMXD0003    S0718268    2021.191  16:50:12    2021.191  16:50:12    00:00:00.02           0.02          65      IBPREF
   BMXD0004    S0718239    2021.191  16:48:34    2021.191  16:49:19    00:00:43.42           0.46        6787      IBPREF
   BMXD0004    S0718254    2021.191  16:49:19    2021.191  16:49:59    00:00:39.02           0.36        5269      IBPREF
   BMXD0004    S0718265    2021.191  16:49:59    2021.191  16:50:19    00:00:19.39           0.48        6489      IBPREF
   IIUSORTS    S0718245    2021.191  16:48:45    2021.191  16:49:13    00:00:27.23           0.16         645      IBSORT
   IIUSORTS    S0718249    2021.191  16:48:46    2021.191  16:49:13    00:00:25.03           0.16         645      IBSORT
   IIUSORTS    S0718257    2021.191  16:49:20    2021.191  16:50:04    00:00:44.23           0.17         645      IBSORT
   IIUSORTS    S0718261    2021.191  16:49:27    2021.191  16:50:05    00:00:37.08           0.16         646      IBSORT
   IIUSORTS    S0718264    2021.191  16:49:36    2021.191  16:50:05    00:00:29.37           0.16         645      IBSORT
   IIUSORTS    S0718271    2021.191  16:50:15    2021.191  16:50:29    00:00:13.50           0.17         645      IBSORT
   PMXD8228    S0718229    2021.191  16:48:26    2021.191  16:48:29    00:00:02.52           0.15        2225      PCPREF

   TOTAL-->                                                                                 12.84      140266    <--TOTAL

DRF Recovery Job Totals by Job Type:

        JOB       CPU TIME       TOTAL
       TYPE         (SECS)        EXCP
   --------    -----------    --------
     ASPREF           2.43       15780
     FSPREF           0.89       17783
     PRPREF           0.00           0
     IBPREF           5.63       75271
     PCPREF           0.15        2225
     IBSORT           0.98        3871
      IBAPI           0.87        4428