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