Teradata Database Message 5269 - 17.10 - 5269 - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Database Messages

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1096-171K
Language
English (United States)
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.