17.00 - QryLogClientAttrV - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

Category: Query

Database: DBC

View Column Data Type Format Comment
QueryID DECIMAL(18,0) NOT NULL --Z(17)9 (Foreign Key) Systemwide unique value to join DBQL tables.
DateFld DATE NOT NULL YY/MM/DD Date when the event took place.
TimeFld FLOAT NOT NULL 99:99:99.99 Time when the event took place.
UserName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Username associated with the event.
AccountName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Expanded account in effect when a request was submitted.
Event CHAR(12) LATIN NOT CASESPECIFIC NOT NULL X(12) A description of the type of action.
LogicalHostId SMALLINT NOT NULL -(5)9 Unique identifier of the logon source for the logged query. A value of zero indicates an internal session.
IFPNo SMALLINT NOT NULL -(5)9 Vproc number of the PE through which the session was connected or assigned.
SessionNo INTEGER NOT NULL --,---,---,--9 Returns the session identifier assigned to the session by the TDP or LAN interface.
LogonDate DATE NOT NULL YY/MM/DD The date that the session for which the log entry was made was logged on to the Teradata Database
LogonTime FLOAT NOT NULL 99:99:99.99 The time that the session for which the log entry was made was logged on to the Teradata Database.
LogonSource VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Channel-Attached Systems Using the CLIv2 API Returns the origin of the CLIv2 mainframe session being reported,such as the user ID or session number of the client system.
ClientConnectionType BYTEINT -(3)9 Communication type, with the unsigned integer 2 indicating a channel connection.
ClientCoordName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Optional coordinator name as an EBCDIC value.
ClientEnvName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Environment, as an EBCDIC value of NULLBATCHNULL, NULLTSONULL, NULLCICSNULL, or NULLIMSNULL.
ClientJobId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Job id as an EBCDIC value.
ClientJobName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Jobname as an EBCDIC value.
ClientOsName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Canonical operating system designation, with the EBCDIC value NULLMVSNULL.
ClientProcThreadId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) processor thread id of client.
ClientSecProdGrp VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Client's security product group.
ClientSecProdUserId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Client's security product user id.
ClientTcpPortNumber INTEGER --,---,---,--9 Client's TCP/IP port number.
ClientTdHostName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) TDPid as an EBCDIC value.
ClientTerminalId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Terminal identifier as an EBCDIC value, if the environment is NULLCICSNULL or NULLIMSNULL.
ClientTransactionId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Transaction identifier as an EBCDIC value, if the environment is NULLCICSNULL or NULLIMSNULL.
ClientUserOperId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) the user or operator identifier as an EBCDIC value, if the environment is NULLCICSNULL or NULLIMSNULL.
ClientVmName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Client's virtual machine's name.
ClientVmUserId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Client's virtual machine's user id.
MechanismName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Identifies the authentication mechanism used for connections to the data source.
ClientTDPReleaseId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) TDP release as an EBCDIC value.
ClientCLIv2ReleaseId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) CLIv2 release as an EBCDIC value.
ClientSessionDesc VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Optional CLIv2 application Session-desc specification as an EBCDIC value.
ClientWorkload VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Optional CLIv2 application Workload specification as an EBCDIC value.
ClientJobData VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Client Job data.
ClientIpAddress VARCHAR(45) UNICODE NOT CASESPECIFIC X(45) ClientIpAddress column is the standard text representation of the IP address where the user accessed the system.
ClientProgramName VARCHAR(1024) UNICODE NOT CASESPECIFIC X(1024) Application program name as an EBCDIC value.
ClientSystemUserId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Client's system user id.
AuthMethod BYTEINT -(3)9 Authorization method used by client to authorize logon.
AuthUser VARCHAR(256) UNICODE UPPERCASE X(256) The userNULLs LDAP URL, when one of the following is true: LDAP authentication is used or The user is a KRB5 or SPNEGO user that has been authorized using a directory service. In all other cases, the column stores the userNULLs login name.
MechanismOid VARBYTE(32) X(64) Mechanism Object ID.
RFU1 VARCHAR(256) UNICODE NOT CASESPECIFIC X(256) Security Policy.
RFU2 VARCHAR(256) UNICODE NOT CASESPECIFIC X(256) Unity Security Policy.
RFU3 VARCHAR(256) UNICODE NOT CASESPECIFIC X(256) Unity Auth User.
RFU4 VARCHAR(256) UNICODE NOT CASESPECIFIC X(256) Unity Proxy Logon.
RFU5 VARCHAR(256) UNICODE NOT CASESPECIFIC X(256) This field is reserved for future use.
ErrorMsg VARCHAR(256) UNICODE NOT CASESPECIFIC X(256) Identifies the Error message returned by Logon Failure parcel.
ClientInterfaceKind VARCHAR(1) UNICODE NOT CASESPECIFIC X(1) ClientInterfaceKind column stores the type of interface.
ClientInterfaceVersion VARCHAR(16) UNICODE NOT CASESPECIFIC X(16) Version of the interface used by the client application to establish the session to Teradata Database.
ClientAttributesEx VARCHAR(512) UNICODE NOT CASESPECIFIC X(512) Version of the client ODBC Driver Manager used by the client application to establish the session to Teradata Database.
RecoverableNetworkProtocol CHAR(1) LATIN UPPERCASE NOT NULL X(1) Indicates whether the client supports the RecoverableNetwork client-database interface.
LogonRedrive CHAR(2) LATIN UPPERCASE NOT NULL X(2) Indicates the sessions participation in Redrive.
ClientIPAddrByClient VARCHAR(45) UNICODE NOT CASESPECIFIC X(45) Client IP Address by Client.
ClientPortByClient INTEGER --,---,---,--9 Client Port by Client.
ServerIPAddrByClient VARCHAR(45) UNICODE NOT CASESPECIFIC X(45) Serve IP Address by Client.
ServerPortByClient INTEGER --,---,---,--9 Server Port by Client.
ClientIPAddrByUnity VARCHAR(45) UNICODE NOT CASESPECIFIC X(45) Client IP Address by Unity.
ClientPortByUnity INTEGER --,---,---,--9 Client Port by Unity.
UnityClientSideIPAddr VARCHAR(45) UNICODE NOT CASESPECIFIC X(45) Unity Client Side IP Address.
UnityClientSidePort INTEGER --,---,---,--9 Unity Client Side Port.
UnityServerSideIPAddr VARCHAR(45) UNICODE NOT CASESPECIFIC X(45) Unity Server Side IP Address.
UnityServerSidePort INTEGER --,---,---,--9 Unity Server Side Port.
ServerIPAddrByUnity VARCHAR(45) UNICODE NOT CASESPECIFIC X(45) Serve IP Address by Unity.
ServerPortByUnity INTEGER --,---,---,--9 Server Port by Unity.
ServerIPAddrByServer VARCHAR(45) UNICODE NOT CASESPECIFIC X(45) Serve IP Address by Server.
ServerPortByServer INTEGER --,---,---,--9 Server Port by Server.
ClientCOPSuffixedHostName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) This field is reserved for future use.
UnitySessNo INTEGER --,---,---,--9 Unity Session Number.
UnityVersion VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Unity Version.
UnityAuthMechName VARCHAR(1571) UNICODE NOT CASESPECIFIC X(1571) Unity Authorized Mechanism Name.
UnityMechanismName VARCHAR(1571) UNICODE NOT CASESPECIFIC X(1571) Unity Mechanism Name.
UserAuthenticatedBy VARCHAR(1) UNICODE NOT CASESPECIFIC X(1) This field is reserved for future use.
ClientTDSessionPoolName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Client TD Session Pool Name.
UnityAuthUser VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Reserved for future use.
UnityTcpPortNumber INTEGER --,---,---,--9 Reserved for future use.
UnityIpAddress VARCHAR(45) UNICODE NOT CASESPECIFIC X(45) Reserved for future use.
NegotiatingMechanismOid VARBYTE(32) X(64) Reserved for future use.
NegotiatingMechanismName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Reserved for future use.
DirUserNetCompression CHAR(1) LATIN NOT CASESPECIFIC X(1) Reserved for future use.
DirUserNetConfidentiality CHAR(1) LATIN NOT CASESPECIFIC X(1) Contains the user's network confidentiality policy that applies on the connection between the client and the gateway or between the client and Unity, obtained from the LDAP directory used for security policy.
DirUserNetPolicyLevel CHAR(1) LATIN NOT CASESPECIFIC X(1) When DirUserNetConfidentiality is "I" or "C", this column contains the level of protection required, obtained by lookup in the LDAP directory used for security policy.
UnityNetCompression CHAR(1) LATIN NOT CASESPECIFIC X(1) Reserved for future use.
UnityNetConfidentiality CHAR(1) LATIN NOT CASESPECIFIC X(1) Contains the user's network confidentiality policy that applies on the connection between Unity and the gateway, obtained from the LDAP directory used for security policy.
UnityNetPolicyLevel CHAR(1) LATIN NOT CASESPECIFIC X(1) When UnityNetConfidentiality is "I" or "C", this column contains the level of protection required, obtained by lookup in the LDAP directory used for security policy.
DirProfileNetCompression CHAR(1) LATIN NOT CASESPECIFIC X(1) Reserved for future use.
DirProfileNetConfidentiality CHAR(1) LATIN NOT CASESPECIFIC X(1) Reserved for future use.
DirProfileNetPolicyLevel CHAR(1) LATIN NOT CASESPECIFIC X(1) Reserved for future use.
DirNetGroupNetCompression CHAR(1) LATIN NOT CASESPECIFIC X(1) Reserved for future use.
DirNetGroupNetConfidentiality CHAR(1) LATIN NOT CASESPECIFIC X(1) Reserved for future use.
DirNetGroupNetPolicyLevel CHAR(1) LATIN NOT CASESPECIFIC X(1) Reserved for future use.
HostIdNetCompression CHAR(1) LATIN NOT CASESPECIFIC X(1) Reserved for future use.
HostIdNetConfidentiality CHAR(1) LATIN NOT CASESPECIFIC X(1) Reserved for future use.
HostIdNetPolicyLevel CHAR(1) LATIN NOT CASESPECIFIC X(1) Reserved for future use.
UserProfileNetCompression CHAR(1) LATIN NOT CASESPECIFIC X(1) Reserved for future use.
UserProfileNetConfidentiality CHAR(1) LATIN NOT CASESPECIFIC X(1) Reserved for future use.
UserProfileNetworkConfLevel CHAR(1) LATIN NOT CASESPECIFIC X(1) Reserved for future use.
UserNetCompression CHAR(1) LATIN NOT CASESPECIFIC X(1) Reserved for future use.
UserNetConfidentiality CHAR(1) LATIN NOT CASESPECIFIC X(1) Reserved for future use.
UserNetPolicyLevel CHAR(1) LATIN NOT CASESPECIFIC X(1) Reserved for future use.
EffectiveSessionNetCompression CHAR(1) LATIN NOT CASESPECIFIC X(1) Reserved for future use.
EffectiveSessionNetConf CHAR(1) LATIN NOT CASESPECIFIC X(1) Contains the effective network confidentiality policy for the session, that applies on the connection between the client and the gateway or between the client and Unity, integrated from all sources of security policy that do not change.
EffectiveSessionNetPolicyLevel CHAR(1) LATIN NOT CASESPECIFIC X(1) When EffectiveSessionNetConfidentiality is "I" or "C", this column contains the level of protection required, integrated from all sources of security policy that do not change within a session.
ZoneId BYTE(4) NOT NULL X(8) ID of the zone, the user belongs to.
ErrorCode SMALLINT -(5)9 Identifies the Error Code returned by Logon Failure parcel.
ProxyLogon CHAR(1) LATIN NOT CASESPECIFIC X(1) The ProxyLogon column indicates T if logon request uses Passwordless Proxy for TD2.
ClientReconnectTimeout INTEGER --,---,---,--9 Reserved for future use.
GtwVproc SMALLINT ---,--9 Reserved for future use.
ClientConfType CHAR(1) LATINC X(1) The ClientConfType column indicates Client Confidentiality Type.
ServerConfType CHAR(1) LATINC X(1) The ServerConfType column indicates Server Confidentiality Type.
UnityConfType CHAR(1) LATINC X(1) The UnityConfType column indicates Unity Confidentiality Type.
ServerUnityConfType CHAR(1) LATINC X(1) The ServerUnityConfType column indicates Server Unity Confidentiality Type.
ClientConfVersion VARCHAR(16) LATIN NOT CASESPECIFIC X(16) The ClientConfVersion column indicates Client TLS version number.
ClientConfCipherSuite VARCHAR(64) LATIN NOT CASESPECIFIC X(64) The ClientConfCipherSuite column indicates Client TLS cipher suite.
UnityConfVersion VARCHAR(16) LATIN NOT CASESPECIFIC X(16) The UnityConfVersion column indicates Unity TLS version number.
UnityConfCipherSuite VARCHAR(64) LATIN NOT CASESPECIFIC X(64) The UnityConfCipherSuite column indicates Unity TLS cipher suite.