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. |