About Data Dictionary Views - Teradata Data Mover

Teradata Data Mover User Guide

Product
Teradata Data Mover
Release Number
16.00
Published
December 2016
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
rdo1467305237457.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-4101
lifecycle
previous
Product Category
Analytical Ecosystem
The Teradata Database Data Dictionary has tables and views that reside in system user DBC. The tables are reserved for use by the system and contain information about the data in the system. The views provide access to the information in the tables. Data Dictionary has the following table views available, depending on the version of the Teradata Database in use:
  • Base or V Version: better performance
  • X or XV Version: increased security, reduced performance
The table below shows which versions of the view Data Mover uses, depending on your configuration settings and Teradata Database version. When all four views are available and the databaseQueryService.useBaseViewsOnly configuration setting is true (default), the Base or V Version of the view is used, depending on the version of the Teradata Database. When all four views are available but the databaseQueryService.useBaseViewsOnly configuration setting is false, the X or VX Version of the view is used, depending on the version of the Teradata Database.
Data Dictionary View Name Version of DBC View Used with databaseQueryService.useBaseViewsOnly Setting Source or Target
  True False  
DBC.ALL_RI_Children V VX Source only
DBC.Columns V VX Source and Target
DBC.ColumnStats V V Source only
DBC.Databases V VX Source and Target
DBC.DiskSpace Base or V Base or V Source and Target
DBC.Functions V VX Target only
DBC.IndexStats V V Source only
DBC.Indices V VX Source and Target
DBC.JoinIndices V V Source and Target
DBC.Journals V VX Source only
DBC.MultiColumnStats V V Source only
DBC.Server V VX Target only
DBC.Tables V VX Source and Target
DBC.TableSize V VX Source and Target
DBC.TblSrvInfo V VX Target only
DBC.Triggers V VX Source and Target
DBC.User_Default_Journals V VX Source and Target
DBC.RI_Distinct_Children V VX Source and Target
DBC.RI_Distinct_Parents V VX Source and Target
DBC.Children V VX Source only
Users that run commands and jobs in Data Mover must have SELECT permissions on the views listed in the table for Data Mover to function properly.