SYSTEM FREEZE Command | bcmadmin | Teradata Business Continuity Manager - SYSTEM FREEZE - Teradata Business Continuity Manager

Teradata® Business Continuity Manager User Guide - 2.00

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Teradata Business Continuity Manager
Release Number
2.00
Published
August 2024
ft:locale
en-US
ft:lastEdition
2025-01-31
dita:mapPath
sko1694443904278.ditamap
dita:ditavalPath
ft:empty
dita:id
otc1639627713801
lifecycle
latest
Product Category
Analytical Ecosystem

Purpose

Changes a database system or table from Active state to Read-Only state.

Syntax

SYSTEM FREEZE {tdpid[,tpdid,...]} | {database.tablename [ON tdpid[,tpdid,...]]} ["reason"];

Parameters

database.tablename
Name of a database and table currently in the Business Continuity Manager Data Dictionary. The table name that you specify must be fully qualified.
tdpid
Unique identifier (TDPID) of a database system.
"reason"
User description of why the object is having its state changed.

Usage Considerations

Unless a table is specified, running this command sets all tables to Read-Only. Specify a single table to mark it Read-Only.

If making a state change for a specific table, then the table on all database systems becomes Read-Only.

Example

The following example demonstrates placing a database system with the TDPID fast in Read- Only state.

bcmadmin>  system freeze fast; 
The request is currently processing as operation number 3.
You may check its status using the command 'operation check 3'.
bcmadmin> operation check 3;
Operation Number : 3
Operation Name   : Freezing Systems
User             : admin
User Name        : Main Administration User
Progress (%)     : 0
Status           : In Progress (0)
Start Time       : 01/09 12:49:47
Finish Time      : 12/31 16:00:00
Systems:
    [2] fast - Pending (2)
Updates:
    01/09 12:49:48 [-] Info: Freezing selected systems