Out of Sync Recovery
The MDS repository can be out of sync with a Teradata Database System for a number
of reasons:
A Teradata Database System, RSG and/or MDS DDL Gateway reset occurs.
An error occurs and an Integrity Server cannot commit a transaction to the repository.
The MDS DDL Gateway goes down and does not come back up right away. In this case Teradata
is processing DDLs and not forwarding them on to MDS but is writing the database names
to the MDS Recovery Table.
The Integrity Servers have a backlog of transactions that have not yet been processed.
When the Automatic DIM Update feature is enabled, the task of keeping track of the
DDL Transactions is divided among the three components: Teradata Database System,
RSG, and DDL Gateway Server.