When running a DBUTLTY Backward recovery (RECOVERY OPTION=BACKWARD), a large RXX file, or a collection of RXX files could produce an error:
DB13001E - UNEXPECTED RETURN CODE 13 (62) SORT IN LOAD/RETIX HAD AN ERROR
This could be accompanied by this message in the JES Message Log:
ICE046A 0 jobname.stepname SORT CAPACITY EXCEEDED - RECORD COUNT nnnnnnn
The RC 13(62) error reflects a problem trying to use the site’s Sort program. While there could be many reasons for the Sort program to fail (including not having a Sort program active on the LPAR), this combination of errors indicates that the Sort program could not complete its sort activities due to insufficient memory and sort work space.
For other errors, please contact the CA Technologies support team to help resolve them.
In order to successfully sort a large amount of RXX (Recovery) data, we recommend that you include SORTWK## DD statements in the DBUTLTY jobstep. By default, DBUTLTY will use up to three sortwork files (SORTWK01, SORTWK02, and SORTWK03), and if more are needed, the following parameter needs to be added to the RECOVERY function:
SORTWK=nn (identifies how many SORTWK## files will be used – values 01 to 99)
Then, the corresponding DD statements need to be defined to the step.
In addition, we would recommend that you use this parameter on the RECOVERY function to produce verbose messages from the Sort program, and include all informational and critical messages:
If you desire, you can also specify
where xxxxx is an output (SYSOUT) DD name that contains only the output from the SORT. Otherwise (the default), the SORT messages are included with the output from DBUTLTY function that uses the SORT.
This means you might have a statement like this:
You would then need these additional DD statements:
//SORTWK01 DD UNIT=SYSDA,SPACE=...
//SORTWK02 DD UNIT=SYSDA,SPACE=...
//SORTWK03 DD UNIT=SYSDA,SPACE=...
//SORTWK04 DD UNIT=SYSDA,SPACE=...
//SORTWK05 DD UNIT=SYSDA,SPACE=.
//SORTRPT DD SYSOUT=*
As always, please contact CA Technologies support for CA Datacom if you have further questions.