Purpose
Changes a table or Teradata Database system from Active to Standby state.
Syntax
SYSTEM DEMOTE {tpdid[, ...]} | {database.tablename [ON tpdid [, tpdid...]]} ["reason"];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.
- tdpid
- Unique identifier (TDPID) of a Teradata Database system.
- "reason"
- User description of why the object is having its state changed.
Usage Considerations
You must include a tdpid or databasename.tablename.
If the state change is made for the Teradata Database system, all tables Unity manages on that Teradata Database system become Standby.
In a state change for a table, the table on all Teradata Database systems becomes Standby.
Example
The following example demonstrates placing a Teradata Database system with the TDPID fast in Standby state, followed by running the OPERATION CHECK command to view status.
unityadmin> SYSTEM DEMOTE 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 : Demoting Systems
User : admin
User Name : Main Administration User
Progress (%) : 100
Status : Finished (1)
Start Time : 11/14 17:56:51
Finish Time : 11/14 17:56:52
Systems:
[2] fast - Finished (1)
Updates:
11/14 17:56:52 [-] Info: Demoting selected systems
11/14 17:56:52 [-] Info: Successfully demoted 1 systems
11/14 17:56:52 [-] Info: Operation finished