Checking DIM Update Status
1
In Teradata MDS, click System > Database Systems.
2
In the Meta Data Services Administration window, highlight a system name, then click Database Administration.
The Teradata Meta Data Services Administration dialog box appears.
To go directly to the Teradata Meta Data Services Administration dialog box, from the MetaManager main window, right click on the system with database(s)
that you want to administer, and click Database Administration.
3
Click the Dim Update Status tab to determine if any databases are marked out of sync by the DDL Gateway.
The DIM Update Status tab is disabled if Automatic DIM Update has not been enabled
for your system. Refer to “Enabling Automatic DIM Update” on page 137 for additional information.
The DIM Update Status window shows:
System Name – Displays the system chosen
DIM Update Status – Displays the DIM Update status of the system. The status codes are:
UP – DIM Update is up and tracking changes to the system
DOWN – the DDL Gateway has not yet notified the Teradata Database System to begin sending
DDLs
STOPPED – DIM Update is disabled and not tracking changes to the system
RESYNC – The Gateway is currently running recovery (scheduled or on startup)
UNKNOWN – MetaManager could not contact the DDL Gateway to get the status or the DDL Gateway
does not know about the system
Database out of sync – the box displays the list of database names that the DDL Gateway has marked out
of sync including those that were in the MDS Recovery Table.
Refresh List – updates the display
Sync Now – sends a message to the DDL Gateway to immediately begin recovery to synchronize
the Out of Sync databases.