16.10 - DATABASE ACTIVATE - 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

Purpose

Activates all unrecoverable tables within the specified database on one or more systems in a Unity configuration.

Syntax

DATABASE ACTIVATE {<database> [ON tdpid[,tdpid]]} [REASON 'reason'];

Parameters

database
Name of database holding tables currently in Data Dictionary.
tdpid
Unique identifier (TDPID) of a Teradata Database system.
reason
Reason why objects on the database need to change.

Usage Considerations

Use this command after adding a new database using the Data Dictionary Scanner to make all tables within the added database Active.

Only tables that are unrecoverable on all systems can be activated. Any tables that are not unrecoverable on the system they are managed will be skipped.

Example

The following example shows how to activate a Teradata Database system.
unityadmin>  database activate dbtest;
Operation Number : 535
Operation Name   : Activate database
User             : admin
User Name        : Main Administration User
Start Time       : 01/21 08:45:37
Updates:
    01/21 08:45:37 [-] Info: Successfully activated table 'dbtest.dblvl1' on 2 systems.
    01/21 08:45:37 [-] Info: Successfully activated table 'dbtest.dblvl2' on 2 systems.
    01/21 08:45:37 [-] Info: Successfully activated table 'dbtest.dblvl3' on 2 systems.
    01/21 08:45:37 [-] Info: Successfully activated table 'dbtest.dblvl4' on 2 systems.
    01/21 08:45:37 [-] Info: Successfully activated table 'dbtest.dblvl5' on 2 systems.
    01/21 08:45:37 [-] Info: Successfully activated table 'dbtest.dblvl6' on 2 systems.
    01/21 08:45:37 [-] Info: Successfully activated table 'dbtest.dblvl7' on 2 systems.
    01/21 08:45:37 [-] Info: Successfully activated table 'dbtest.dblvl8' on 2 systems.
    01/21 08:45:37 [-] Info: Successfully activated table 'dbtest.dblvl9' on 2 systems.
    01/21 08:45:37 [-] Info: Successfully activated table 'dbtest.dblvl10' on 2 systems.
    01/21 08:45:37 [-] Info: Operation finished
Status      : Finished (1)
Finish Time : 01/21 08:45:37
unityadmin>