DATABASE PROMOTE - Teradata Unity

Teradata Unity User Guide

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

Purpose

Changes the state of all tables in the specified database from Standby to Active.

Syntax

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

Parameters

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

Usage Considerations

If a system is not specified when running this command, it sets ALL tables in the database to Active on all systems. Specify a system to make the tables Active on one system.

Example

The following example shows how to promote a Teradata Database system with TDPID fast in Active state.
unityadmin> database promote dbtest on db1;
Operation Number : 539
Operation Name   : Promote database
User             : admin
User Name        : Main Administration User
Start Time       : 01/21 08:49:20
Systems:
    [1] db1
Updates:
    01/21 08:49:20 [-] Info: Successful promote of table dbtest.dblvl1 on 1 systems
    01/21 08:49:20 [-] Info: Successful promote of table dbtest.dblvl2 on 1 systems
    01/21 08:49:20 [-] Info: Successful promote of table dbtest.dblvl3 on 1 systems
    01/21 08:49:20 [-] Info: Successful promote of table dbtest.dblvl4 on 1 systems
    01/21 08:49:20 [-] Info: Successful promote of table dbtest.dblvl5 on 1 systems
    01/21 08:49:20 [-] Info: Successful promote of table dbtest.dblvl6 on 1 systems
    01/21 08:49:20 [-] Info: Successful promote of table dbtest.dblvl7 on 1 systems
    01/21 08:49:20 [-] Info: Successful promote of table dbtest.dblvl8 on 1 systems
    01/21 08:49:20 [-] Info: Successful promote of table dbtest.dblvl9 on 1 systems
    01/21 08:49:20 [-] Info: Successful promote of table dbtest.dblvl10 on 1 systems
    01/21 08:49:20 [-] Info: Operation finished
Status      : Finished (1)
Finish Time : 01/21 08:49:20
Systems:
    [1] db1 - Finished (1)