RETURN CODE 21 (73) on DBUTLTY LOAD using DB Compression

Products

• Datacom
• Datacom/DB

Issue/Introduction

After creating a backup of the production database, a load in the certification MUF failed with this message:

DB13001E - UNEXPECTED RETURN CODE 21 (73) COMPRESSION EXIT GAVE BAD RC

 

Cause

A review of CXX information from the two MUFs showed that the table had two different lengths:

Production MUF                 MUF Certification  
TABLE NAME - D12               TABLE NAME - D12 
TABLE ID - 12                  TABLE ID - 12
RECORD LENGTH - 200 / 212      RECORD LENGTH - 350 / 362

Resolution

The problem here was caused by taking a backup with one record layout and then trying to load it to a different, longer record layout.

Here are some things to think about with this situation.

1. If D12 is the only table in the database with a different Record Length, then you can run the BACKUP command with the Parameter EXCLUDE=D12, and the whole database will be backed up except for table D12.
2. Another option is to use BACKUP for the whole database, then either run a separate EXTRACT function for D12, or use the EXTBKUP to get a separate flat file of the D12 data.
3. For D12, the best option is to run some kind of application program or the SORT utility to convert the 200-byte record to the 350-byte record, then load that EXTRACT format file. 

The main point here is that you cannot use either a BACKUP file or an EXTRACT file from the Production MUF to LOAD into the Certification MUF without some kind of special processing to adjust the record length of the data being loaded.

Additional Information

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