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