Category: Query
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| QueryID | DECIMAL(18,0) NOT NULL | --Z(17)9 | (Foreign Key) Systemwide unique value to join DBQL tables. |
| DateFld | DATE NOT NULL | YYYY/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 | 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 that the session for which the log entry was made was logged on to the database system. |
| 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. |
| 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 BATCH, TSO, CICS, or IMS. |
| 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 MVS. |
| ClientProcThreadId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Processor thread id of client. |
| ClientSecProdGrp | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Client security product group. |
| ClientSecProdUserId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Client security product user ID. |
| ClientTcpPortNumber | INTEGER | --,---,---,--9 | Client 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 CICS or IMS. |
| ClientTransactionId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Transaction identifier as an EBCDIC value, if the environment is CICS or IMS. |
| ClientUserOperId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The user or operator identifier as an EBCDIC value, if the environment is CICS or IMS. |
| ClientVmName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Client virtual machine name. |
| ClientVmUserId | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Client virtual machine 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 system user ID. |
| AuthMethod | BYTEINT | -(3)9 | Authorization method used by client to authorize logon. |
| AuthUser | VARCHAR(256) UNICODE UPPERCASE | X(256) | User LDAP URL, when one of the following is true:
In other cases, the column stores the user logon 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 database system. |
| 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 database system. |
| 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 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. |
| UnityNetCompression | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Reserved for future use. |
| UnityNetConfidentiality | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Contains the user 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. |
| 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) | Client Confidentiality Type. |
| ServerConfType | CHAR(1) LATINC | X(1) | Server Confidentiality Type. |
| UnityConfType | CHAR(1) LATINC | X(1) | Unity Confidentiality Type. |
| ServerUnityConfType | CHAR(1) LATINC | X(1) | Server Unity Confidentiality Type. |
| ClientConfVersion | VARCHAR(16) LATIN NOT CASESPECIFIC | X(16) | Client TLS version number. |
| ClientConfCipherSuite | VARCHAR(64) LATIN NOT CASESPECIFIC | X(64) | Client TLS cipher suite. |
| UnityConfVersion | VARCHAR(16) LATIN NOT CASESPECIFIC | X(16) | Unity TLS version number. |
| UnityConfCipherSuite | VARCHAR(64) LATIN NOT CASESPECIFIC | X(64) | Unity TLS cipher suite. |