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. The object becomes Active on the managed system where it was Unrecoverable. The object continues in the same previous state (Active, Out-of-service, or Read-only) on the other managed systems.
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>