DATABASE PROMOTE Command | unityadmin | Teradata Unity - 17.00 - DATABASE PROMOTE - 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

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)