15.00 - 8232 Cannot build re-hashed table with AMP off-line - Teradata Database

Teradata Database Messages

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1096-015K
Language
English (United States)

8232 Cannot build re-hashed table with AMP off-line

Explanation:

Non-fallback protected tables cannot be built when an AMP is off-line if the rows need to be re-hashed. Rows can be initially loaded but they cannot be properly re-hashed and sorted until all AMPs are up.

Generated By:

HUTBLD Amp procedure.

For Whom:

End User.

Remedy:

The utility will report the error and skip to the next table to be processed. Later, you need to bring the bad AMP back on-line and perform an explicit BUILD NO FALLBACK operation.