16.10 - OBJECT FREEZE - Teradata Unity

Teradata Unity User Guide

Product
Teradata Unity
Release Number
16.10
Published
January 2018
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
anz1496162519675.ditamap
dita:ditavalPath
ft:empty

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