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