16.10 - SYSTEM PROMOTE - 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 Teradata Database system from Standby state to Active state.

Syntax

SYSTEM PROMOTE <tdpid> [, <tdpid>, ...] [REASON '<reason>'] ;

Parameters

tdpid
Unique identifier (TDPID) of a Teradata Database system.
REASON
You can specify an optional reason following the REASON keyword. The reason must be in single quotes and cannot contain single quotes within the reason text string itself.

Usage Considerations

You can run SYSTEM LIST STATES to view each the status of each table and its associated Teradata Database.

All systems specified become Active. Table recovery occurs at this time and Unity recovers each object in the system(s) specified automatically.

To apply this operation at the Teradata Database system level, all tables in the Teradata Database system must be in Standby state. Otherwise the operation results in an error, and no action takes place.

Examples

After running SYSTEM PROMOTE, you can run OPERATION CHECK to view operation status. The prompt includes the operation number to enter.
unityadmin>  SYSTEM PROMOTE bltor; 
unityadmin> The request is currently processing as operation number 3.
You may check its status using the command 'operation check 3'.
unityadmin> OPERATION CHECK 3;
Operation Number : 3
Operation Name   : Promoting Systems
User             : admin
User Name        : Main Administration User
Progress (%)     : 100
Status           : Finished (1)
Start Time       : 01/09 09:50:57
Finish Time      : 01/09 09:50:57
Systems:
    [2] bltor - Finished (1)
Updates:
    01/09 09:50:57 [-] Info: Promoting selected systems
    01/09 09:50:57 [-] Info: Successfully promoted 1 systems
    01/09 09:50:57 [-] Info: Operation finished