Changes a Teradata Database system from Standby state to Active state.
SyntaxSYSTEM PROMOTE <tdpid> [, <tdpid>, ...] [REASON '<reason>'] ;
- Unique identifier (TDPID) of a Teradata Database system.
- 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.
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.
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:  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