CA Datacom DBUTLTY LOAD from a BACKUP of the same Database from another MUF environment failed with error DB13008E - INPUT RECORD LENGTH nnnn DOES NOT MATCH THE TABLE table RECORD LENGTH nnnn

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

Scenario:

CA Datacom DBUTLTY LOAD from a BACKUP of the same Database from another MUF environment… 


   LOAD DBID=dbid,DDNAME=backupfile,FORMAT=BACKUP,SORT=nnnnnn 


… failed with error …


  DB13008E - INPUT RECORD LENGTH nnnn DOES NOT MATCH THE TABLE table RECORD LENGTH nnnn 

 

Resolution:

In this particular case, compare of the CXX report from the BACKUP source database and from the LOAD target database showed that the lengths of the Table were the same but that the TABLE ID were not the same value causing the wrong Table to be accessed which had a different record length.

To resolve the problem, update the target table TABLE ID to be the same as the source TABLE ID using DDUPDATE 3150 transaction to update the TABLE ID followed by a catalog of the database to the CXX. 

Then the DBUTLTY LOAD from the BACKUP should be successful since the correct table will be accessed.