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 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 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 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
Control Cards:
DRF-JOBNAME TSMXDMXD
ASPREF RMXD
FSPREF FMXD
PRPREF XMXD
IBPREF BMXD
PCPREF PMXD
IBSORT IIUSORTS
FPSORT IIUAPIFC
EXTRACT-SMF N
START-TIMESTAMP 2020-07-09-16.48.00.000000
END-TIMESTAMP 2020-07-09-17.00.00.000000
DEBUG
Earliest SMF job found Day: 2020.191 Time: 16:42:14
Latest SMF job found Day: 2020.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 2020.191 16:48:17 2020.191 16:50:39 00:02:21.32 1.89 20908 DRFMAS
RMXD0001 S0718230 2020.191 16:48:30 2020.191 16:48:33 00:00:03.34 0.69 4205 ASPREF
RMXD0002 S0718231 2020.191 16:48:30 2020.191 16:48:33 00:00:02.53 0.59 3568 ASPREF
RMXD0003 S0718232 2020.191 16:48:30 2020.191 16:48:32 00:00:02.42 0.57 3930 ASPREF
RMXD0004 S0718233 2020.191 16:48:30 2020.191 16:48:33 00:00:02.54 0.58 4077 ASPREF
IIUAPIFC S0718240 2020.191 16:48:45 2020.191 16:48:59 00:00:14.45 0.07 370 FPSORT
IIUAPIFC S0718241 2020.191 16:48:45 2020.191 16:49:00 00:00:15.37 0.07 370 FPSORT
IIUAPIFC S0718242 2020.191 16:48:45 2020.191 16:49:03 00:00:17.08 0.07 370 FPSORT
IIUAPIFC S0718246 2020.191 16:48:46 2020.191 16:49:04 00:00:16.50 0.07 370 FPSORT
IIUAPIFC S0718244 2020.191 16:48:45 2020.191 16:49:08 00:00:22.57 0.07 371 FPSORT
IIUAPIFC S0718248 2020.191 16:48:46 2020.191 16:49:08 00:00:20.42 0.06 371 FPSORT
IIUAPIFC S0718243 2020.191 16:48:45 2020.191 16:49:10 00:00:24.45 0.06 371 FPSORT
IIUAPIFC S0718247 2020.191 16:48:46 2020.191 16:49:10 00:00:22.12 0.07 372 FPSORT
IIUAPIFC S0718255 2020.191 16:49:20 2020.191 16:50:04 00:00:43.09 0.04 182 FPSORT
IIUAPIFC S0718256 2020.191 16:49:20 2020.191 16:50:04 00:00:43.10 0.05 185 FPSORT
IIUAPIFC S0718260 2020.191 16:49:27 2020.191 16:50:04 00:00:37.40 0.04 182 FPSORT
IIUAPIFC S0718259 2020.191 16:49:27 2020.191 16:50:04 00:00:37.43 0.05 185 FPSORT
IIUAPIFC S0718262 2020.191 16:49:36 2020.191 16:50:05 00:00:29.25 0.04 183 FPSORT
IIUAPIFC S0718263 2020.191 16:49:36 2020.191 16:50:05 00:00:29.24 0.03 182 FPSORT
IIUAPIFC S0718269 2020.191 16:50:15 2020.191 16:50:29 00:00:12.34 0.04 182 FPSORT
IIUAPIFC S0718270 2020.191 16:50:15 2020.191 16:50:29 00:00:12.35 0.04 182 FPSORT
FMXD0001 S0718234 2020.191 16:48:34 2020.191 16:49:14 00:00:38.35 0.48 9037 FSPREF
FMXD0002 S0718235 2020.191 16:48:34 2020.191 16:49:14 00:00:38.32 0.41 8746 FSPREF
BMXD0001 S0718236 2020.191 16:48:34 2020.191 16:49:13 00:00:37.36 0.38 5043 IBPREF
BMXD0001 S0718251 2020.191 16:49:13 2020.191 16:50:09 00:00:55.57 0.61 7576 IBPREF
BMXD0001 S0718266 2020.191 16:50:09 2020.191 16:50:32 00:00:23.45 0.66 7601 IBPREF
BMXD0002 S0718237 2020.191 16:48:34 2020.191 16:49:19 00:00:43.03 0.44 6544 IBPREF
BMXD0002 S0718253 2020.191 16:49:19 2020.191 16:50:11 00:00:52.11 0.62 7564 IBPREF
BMXD0002 S0718267 2020.191 16:50:12 2020.191 16:50:22 00:00:09.24 0.28 5047 IBPREF
BMXD0003 S0718238 2020.191 16:48:34 2020.191 16:49:13 00:00:37.44 0.37 5154 IBPREF
BMXD0003 S0718252 2020.191 16:49:13 2020.191 16:49:25 00:00:11.53 0.27 4512 IBPREF
BMXD0003 S0718258 2020.191 16:49:25 2020.191 16:50:12 00:00:47.20 0.68 7620 IBPREF
BMXD0003 S0718268 2020.191 16:50:12 2020.191 16:50:12 00:00:00.02 0.02 65 IBPREF
BMXD0004 S0718239 2020.191 16:48:34 2020.191 16:49:19 00:00:43.42 0.46 6787 IBPREF
BMXD0004 S0718254 2020.191 16:49:19 2020.191 16:49:59 00:00:39.02 0.36 5269 IBPREF
BMXD0004 S0718265 2020.191 16:49:59 2020.191 16:50:19 00:00:19.39 0.48 6489 IBPREF
IIUSORTS S0718245 2020.191 16:48:45 2020.191 16:49:13 00:00:27.23 0.16 645 IBSORT
IIUSORTS S0718249 2020.191 16:48:46 2020.191 16:49:13 00:00:25.03 0.16 645 IBSORT
IIUSORTS S0718257 2020.191 16:49:20 2020.191 16:50:04 00:00:44.23 0.17 645 IBSORT
IIUSORTS S0718261 2020.191 16:49:27 2020.191 16:50:05 00:00:37.08 0.16 646 IBSORT
IIUSORTS S0718264 2020.191 16:49:36 2020.191 16:50:05 00:00:29.37 0.16 645 IBSORT
IIUSORTS S0718271 2020.191 16:50:15 2020.191 16:50:29 00:00:13.50 0.17 645 IBSORT
PMXD8228 S0718229 2020.191 16:48:26 2020.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