Purpose
Changes state of a table object to the Read-Only state. The table must be managed by Unity.
Syntax
OBJECT FREEZE {tablename [ON tdpid [, tdpid, ...]]} [ REASON reason];Parameters
- ON
- Change a table on a specific Teradata Database system.
- tdpid
- Unique identifier (TDPID) of a Teradata Database system.
- REASON reason
- User description of why the object is having its state changed.
- tablename
- The fully qualified table name if you are attempting to change the state of a table.
Usage Considerations
- Specify a single table object to mark it Read-Only.
- When a Unity managed table object is frozen across multiple systems, the freeze process completes on each system as the table object on that system becomes current with the freeze point. After a successful operation, the data is the same on each copy of the table object across the systems on which it was frozen.
- If you are making a state change for a Unity managed table object, then the table object on all Teradata Database systems becomes Read-Only. If you are making a state change for a Unity managed table object on a specific Teradata Database system, only the table object on that Teradata Database system becomes Read-Only.
Example
The following example demonstrates placing a table table4 from a Teradata Database temporal_user in Read-Only state.
unityadmin> OBJECT FREEZE temporal_user.table4
The request is currently processing as operation number 9.
Operation Number : 9
Operation Name : Freezing Table
User : admin
User Name : Main Administration User
Progress (%) : 100
Status : Finished (1)
Start Time : 01/14 16:35:49
Finish Time : 01/14 16:35:50
Systems:
[1] bltor - Finished (1)
[2] fast - Finished (1)
Updates:
01/14 16:35:50 [-] Info: Freezing table temporal_user.table4
01/14 16:35:50 [-] Info: Requesting mgmt R lock on 'temporal_user.table4'
01/14 16:35:50 [-] Info: Mgmt R lock on 'temporal_user.table4' granted
01/14 16:35:50 [-] Info: Releasing mgmt R lock on 'temporal_user.table4'
01/14 16:35:50 [-] Info: Successfully froze table on 2 systems
01/14 16:35:50 [-] Info: Operation finished