DICTIONARY RELOAD - Teradata Unity

Teradata Unity User Guide

Product
Teradata Unity
Release Number
16.10
Published
January 2018
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
anz1496162519675.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

Purpose

Causes the Active Sequencer to load the currently deployed Unity Data Dictionary from the Unity repository.

Syntax

DICTIONARY RELOAD ;

Usage Considerations

Unity Data Dictionaries automatically reload as the final step of the DEPLOY operation, and reload each time the Sequencer process starts. Administrators only need to manually reload if they have resolved an error that occurred during a DEPLOY operation, or if they are directed to reload by Support.

Example

The following example shows the DICTIONARY RELOAD command output. The output indicates that the RELOAD operation status is finished and successful.

unityadmin> dictionary reload;
Operation Number : 13
Operation Name   : Dictionary Reload
User             : admin
User Name        : Main Administration User
Start Time       : 12/24 13:37:39
Updates:
    12/24 13:37:39 [-] Info: Starting dictionary reload
    12/24 13:37:40 [-] Info: Structure validation finished with 0
    12/24 13:37:40 [-] Info: 2 objects will be loaded
    12/24 13:37:41 [-] Info: Loading udts
    12/24 13:37:41 [-] Info: Loaded 0 managed udts
    12/24 13:37:41 [-] Info: Loading tables
    12/24 13:37:41 [-] Info: Loaded 2 managed tables
    12/24 13:37:41 [-] Info: Loading views
    12/24 13:37:41 [-] Info: Loaded 0 managed views
    12/24 13:37:41 [-] Info: Loading procedures
    12/24 13:37:43 [-] Info: Loaded dictionary at version 2, major 2, minor 3
    12/24 13:37:43 [-] Info: Load time: 1387921063
    12/24 13:37:43 [-] Info: max_item_id: 1002, item count 123
    12/24 13:37:43 [-] Info: Structure validation finished with 0
    12/24 13:37:43 [-] Info: 2 objects will be loaded
    12/24 13:37:43 [-] Info: Loading udts
    12/24 13:37:43 [-] Info: Loaded 0 managed udts
    12/24 13:37:43 [-] Info: Loading tables
    12/24 13:37:43 [-] Info: Loaded 2 managed tables
    12/24 13:37:43 [-] Info: Loading views
    12/24 13:37:44 [-] Info: Loaded 0 managed views
    12/24 13:37:44 [-] Info: Loading procedures
    12/24 13:37:45 [-] Info: Loaded 0 orphaned managed objects
    12/24 13:37:46 [-] Info: Loaded dictionary at version 2, major 2, minor 3
    12/24 13:37:46 [-] Info: Load time: 1387921066
    12/24 13:37:46 [-] Info: max_item_id: 1002, item count 123
    12/24 13:37:46 [-] Info: Dictionary successfully reloaded
    12/24 13:37:46 [-] Info: Reload dictionary succeeded
    12/24 13:37:46 [-] Info: Operation finished
Status      : Finished (1)
Finish Time : 12/24 13:37:46
unityadmin>