DATABASE ACTIVATE Command | unityadmin | Teradata Unity - 17.00 - DATABASE ACTIVATE - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval

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>