Teradata Database Message 5269 - 5269 - Analytics Database - Teradata Vantage

Message

WARNING: Perform Row-at-a-time inserts instead of Block-at-a-time due to incompatible system/object characteristics.

Explanation

A BAR Restore operation cannot restore whole blocks from the archive due to incompatible file system characteristics on the target system. The Restore operation will restore individual rows. It does row-at-a-time inserts and display this warning in the following cases and only when REBLOCK=false (Note that by default REBLOCK=false): 1) Source and target system have different alignment sizes. 2) When archive and restore is between committal and non-committal systems. 3) Source and target have different row formats. 4) When one or more of the backup streams contain AMPs belong to a cluster that has more than 2 amps and there was a down AMP in the cluster when the backup was taken.

Generated By

DBS BAR

For Whom

End user of BAR Restore.

Notes

This is an informational message, not a fatal error. The Restore operation will complete successfully.

Remedy

After completion of the Restore, contact Field Engineer and take appropriate action if necessary.