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.
In order to successfully sort a large amount of RXX (Recovery) data, it is recommended to 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, it is recommended to use this parameter on the RECOVERY function to produce verbose messages from the Sort program, and include all informational and critical messages:
OPTION1='(I)'
SORTDD can also be specified:
SORTDD=xxxxx
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.
Below is an example statement:
----+----1----+----2----+----3----+----4----+----5----+----6
RECOVERY OPTION=BACKWARD,MISMATCH=IGNORE,REPORT=ALL,
SORTWK=05,SORTDD=SORTRPT,OPTION1='(I)'
Additional DD statements need to be added:
//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 Broadcom support for any Datacom related questions or issues