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

Displays information for the specified Teradata Database system.

The command also identifies the non-optimal Active Dispatcher in the current configuration. This occurs if a Dispatcher is Active, but the system region and Dispatcher region ID are not the same, and the Dispatcher for the system that matches the system region is available. The message, "WARNING: Active Dispatcher is not local to the system" displays after the non-optimal Dispatcher in the output.

Syntax

SYSTEM DESCRIBE [-lcd] [tdpid, ...];

Parameters

-lcd
Lists the Teradata Database systems you specify in order by lowest common denominator. When not set, the Teradata Database systems list in order by TDPID.
tdpid
Unique identifier (TDPID) of a Teradata Database system.

Example

The following example shows the Teradata Database systems two systems.

unityadmin>  SYSTEM DESCRIBE; 
System ID              : 1
System TDP ID          : jasonu2
Region ID              : 1
Region Name            : region1
State                  : Active
System DBS Release     : 15.00.00.04
System DBS Version     : 15.00.00.04
System PE Count        : 2
System AMP Count       : 4
Character sets         : UTF16
                         UTF8
                         ASCII - default
                         EBCDIC
    Dispatcher 1:
      Name                   : region2_dsp_jasonu2
      System Region ID       : 1
      System Region Name     : region1
      Dispatcher Region ID   : 2
      Dispatcher Region Name : region2
      Is Active              : 0
      System Connectivity    : Process is UP (standby), Connected to system
    Dispatcher 2:
      Name                   : region1_dsp_jasonu2
      System Region ID       : 1
      System Region Name     : region1
      Dispatcher Region ID   : 1
      Dispatcher Region Name : region1
      Is Active              : 1
      System Connectivity    : Process is UP (active), Connected to system

---------------------------------------------
System ID              : 2
System TDP ID          : jasonu4
Region ID              : 2
Region Name            : region2
State                  : Active
System DBS Release     : 15.00.00.04
System DBS Version     : 15.00.00.04
System PE Count        : 2
System AMP Count       : 4
Character sets         : UTF16
                         UTF8
                         ASCII - default
                         EBCDIC
    Dispatcher 1:
      Name                   : region2_dsp_jasonu4
      System Region ID       : 2
      System Region Name     : region2
      Dispatcher Region ID   : 2
      Dispatcher Region Name : region2
      Is Active              : 0
      System Connectivity    : Process is UP (standby), Connected to system
    Dispatcher 2:
      Name                   : region1_dsp_jasonu4
      System Region ID       : 2
      System Region Name     : region2
      Dispatcher Region ID   : 1
      Dispatcher Region Name : region1
      Is Active              : 1
      System Connectivity    : Process is UP (active), Connected to system