Restarting After a Down AMP is Recovered - MultiLoad

Teradata® MultiLoad Reference - 20.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
Lake
VMware
Product
MultiLoad
Release Number
20.00
Published
October 2023
ft:locale
en-US
ft:lastEdition
2024-03-18
dita:mapPath
lji1691576359330.ditamap
dita:ditavalPath
kju1619195148891.ditaval
dita:id
sga1478609868891
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