SYSTEM ORDER Command | unityadmin | Teradata Unity - SYSTEM ORDER - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Product
Continuous Availability
Teradata Unity
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2020-09-15
dita:mapPath
fmz1594836948704.ditamap
dita:ditavalPath
qqk1595871525984.ditaval
dita:id
B035-2520
Product Category
Analytical Ecosystem

Purpose

Specifies the order of Teradata Database systems that Unity uses to calculate lowest common denominator (LCD) information.

Syntax

SYSTEM ORDER <tdpid>, <tdpid>[, tdpid, ...];

Parameters

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

Usage Considerations

  • All current Teradata Database systems (use SYSTEM LIST to list all current Teradata Database systems) must be included in the list. For example, if td1, td2 and td3 have been added to Unity, the SYSTEM ORDER command must include all three TDPID values. The SYSTEM ORDER command cannot just specify td1 and td2.
  • Executing this command multiple times overwrites existing information. If changed, the ordering only affects new sessions. Existing sessions already have the LCD information calculated and do not change if this command is run.
  • If this command is not run, the default order of the Teradata Database systems results in the order with which they were added to Unity (using the SYSTEM ADD command, and using the order in which the systems were added during installation).

Example

The following example uses the SYSTEM ORDER to place fast as the first system. You can run the SYSTEM LIST to show the change in system order.

unityadmin>  SYSTEM ORDER fast,bltor; 
Successfully ordered systems.
unityadmin> SYSTEM LIST;
fast, bltor