Purpose
Changes the state of all tables in the specified database from Active to Read-Only.
Syntax
DATABASE FREEZE, <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 change.
Usage Considerations
If a system is not specified when running this command, it sets all tables in the database to Read-only on ALL systems, which is not usually correct. Specify a system to make the tables Read-Only on one system.
Example
unityadmin> database freeze dbtest;
Operation Number : 1
Operation Name : Freeze database
User : admin
User Name : Main Administration User
Start Time : 12/21 06:32:17
Updates:
12/21 06:32:17 [-] Info: Successfully froze table 'dbtest.test0' on 2 systems
12/21 06:32:17 [-] Info: Successfully froze table 'dbtest.test1' on 2 systems
12/21 06:32:17 [-] Info: Successfully froze table 'dbtest.test2' on 2 systems
12/21 06:32:17 [-] Info: Successfully froze table 'dbtest.test3' on 2 systems
12/21 06:32:17 [-] Info: Successfully froze table 'dbtest.test4' on 2 systems
12/21 06:32:17 [-] Info: Successfully froze table 'dbtest.test5' on 2 systems
12/21 06:32:17 [-] Info: Successfully froze table 'dbtest.test6' on 2 systems
12/21 06:32:17 [-] Info: Successfully froze table 'dbtest.test9' on 2 systems
12/21 06:32:17 [-] Info: Successfully froze table 'dbtest.test10' on 2 systems