Category: Operations
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| LogDate | DATE NOT NULL | YYYY/MM/DD | The date that the access log entry was made. |
| LogTime | FLOAT NOT NULL | 99:99:99.99 | The time of day that the event occurred as HH:MM:SS. |
| UserName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | 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. |
| Event | CHAR(12) LATIN NOT CASESPECIFIC NOT NULL | X(12) | Description of the type of action, using the following descriptions: Logon, Logoff, Logon failed. |
| 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 | The vproc number of the PE through which the session was connected or assigned. |
| SessionNo | INTEGER NOT NULL | --,---,---,--9 | Session identifier assigned to the session by the TDP or LAN interface. |
| LogonDate | DATE NOT NULL | YYYY/MM/DD | The date that the session for which the log entry was made was logged on to the database system. |
| LogonTime | FLOAT NOT NULL | 99:99:99.99 | 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 return 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 standard text representation of the IP address where the user accessed the system. |
| ClientProgramName | VARCHAR(1024) UNICODE NOT CASESPECIFIC | X(1024) | The client system program name. |
| ClientSystemUserId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The client user id. |
| ClientConnectionType | BYTEINT | -(3)9 | Specifies 1 for TCP/IP or 2 for Channel connect. |
| ClientCoordName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The name for clients using CICS or IMS. |
| ClientEnvName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The TDP environment name. |
| ClientJobId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The TDP job ID. |
| ClientJobName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The TDP job name. |
| ClientOsName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The TDP Operating System name. |
| ClientProcThreadId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The client process/thread identifier. |
| ClientSecProdGrp | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The TDP security product group. |
| ClientSecProdUserId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The TDP security product user id. |
| ClientTcpPortNumber | INTEGER | --,---,---,--9 | The TCP port number on the client system. |
| ClientTdHostName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The Teradata hostname that the client used to connect to the database system. |
| ClientTerminalId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The TDP terminal identifier. |
| ClientTransactionId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The TDP transaction identifier. |
| ClientUserOperId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The TDP user/operator identifier. |
| ClientVmName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The TDP virtual machine name. |
| ClientVmUserId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The TDP virtual machine user ID. |
| MechanismName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The authentication method used to authenticate the user. |
| ClientTDPReleaseId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The TDP release identifier. |
| ClientCLIv2ReleaseId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The CLIv2 release identifier. |
| ClientSessionDesc | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The TDP session description. |
| ClientWorkload | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The TDP workload. |
| ClientJobData | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The client job data from the LSINFO environmental variable. |
| ClientODBCDriverVersion | VARCHAR(16) UNICODE NOT CASESPECIFIC | X(16) | The client ODBC driver version. |
| ClientNetDataProviderVersion | VARCHAR(16) UNICODE NOT CASESPECIFIC | X(16) | The client .NET data provider version. |
| ClientODBCDriverManagerVersion | CHAR(30) UNICODE NOT CASESPECIFIC | X(30) | The client ODBC driver manager version. |
| ClientNetFrameworkVersion | CHAR(30) UNICODE NOT CASESPECIFIC | X(30) | The client .NET framework version. |
| ClientAttributesEx | VARCHAR(512) UNICODE NOT CASESPECIFIC | X(512) | 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 client JDBC driver version. |
| ClientJavaVersion | VARCHAR(30) UNICODE NOT CASESPECIFIC | X(30) | The client Java framework version. |
| RecoverableNetworkProtocol | CHAR(1) LATIN UPPERCASE NOT NULL | X(1) | 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 Nam.e |
| 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) | Contains the user's network confidentiality policy that applies on the connection between the client and the gateway or between the client and Unity, 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, looked up in the LDAP directory used for security policy. |
| 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, 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, looked up in the LDAP directory used for security policy. |
| 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. |
| ProxyLogon | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Indicates T if logon request uses Passwordless Proxy for TD2. |
| ErrorCode | SMALLINT | -(5)9 | The error code returned by Logon Failure parcels. |
| ErrorMsg | VARCHAR(256) UNICODE NOT CASESPECIFIC | X(256) | The error message returned by Logon Failure parcels. |
| ClientConfType | CHAR(1) LATINC | X(1) | The Client Confidentiality Type. |
| ServerConfType | CHAR(1) LATINC | X(1) | The Server Confidentiality Type. |
| UnityConfType | CHAR(1) LATINC | X(1) | The Unity Confidentiality Type. |
| ServerUnityConfType | CHAR(1) LATINC | X(1) | The Server Unity Confidentiality Type. |
| ClientConfVersion | VARCHAR(16) LATIN NOT CASESPECIFIC | X(16) | The Client TLS version number. |
| ClientConfCipherSuite | VARCHAR(64) LATIN NOT CASESPECIFIC | X(64) | The Client TLS cipher suite. |
| UnityConfVersion | VARCHAR(16) LATIN NOT CASESPECIFIC | X(16) | The Unity TLS version number. |
| UnityConfCipherSuite | VARCHAR(64) LATIN NOT CASESPECIFIC | X(64) | The Unity TLS cipher suite. |