Checking the Status of Automatic DIM Update - Teradata Meta Data Services

Teradata Meta Data Services

Product
Teradata Meta Data Services
Release Number
15.00
Published
February 2015
Language
English (United States)
Last Update
2018-09-27
dita:mapPath
B035-3045-114K/MDS_Installation_1500.ditamap
dita:ditavalPath
ft:empty
Product Category
Teradata Tools and Utilities
  1. In MetaManager, right-click the system that contains the database(s) to administer and click Database Administration.The Teradata Meta Data Services Administration dialog appears.
  2. To determine if any databases are marked out of sync by the DDL Gateway, click the Dim Update Status tab.

    If Automatic DIM Update has not been enabled for your system, the DIM Update Status tab is unavailable.

    The DIM Update Status window shows the following:

    Name Description
    System Name The name of the chosen Teradata Database system
    DIM Update Status The DIM Update status of the system:
    Indicated Status Meaning
    UP DIM Update is up and tracking changes to the system
    DOWN DDL Gateway has not yet notified the Teradata Database system to begin sending DDL statements
    STOPPED DIM Update is disabled and not tracking changes to the system
    RESYNC DDL 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 List of database names 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