DATABASE FREEZE - Teradata Unity

Teradata® Unity™ User Guide

Product
Teradata Unity
Release Number
16.20
Published
May 2019
Language
English (United States)
Last Update
2019-05-23
dita:mapPath
dzf1517499323110.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

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