DATABASE DEMOTE - 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
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

Purpose

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

Syntax

DATABASE DEMOTE{<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
Description of why objects on the database need to be demoted.

Usage Considerations

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

Example

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