DATABASE 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
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.