OBJECT ACTIVATE - Teradata Unity

Teradata® Unity™ User Guide

Product
Teradata Unity
Release Number
16.50
Published
January 2020
Language
English (United States)
Last Update
2020-02-04
dita:mapPath
frp1571162435023.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

Purpose

This command activates the specified object on the specified systems in the cluster.

Syntax

OBJECT ACTIVATE {tablename [ON tdpid [, tdpid, ...]]} [ REASON 'reason'] [SYNCED FROM tdpid] ;

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.
SYNCED FROM
An object in an Unrecoverable state on one of the managed systems can be activated if the data has been manually synced up between managed systems that are in Active, Out-of-service, or Read-only states. During OBJECT ACTIVATE using the SYNCED FROM clause, the source table must be in either Read-Only or Out of Service. The object becomes Out of Service on the managed system where it was Unrecoverable, and then can be recovered to Active. This allows you to use an online ARC to minimize the write-outage on the source table.

Usage Considerations

The OBJECT ACTIVATE command changes all specified Teradata Database systems and the table objects on those systems to an Active state. The specified table objects must be in an Unrecoverable state before being activated. The data in the specified table objects must be synchronized across the specified Teradata Database systems to successfully be changed to an Active state. The OBJECT ACTIVATE command fails if data is inconsistent or if table objects are not in the Unrecoverable state prior to running the command.

Example

unityadmin> OBJECT ACTIVATE  upgrade_test.active_table;
Operation Number : 29
Operation Name   : Activating Table
User             : admin
User Name        : Main Administration User
Start Time       : 12/24 14:06:49
Systems:
    [1] sdll7772
    [2] sdll7773
Updates:
    12/24 14:06:49 [-] Info: Activating table upgrade_test.active_table
    12/24 14:06:49 [-] Info: Successfully activated table on 2 systems
    12/24 14:06:49 [-] Info: Operation finished
Status      : Finished (1)
Finish Time : 12/24 14:06:49
Systems:
    [1] sdll7772 - Finished (1)
    [2] sdll7773 - Finished (1)
unityadmin>