SYSTEM DEACTIVATE Command | bcmadmin | Teradata Business Continuity Manager - SYSTEM DEACTIVATE - 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
Product Category
Analytical Ecosystem

Purpose

Changes all database systems or a specified system to the Unrecoverable state.

Syntax

SYSTEM DEACTIVATE | {tpdid[,tpdid, ...]} | {database.tablename [ON tpdid[,tpdid, ...]]};

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.

Usage Considerations

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

Example

The following example demonstrates placing a database system with the TDPID bltor in Unrecoverable state, followed by running OPERATION CHECK to view status.

bcmadmin>  SYSTEM DEACTIVATE bltor; 
The request is currently processing as operation number 1.
You may check its status using the command 'operation check 1'.
bcmadmin> OPERATION CHECK 1;
Operation Number : 1
Operation Name   : Deactivating Systems
User             : admin
User Name        : Main Administration User
Progress (%)     : 100
Status           : Finished (1)
Start Time       : 11/14 16:03:35
Finish Time      : 11/14 16:03:36
Systems:
    [1] bltor - Finished (1)
Updates:
    11/14 16:03:36 [-] Info: Beginning deactivation of systems
    11/14 16:03:36 [-] Info: Resetting system 1 (bltor)
    11/14 16:03:36 [-] Info: Reset system 1 (bltor)
    11/14 16:03:36 [-] Info: Successfully deactivated 1 systems
    11/14 16:03:36 [-] Info: Operation finished