Purpose
Changes the state of all tables in the specified database from Standby to Active.
Syntax
DATABASE PROMOTE {<database> [ON tdpid[,tdpid]]} [REASON'reason'];Parameters
- database
- Name of database holding tables currently in Unity Data Dictionary.
- tdpid
- Unique identifier (TDPID) of a Teradata Database system.
- reason
- Reason why objects need to be Active.
Usage Considerations
If a system is not specified when running this command, it sets ALL tables in the database to Active on all systems. Specify a system to make the tables Active on one system.
Example
The following example shows how to promote a Teradata Database system with TDPID fast in Active state.
unityadmin> database promote dbtest on db1;
Operation Number : 539
Operation Name : Promote database
User : admin
User Name : Main Administration User
Start Time : 01/21 08:49:20
Systems:
[1] db1
Updates:
01/21 08:49:20 [-] Info: Successful promote of table dbtest.dblvl1 on 1 systems
01/21 08:49:20 [-] Info: Successful promote of table dbtest.dblvl2 on 1 systems
01/21 08:49:20 [-] Info: Successful promote of table dbtest.dblvl3 on 1 systems
01/21 08:49:20 [-] Info: Successful promote of table dbtest.dblvl4 on 1 systems
01/21 08:49:20 [-] Info: Successful promote of table dbtest.dblvl5 on 1 systems
01/21 08:49:20 [-] Info: Successful promote of table dbtest.dblvl6 on 1 systems
01/21 08:49:20 [-] Info: Successful promote of table dbtest.dblvl7 on 1 systems
01/21 08:49:20 [-] Info: Successful promote of table dbtest.dblvl8 on 1 systems
01/21 08:49:20 [-] Info: Successful promote of table dbtest.dblvl9 on 1 systems
01/21 08:49:20 [-] Info: Successful promote of table dbtest.dblvl10 on 1 systems
01/21 08:49:20 [-] Info: Operation finished
Status : Finished (1)
Finish Time : 01/21 08:49:20
Systems:
[1] db1 - Finished (1)