16.10 - SYSTEM REMOVE - 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

Purpose

Removes a Teradata Database system from the Unity-managed configuration.

Syntax

SYSTEM REMOVE tdpid ;

Parameters

tdpid
Unique identifier (TDPID) of a Teradata Database system.

Usage Considerations

  • After you remove a Teradata Database system, the system becomes unavailable to Unity for Read or Write requests.
  • The TDPID that you specify must be valid within Unity. The TDPID must previously be added to Unity.
  • The TDPID cannot be referenced in routing rules. To successfully run this command, first remove all references to the Teradata Database system from the routing rules.
  • The Teradata Database system must be in one of the following states:
    • Disconnected
    • Unrecoverable

Example

The following scenario includes two Active systems, bltor and fast. The example first runs SYSTEM DEACTIVATE to deactivate the system bltor.

SYSTEM DEACTIVATE bltor;
unityadmin> Operation Number : 6
Operation Name   : Deactivating Systems
User             : admin
User Name        : Main Administration User
Start Time       : 10/19 12:51:06
Systems:
    [1] bltor
Updates:
    10/19 12:51:06 [-] Info: Beginning deactivation of systems
    10/19 12:51:06 [-] Info: Resetting system 1 (bltor)
    10/19 12:51:07 [-] Info: Reset system 1 (bltor)
    10/19 12:51:07 [-] Info: Successfully deactivated 1 systems
    10/19 12:51:07 [-] Info: Operation finished
Status      : Finished (1)
Finish Time : 10/19 12:51:07
Systems:
    [1] bltor - Finished (1)

After the command finishes, the system bltor is placed in the Unrecoverable state and ready for removal.

SYSTEM REMOVE bltor;
Successfully removed system 'bltor'.