ARC1230 Cannot rehash Permanent Journal Archives - Teradata Tools and Utilities

Archive/Recovery (ARC Prefix) Messages

Product
Teradata Tools and Utilities
Release Number
15.xx,16.xx
Language
English (United States)
Last Update
2018-10-23
dita:id
B035-1096-ARC
lifecycle
latest
Product Category
Teradata® Tools and Utilities

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 now resides. 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 be empty of any change images. This is a FATAL error.

Remedy:

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