16.10 - SYSTEM 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

Purpose

Changes a table or Teradata Database system from Active to Standby state.

Syntax

SYSTEM DEMOTE {tpdid[, ...]} | {database.tablename [ON tpdid [, tpdid...]]} ["reason"];

Parameters

database.tablename
Name of a database and table currently in the Unity Data Dictionary. The table name that you specify must be fully qualified.
tdpid
Unique identifier (TDPID) of a Teradata Database system.
"reason"
User description of why the object is having its state changed.

Usage Considerations

You must include a tdpid or databasename.tablename.

If the state change is made for the Teradata Database system, all tables Unity manages on that Teradata Database system become Standby.

In a state change for a table, the table on all Teradata Database systems becomes Standby.

Example

The following example demonstrates placing a Teradata Database system with the TDPID fast in Standby state, followed by running the OPERATION CHECK command to view status.

unityadmin>  SYSTEM DEMOTE fast; 
The request is currently processing as operation number 5.
You may check its status using the command 'operation check 5'.
unityadmin> OPERATION CHECK 5;
Operation Number : 5
Operation Name   : Demoting Systems
User             : admin
User Name        : Main Administration User
Progress (%)     : 100
Status           : Finished (1)
Start Time       : 11/14 17:56:51
Finish Time      : 11/14 17:56:52
Systems:
    [2] fast - Finished (1)
Updates:
    11/14 17:56:52 [-] Info: Demoting selected systems
    11/14 17:56:52 [-] Info: Successfully demoted 1 systems
    11/14 17:56:52 [-] Info: Operation finished