DATABASE FREEZE Command | unityadmin | Teradata Unity - 17.00 - DATABASE FREEZE - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval

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