Purpose
Changes a table or Teradata Database system from Standby state to Active state.
Syntax
SYSTEM PROMOTE tdpid | tdpid [ON database.tablename];Parameters
- database.tablename
- Name of a database and table currently in the Unity Data Dictionary. The table name that you specify must be fully qualified.
- ON tdpid
- Specifies a Teradata Database system on which to activate a table.
- tdpid
- Unique identifier (TDPID) of a Teradata Database system.
Usage Considerations
You can run SYSTEM LIST STATES to view each the status of each table and its associated Teradata Database.
In a state change for a table on a specific Teradata Database system, only the table on that Teradata Database system becomes Active.
If the state change is made for the Teradata Database system, all tables Unity manages on that Teradata Database system become Active. If applied to the Teradata Database system, all tables in the Teradata Database system become Active.
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
The following example demonstrates placing a table t4_cp from a Teradata Database cp_tpp004u in Active state on the Teradata Database system fast.
unityadmin> SYSTEM PROMOTE cp_tpp004u.t4_cp ON fast;
The request is currently processing as operation number 5.
You may check its status using the command 'operation check 5'.
unityadmin> OPERATION CHECK 5;
Operation Number : 5
Operation Name : Promoting Table
User : admin
User Name : Main Administration User
Progress (%) : 100
Status : Finished (1)
Start Time : 01/09 09:56:38
Finish Time : 01/09 09:56:38
Systems:
[2] fast - Finished (1)
Updates:
01/09 09:56:38 [-] Info: Promoting table cp_tpp004u.t4_cp
01/09 09:56:38 [-] Info: Successfully promoted table on 1 systems
01/09 09:56:38 [-] Info: Operation finished