15.00 - After a Down AMP is Recovered - MultiLoad

Teradata MultiLoad Reference

prodname
MultiLoad
vrm_release
15.00
category
Programming Reference
featnum
B035-2409-034K

After a Down AMP is Recovered

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