16.10 - OBJECT 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 state of a table object to the Standby state. The table must be managed by Unity.

Syntax

OBJECT DEMOTE {tablename [ON tdpid [, tdpid, ...]]} [ REASON reason];

Parameters

ON
Change a table on a specific Teradata Database system.
tdpid
Unique identifier (TDPID) of a Teradata Database system.
REASON reason
User description of why the object is having its state changed.
tablename
The fully qualified table name if you are attempting to change the state of a table.

Usage Considerations

When you specify a single databasename.objectname, the table object changes to a Standby state on all Teradata Database systems managed by Unity. An administrator can demote a table object to a Standby state only from an Active state.

Example

The following changes a table temporal_user.tab3chld to the Standby state across all managed Teradata Database systems.

unityadmin>  OBJECT DEMOTE 
  -> temporal_user.tab3chld;
The request is currently processing as operation number 2.

Operation Number : 2
Operation Name   : Demoting Table
User             : admin
User Name        : Main Administration User
Progress (%)     : 100
Status           : Finished (1)
Start Time       : 01/18 13:55:56
Finish Time      : 01/18 13:55:59
Systems:
    [1] bltor - Finished (1)
    [2] fast - Finished (1)
Updates:
    01/18 13:55:59 [-] Info: Demoting table temporal_user.tab3chld
    01/18 13:55:59 [-] Info: Successfully demoted table on 2 systems
    01/18 13:55:59 [-] Info: Operation finished