Restarting After a Down AMP is Recovered - MultiLoad

Teradata MultiLoad Reference

Product
MultiLoad
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-07-11
dita:mapPath
cgb1488824663145.ditamap
dita:ditavalPath
Audience_PDF_product_tpt_userguide_include.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