Purpose
Changes all Teradata Database systems or a specified system to the Unrecoverable state.
Syntax
SYSTEM DEACTIVATE | {tpdid[,tpdid, ...]} | {database.tablename [ON tpdid[,tpdid, ...]]};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.
Usage Considerations
Unless a table is specified, running this command sets all tables to Unrecoverable. Specify a single table to mark it Unrecoverable.
Example
The following example demonstrates placing a Teradata Database system with the TDPID bltor in Unrecoverable state, followed by running OPERATION CHECK to view status.
unityadmin> SYSTEM DEACTIVATE bltor;
The request is currently processing as operation number 1.
You may check its status using the command 'operation check 1'.
unityadmin> OPERATION CHECK 1;
Operation Number : 1
Operation Name : Deactivating Systems
User : admin
User Name : Main Administration User
Progress (%) : 100
Status : Finished (1)
Start Time : 11/14 16:03:35
Finish Time : 11/14 16:03:36
Systems:
[1] bltor - Finished (1)
Updates:
11/14 16:03:36 [-] Info: Beginning deactivation of systems
11/14 16:03:36 [-] Info: Resetting system 1 (bltor)
11/14 16:03:36 [-] Info: Reset system 1 (bltor)
11/14 16:03:36 [-] Info: Successfully deactivated 1 systems
11/14 16:03:36 [-] Info: Operation finished