Usage Notes - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
June 2020
Language
English (United States)
Last Update
2020-10-15
dita:mapPath
yoz1556235523563.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

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.

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.