15.00 - ARC1230 Cannot rehash Permanent Journal Archives - Teradata Tools and Utilities

Archive/Recovery (ARC Prefix) Messages

prodname
Teradata Tools and Utilities
vrm_release
15.00
category
Programming Reference
featnum
B035-1096-015K

ARC1230 Cannot rehash Permanent Journal Archives

Explanation:

Permanent journals cannot be RESTOREd or COPYed to a DBS with a different hashing algorithm than that of the source DBS. The reason for this is that journal change images contain a "pointer" to the affected data row in the form of the "rowid". When the parent data row has been re-hashed it is impossible for the software to determine where it nowresides. Therefore, the operation is not allowed. This is a fatal error to the utility.

For Whom:

End User.

Notes:

If the user has just completed a DBC database restore, it is necessary to restore the definitions of the Permanent Journal tables before the data tables are restored. In this situation, the user CAN perform a DICTIONARY restore against the journal archive. This will result in restoring the definitions of the journals to the target DBS but they will beempty of any change images. This is a FATAL error.

Remedy:

DICTIONARY restore is possible in the above situation. Otherwise, operation is not allowed.