17.10 - Usage Notes - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Programming Reference
Publication ID
B035-1092-171K
Language
English (United States)

DBC.QryLogClientAttrV is used to obtain client attributes for each request. Previously DBC.DBQLogTbl had limited client attributes. DBC.QryLogClientAttrV represents a one-to-many relation between DBC.EventLog and DBC.DBQLogTbl for the queries logged under DBQL default logging. It is recommended to use this view to get an accurate and rich set of client attributes for each request.

ClientConfCipherSuite and UnityConfCipherSuite

ASCII String representing the confidentiality cipher suite. Currently, this is the TLS cipher suite, for example: "TLS_AES_256_GCM_SHA384".

ClientConfVersion and UnityConfVersion

ASCII String representing the confidentiality version number. Currently, this is the TLS version number, for example: "TLS 1.2".

Possible Values for ClientConfType

Value Description
C TLS used for encryption. Client validated the Certificate-Authority chain but ignored the Subject-Alternative-Name and the Common-Name.
E TDGSS used for encryption. The application does not have the option to change this during the session.
F TLS was attempted but failed, so this is a fallback to using TDGSS for encryption because ENCRYPTDATA is specified.
H TLS was attempted but failed, so this is a fallback to unencrypted because ENCRYPTDATA is not specified.
O May be encrypted using TDGSS or unencrypted. The application has the option of changing this at any time. This is possible only with CLIv2 apps, because drivers (e.g. ODBC, JDBC) do not toggle encryption on and off within a session.
R TLS used for encryption. Server certificate was ignored; client did not validate the identity of the server.
U Unencrypted. The application does not have the option to change this during the session.
V TLS used for encryption. Client validated the Certificate-Authority chain and the Subject-Alternative-Name or the Common-Name.

Possible Values for ProxyLogon

Value Description
T The ProxyLogon column indicates if Unity has logged a user onto a TD2 session using existing credentials, when that user was successfully logged on by another Unity-managed Vantage system using TD2. When this occurs, ProxyLogon is set to T.
F False indicates the TD2 session logged on or attempted to log on with a valid password.

Possible Values for ServerConfType

Value Description
E TDGSS used for encryption, either enforced by policy or asserted by a Client.
O May be encrypted using TDGSS or unencrypted, as asserted by a Client, or because it cannot be determined.
T TLS used for encryption.
U Unencrypted, as asserted by a Client Interface.

Possible Values for ServerUnityConfType

Value Description
E TDGSS used for encryption, either enforced by policy or asserted by Unity.
O May be encrypted using TDGSS or unencrypted. Cannot be determined by the gateway.
T TLS used for encryption.
U Unencrypted, as asserted by Unity.

Possible Values for UnityConfType

Value Description
E TDGSS used for encryption.
F TLS was attempted but the handshake failed, so this is an attempt to fallback to using TDGSS for encryption. This is otherwise equivalent to "E".
T TLS used for encryption.
U Unencrypted.