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 regionname OVERRIDE ;Parameters
- regionname
- 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'.