SYSTEM ADD - Teradata Unity

Teradata® Unity™ User Guide

Product
Teradata Unity
Release Number
16.20
Published
May 2019
Language
English (United States)
Last Update
2019-05-23
dita:mapPath
dzf1517499323110.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2520
lifecycle
previous
Product Category
Analytical Ecosystem

Purpose

Adds a Teradata Database system to the list of databases available to Unity by adding the appropriate system TDPID. You will also need to add a dispatcher process, modify the unity.properties file, and add the mgmtuser to the system being added.

For Lowest Common Denominator (LCD) purposes, new Teradata Database systems are added to the end of the Teradata Database system list. You can use the SYSTEM ORDER command to change the order.

Syntax

SYSTEM ADD tdpid region_name OVERRIDE ;

Parameters

region_name
Unique character string that identifies a region managed by a Unity server.
tdpid
Unique identifier (TDPID) of a Teradata Database system.
OVERRIDE
Each system is assigned a system serial number. This serial number is stored on the system in a table. The OVERRIDE option overwrites an existing serial number on the system, if one exists.

Example

This example command adds a Teradata system named newSys1 to region2.

unityadmin>  SYSTEM ADD newSys1 region2; 
Successfully added system 'newSys1'.