DBUTLTY Backward recovery process produced DB13001E - UNEXPECTED RETURN CODE 13 (62)

Document ID : KB000047598
Last Modified Date : 14/02/2018
Show Technical Document Details

Symptoms:

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

Cause:

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.

Resolution:

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:

OPTION1='(I)'

If you desire, you can also specify

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.

This means you might have a statement like this:

----+----1----+----2----+----3----+----4----+----5----+----6
  RECOVERY OPTION=BACKWARD,MISMATCH=IGNORE,REPORT=ALL,
           SORTWK=05,SORTDD=SORTRPT,OPTION1='(I)'

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=*

Additional Information:

As always, please contact CA Technologies support for CA Datacom if you have further questions.

***