Purpose
Changes the state of all tables in the specified database from Active to Standby.
Syntax
DATEBASE DEMOTE{<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
- Description of why objects on the database need to be demoted.
Usage Considerations
If a system is not specified when running this command, it sets all tables in the database to Standby on ALL systems, which is not usually correct. Specify a system to make the tables Standby only on one system.
Example
The following example shows how to demote a Teradata Database system with TDPID fast in Standby state.
unityadmin> database demote dbtest on db1;
Operation Number : 537
Operation Name : Demote database
User : admin
User Name : Main Administration User
Start Time : 01/21 08:48:40
Systems:
[1] db1
Updates:
01/21 08:48:41 [-] Info: Successful demote of table dbtest.dblvl1 on 1 systems
01/21 08:48:41 [-] Info: Successful demote of table dbtest.dblvl2 on 1 systems
01/21 08:48:41 [-] Info: Successful demote of table dbtest.dblvl3 on 1 systems
01/21 08:48:41 [-] Info: Successful demote of table dbtest.dblvl4 on 1 systems
01/21 08:48:41 [-] Info: Successful demote of table dbtest.dblvl5 on 1 systems
01/21 08:48:41 [-] Info: Successful demote of table dbtest.dblvl6 on 1 systems
01/21 08:48:41 [-] Info: Successful demote of table dbtest.dblvl7 on 1 systems
01/21 08:48:41 [-] Info: Successful demote of table dbtest.dblvl8 on 1 systems
01/21 08:48:41 [-] Info: Successful demote of table dbtest.dblvl9 on 1 systems
01/21 08:48:41 [-] Info: Successful demote of table dbtest.dblvl10 on 1 systems
01/21 08:48:41 [-] Info: Operation finished
Status : Finished (1)
Finish Time : 01/21 08:48:41
Systems:
[1] db1 - Finished (1)
unityadmin>