ARC1240 Implicit BUILD for no-fallback table ignored. - Teradata Tools and Utilities

Archive/Recovery (ARC Prefix) Messages

prodname
Teradata Tools and Utilities
vrm_release
15.10
category
Programming Reference
featnum
B035-1096-151K

ARC1240 Implicit BUILD for no-fallback table ignored.

Explanation:

The BUILD phase of no-fallback table RESTORE/COPY with rehashing cannot be completed if one or more AMP(s) are down. A separate explicit BUILD statement on failed object(s) should be submitted later when all AMPs are back online. Same explanation applies if the archive is incomplete, that is, there was a offline AMP during the ARCHIVE. In this case, BUILD statement is needed after restoring supplementary specific AMP ARCHIVE.

For Whom:

End User.

Notes:

This is a warning message. All fallback tables in the database have been restored normally. Also, all data blocks for no-fallback tables have been restored to the DBS; therefore, there is no need to re-restore failed no-fallback tables.

Remedy:

Submit explicit BUILD statement for failed objects.