Restarting After a Down AMP is Recovered - MultiLoad

Teradata® MultiLoad Reference

Product
MultiLoad
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-06-18
dita:mapPath
aim1544831946660.ditamap
dita:ditavalPath
gyk1507317446489.ditaval
dita:id
B035-2409
lifecycle
previous
Product Category
Teradata Tools and Utilities

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