Recovery job statistics report
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 (DRF) recovery.
This report includes not only the DRF master job but also all associated address spaces that are spawned by DRF or any of the auxiliary utilities driven by DRF. 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 DRF 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 DRF 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 Non 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=Yand must specify the SMFIN DD.If you specify
EXTRACT-SMF=Yand 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 specifyEXTRACT-SMF=Nand 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 DRF
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 DRF job name is used by multiple runs.
Set this parameter to a date/time that is just prior to the DRF 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 DRF
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 DRF job name is used by multiple runs.
Set this parameter to a date/time that is just after the DRF 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 DRF master job, and is required.
The following parameters are optional but should have the same value specified by the DRF 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
Control Cards:
DRF-JOBNAME TSMXDMXD
ASPREF RMXD
FSPREF FMXD
PRPREF XMXD
IBPREF BMXD
PCPREF PMXD
IBSORT IIUSORTS
FPSORT IIUAPIFC
EXTRACT-SMF N
START-TIMESTAMP 2021-07-10-16.48.00.000000
END-TIMESTAMP 2021-07-10-17.00.00.000000
DEBUG
Earliest SMF job found Day: 2021.191 Time: 16:42:14
Latest SMF job found Day: 2021.191 Time: 16:53:58
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
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
FPSORT 0.87 4428