When a down AMP with a fallback type Teradata MultiLoad worktable is recovered, status messages on screen 7 of the database operator’s console may indicate that special procedures might be required to recover the table. For example, this happens if the AMP goes down during the Teradata MultiLoad application phase, as indicated by messages such as:
AMP XXX-X Starting rebuild of db.wt_tbl AMP XXX-X Table in MLOAD apply phase, check associated table - db.wt_tbl AMP XXX-X Completed rebuild of table db.wt_tbl
If the AMP goes down before the Teradata MultiLoad job enters the application phase, the recovery progress is indicated by messages such as:
AMP XXX-X Starting rebuild of db.wt_tbl AMP XXX-X Completed rebuild of table db.wt_tbl