Purpose
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 database system.
- tdpid
- Unique identifier (TDPID) of a 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 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 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
bcmadmin> 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)
bcmadmin>