Purpose
Changes a Teradata Database system or table from Active state to Read-Only state.
Syntax
SYSTEM FREEZE {tpdid[,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
Unless a table is specified, running this command sets all tables to Read-Only. Specify a single table to mark it Read-Only.
If making a state change for a specific table, then the table on all Teradata Database systems becomes Read Only.
Example
The following example demonstrates placing a Teradata Database system with the TDPID fast in Read Only state.
unityadmin> system freeze fast;
The request is currently processing as operation number 3.
You may check its status using the command 'operation check 3'.
unityadmin> operation check 3;
Operation Number : 3
Operation Name : Freezing Systems
User : admin
User Name : Main Administration User
Progress (%) : 0
Status : In Progress (0)
Start Time : 01/09 12:49:47
Finish Time : 12/31 16:00:00
Systems:
[2] fast - Pending (2)
Updates:
01/09 12:49:48 [-] Info: Freezing selected systems