Purpose
Activates all unrecoverable tables within the specified database on one or more systems in a Unity configuration.
Syntax
DATABASE ACTIVATE {<database>[ON tdpid[,tdpid]]} [REASON'reason'];Parameters
- database
- Name of database holding tables currently in Data Dictionary.
- tdpid
- Unique identifier (TDPID) of a Teradata Database system.
- reason
- Reason why objects on the database need to change.
Usage Considerations
Use this command after adding a new database using the Data Dictionary Scanner to make all tables within the added database Active.
Only tables that are unrecoverable on all systems can be activated. Any tables that are not unrecoverable on the system they are managed will be skipped.
Example
The following example shows how to activate a Teradata Database system.
unityadmin> database activate dbtest;
Operation Number : 535
Operation Name : Activate database
User : admin
User Name : Main Administration User
Start Time : 01/21 08:45:37
Updates:
01/21 08:45:37 [-] Info: Successfully activated table 'dbtest.dblvl1' on 2 systems.
01/21 08:45:37 [-] Info: Successfully activated table 'dbtest.dblvl2' on 2 systems.
01/21 08:45:37 [-] Info: Successfully activated table 'dbtest.dblvl3' on 2 systems.
01/21 08:45:37 [-] Info: Successfully activated table 'dbtest.dblvl4' on 2 systems.
01/21 08:45:37 [-] Info: Successfully activated table 'dbtest.dblvl5' on 2 systems.
01/21 08:45:37 [-] Info: Successfully activated table 'dbtest.dblvl6' on 2 systems.
01/21 08:45:37 [-] Info: Successfully activated table 'dbtest.dblvl7' on 2 systems.
01/21 08:45:37 [-] Info: Successfully activated table 'dbtest.dblvl8' on 2 systems.
01/21 08:45:37 [-] Info: Successfully activated table 'dbtest.dblvl9' on 2 systems.
01/21 08:45:37 [-] Info: Successfully activated table 'dbtest.dblvl10' on 2 systems.
01/21 08:45:37 [-] Info: Operation finished
Status : Finished (1)
Finish Time : 01/21 08:45:37
unityadmin>