Enabling Automatic DIM Update
1 In MetaManager, choose the system for which to have Automatic DIM Update enabled, then right-click it.
2 Click DIM Update.
The DIM Update dialog box appears.
3 Select the Enable DIM Update check box.
4 Click OK to exit the dialog box.
From this dialog box you can also select the Recovery on Startup check box or define the recovery schedule by clicking Schedule (both are optional).
The MDS Recovery Table keeps track of the database name for each DDL that occurs while the DDL Gateway is down. If RSG detects that the Gateway is down, RSG notifies Teradata to begin writing to the MDS Recovery Table. When the Gateway comes back up, it reads the MDS Recovery Table and marks each of the databases in the MDS Recovery Table as “out of sync.” The Gateway will resync each database if Recovery on Startup is selected or at a scheduled recovery time.
The recovery database is always DBC and the MDS Recovery Table is mdsrecoverytbl.
The Teradata user specified in the System Object must have SELECT and DELETE privileges to the MDS Recovery Table.