Purpose
Displays attributes of the database with which TDP is communicating.
Syntax
The DI and DIS abbreviations are deprecated.
where:
- FEATURES
- Indicates that a list of all internal database features provided to TDP is to be displayed.
- CHARSETS
- Indicates that a list of all character sets supported by the database is to be displayed.
Usage Notes
The following information is always displayed:
- The Logical-host in hexadecimal and its decimal equivalent
- The default character set (a question mark is substituted if for some reason the name cannot be ascertained)
- The release and version
- The default transaction semantics
- The numeric parallelism factor
- The numeric values for the maximum segment number and maximum segment size.
The following information might be displayed, depending on the options specified in the command:
- FEATURES, which is a list of names of the feature information. The usefulness of this information depends upon knowledge of TDP internals; it is intended for use in consultation with Teradata customer support personnel.
- CHARSETS, which is the character set name and corresponding numeric code for each character set
Example: DISPLAY QUEUES
DISPLAY SERVER
Completion Message
TDP2040 SERVER INFORMATION TDP2041 LOGICAL-HOST X'00FA' (250), DEFAULT CHARSET: EBCDIC TDP2045 RELEASE: 14.00.00.00, VERSION 14.00.00.00 TDP2042 DEFAULT TRANSACTION SEMANTICS: T TDP2043 PARALLELISM FACTOR: 8 TDP2044 SEGMENT MAXIMUMS: NUMBER(0), SIZE(0)