DICTIONARY RELOAD - Teradata Unity

Teradata® Unity™ User Guide

Product
Teradata Unity
Release Number
16.50
Published
January 2020
Language
English (United States)
Last Update
2020-02-04
dita:mapPath
frp1571162435023.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

Purpose

Causes the Unity Data Dictionary to be reloaded into memory.

Syntax

DICTIONARY RELOAD ;

Usage Considerations

Unity Data Dictionary automatically reloads as the final step of the DEPLOY operation, and reloads each time the Sequencer process starts. Administrators only need to reload manually 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 : 35
Operation Name   : Dictionary Reload
User             : admin
User Name        : Main Administration User
Start Time       : 01/27 09:54:17
Updates:
    01/27 09:54:17 [-] Info: Starting dictionary reload
    01/27 09:54:17 [-] Info: Loaded 5 tables
    01/27 09:54:17 [-] Info: Loaded 7 views
    01/27 09:54:17 [-] Info: Loaded 365 functions
    01/27 09:54:17 [-] Info: Loaded 31 procedures
    01/27 09:54:17 [-] Info: Loaded 0 triggers
    01/27 09:54:17 [-] Info: Loaded 0 references
    01/27 09:54:17 [-] Info: Loaded 21 macros
    01/27 09:54:17 [-] Info: Loaded 30 UDTs
    01/27 09:54:17 [-] Info: Loaded 459 total objects
    01/27 09:54:17 [-] Info: Max item id: 1459
    01/27 09:54:17 [-] Info: Dictionary successfully reloaded
    01/27 09:54:17 [-] Info: Reload dictionary succeeded
    01/27 09:54:17 [-] Info: Operation finished
Status      : Finished (1)
Finish Time : 01/27 09:54:17