About Loading Databases - 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

MDS loads data dictionary information for each of the selected databases into the MDS repository. The actual data in the database tables is not loaded.

The following table shows the options used to load databases into the MDS repository. These options determine which databases the DDL Gateway keeps in sync. The difference is in how the DDL Gateway handles newly created users and databases in the Teradata Database system.

Load Option Description
All The DDL Gateway automatically adds new databases and users created in the Teradata Database system to the MDS repository. This option indicates that the MDS repository contains all databases in the Teradata Database system.
Selected The DDL Gateway does not add new databases and users created in the Teradata Database system to the MDS repository. The DDL Gateway maintains only those databases selectively loaded into the MDS repository. If you use this option, and later use the Load All option, the Load flag is changed to Load All.
All but Selected The DDL Gateway automatically adds new databases and users created in the Teradata Database system to the MDS repository. However, it maintains the list of those databases that were excluded on the initial load and ignores all DDL statements for those databases. Databases that were originally loaded, but later unloaded, are considered excluded databases.

For all other DDL statements, the DDL Gateway updates the repository for loaded databases and ignores DDL statements for databases that are not loaded into the repository.

If databases are not loaded for a Teradata Database system, the DDL Gateway does not track that system even if Automatic DIM Update is enabled for the system.

Before you enable the Automatic DIM Update feature, load all databases to be maintained. If a long time passes between the time the databases are initially loaded and when Automatic DIM Update is enabled, resynchronize all databases before you enable the feature. The functionality to resynchronize and unload databases is not available in the current version of MDS Repository Explorer, but is available by using MetaManager to do these tasks, as described in “Resynchronize Databases” and “Unload Databases” in Chapter 3 of Teradata Meta Data Services Administrator Guide (3118-071A), the documentation for a previous release of MDS.