17.00 - LogOnOffV[X] - 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: Operations

Database: DBC

View Column Data Type Format Comment
LogDate DATE NOT NULL YY/MM/DD Returns the date that the access log entry was made.
LogTime FLOAT NOT NULL 99:99:99.99 Returns the time of day that the event occurred as HH:MM:SS.
UserName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the username associated with the event.
AccountName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Expanded account in effect when a request was submitted. SYSTEMACCOUNTNO tracks console utility activity such as table rebuild, Diskcopy, or Scandisk.
Event CHAR(12) LATIN NOT CASESPECIFIC NOT NULL X(12) Returns a description of the type of action, using the following descriptions: Logon, Logoff, Logon failed.
LogicalHostId SMALLINT NOT NULL -(5)9 Returns a unique identifier of the logon source for the logged query. A value of zero indicates an internal session.
IFPNo SMALLINT NOT NULL -(5)9 Returns the 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 Returns 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 Returns the time on which logon for the session occurred (useful on logoff events).
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.
ClientIpAddress VARCHAR(45) UNICODE NOT CASESPECIFIC X(45) The 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) The ClientProgramName is the client system program name
ClientSystemUserId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientSystemUserId is the client user id
ClientConnectionType BYTEINT -(3)9 The ClientConnectionType is 1 for TCP/IP or 2 for Channel connect
ClientCoordName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientCoordName is the Coordinator name for clients using CICS or IMS
ClientEnvName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientEnvName is the TDP Environment Name
ClientJobId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientJobId is the TDP Job ID
ClientJobName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientJobName is the TDP Job Name
ClientOsName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientOsName is the TDP Operating System Name
ClientProcThreadId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientProcThreadId is the client process/thread identifier
ClientSecProdGrp VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientSecProdGrp is the TDP Security Product Group
ClientSecProdUserId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientSecProdUserId is TDP Security Product Userid
ClientTcpPortNumber INTEGER --,---,---,--9 The ClientTcpPortNumber is the TCP port number on the client system
ClientTdHostName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientTdHostName is the Teradata Database hostname that the client used to connect to the Teradata Database
ClientTerminalId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientTerminalId is TDP Terminal Identifier
ClientTransactionId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientTransactionId is TDP Transaction Identifier
ClientUserOperId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientUserOperId is the TDP User/Operator Identifier
ClientVmName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientVmName is the TDP Virtual Machine Name
ClientVmUserId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientVmUserId is the TDP Virtual Machine User Id
MechanismName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The MechanismName is authentication method used to authenticate the user
ClientTDPReleaseId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientTDPReleaseId is the TDP Release Identifier
ClientCLIv2ReleaseId VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientCLIv2ReleaseId is the CLIv2 Release Identifier
ClientSessionDesc VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientSessionDesc is the TDP session description
ClientWorkload VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientWorkload is the TDP Workload
ClientJobData VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) The ClientJobData is the client Job Data from the LSINFO environmental variable
ClientODBCDriverVersion VARCHAR(16) UNICODE NOT CASESPECIFIC X(16) The ClientODBCDriverVersion is the client ODBC Driver Version
ClientNetDataProviderVersion VARCHAR(16) UNICODE NOT CASESPECIFIC X(16) The ClientNetDataProviderVersion is the client .NET Data Provider Version
ClientODBCDriverManagerVersion CHAR(30) UNICODE NOT CASESPECIFIC X(30) The ClientODBCDriverManagerVersion is the client ODBC Driver Manager Version
ClientNetFrameworkVersion CHAR(30) UNICODE NOT CASESPECIFIC X(30) The ClientNetFrameworkVersion is the client .NET Frameword Version
ClientAttributesEx VARCHAR(512) UNICODE NOT CASESPECIFIC X(512) The ClientAttributesEx field contains extra description of the client that do not match any of the other Client Attributes fields
ClientJDBCDriverVersion VARCHAR(16) UNICODE NOT CASESPECIFIC X(16) The ClientJDBCDriverVersion is the client JDBC Driver Version
ClientJavaVersion VARCHAR(30) UNICODE NOT CASESPECIFIC X(30) The ClientJavaVersion is the client Java Framework Version
RecoverableNetworkProtocol CHAR(1) LATIN UPPERCASE NOT NULL X(1) The RecoverableNetworkProtocol column indicates whether the client supports the RecoverableNetwork client-database interface.
LogonRedrive VARCHAR(33) UNICODE NOT CASESPECIFIC X(33) This field is reserved for future use.
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) Server IP Address by Unity
ServerPortByUnity INTEGER --,---,---,--9 Server Port by Unity
ServerIPAddrByServer VARCHAR(45) UNICODE NOT CASESPECIFIC X(45) Server IP Address by Server
ServerPortByServer INTEGER --,---,---,--9 Server Port by Server
ClientCOPSuffixedHostName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Client COP Suffixed Hostname
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) User Authenticated by
ClientTDSessionPoolName VARCHAR(128) UNICODE NOT CASESPECIFIC X(128) Client TD Session Pool Name
UnityTcpPortNumber INTEGER --,---,---,--9 Unity TCP Port Number
UnityIpAddress VARCHAR(45) UNICODE NOT CASESPECIFIC X(45) Unity IP Address
SecurityPolicy VARCHAR(256) UNICODE NOT CASESPECIFIC X(256) Security Policy
UnitySecurityPolicy VARCHAR(256) UNICODE NOT CASESPECIFIC X(256) Unity Security Policy
Unity_AuthUser VARCHAR(256) UNICODE NOT CASESPECIFIC X(256) Unity AuthUser
DirUserNetConfidentiality CHAR(1) LATIN NOT CASESPECIFIC X(1) This column 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.
UnityNetConfidentiality CHAR(1) LATIN NOT CASESPECIFIC X(1) This column 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.
EffectiveSessionNetConf CHAR(1) LATIN NOT CASESPECIFIC X(1) This column 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.
ProxyLogon CHAR(1) LATIN NOT CASESPECIFIC X(1) The ProxyLogon column indicates T if logon request uses Passwordless Proxy for TD2.
ErrorCode SMALLINT -(5)9 Identifies the Error Code returned by Logon Failure parcels.
ErrorMsg VARCHAR(256) UNICODE NOT CASESPECIFIC X(256) Identifies the Error message returned by Logon Failure parcels.
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.