Category: Query
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| ProcID | DECIMAL(5,0) NOT NULL | -(5)9 | The process ID of the dispatcher. |
| CollectTimeStamp | TIMESTAMP(6) NOT NULL | YYYY-MM-DDBHH:MI:SS.S(6) | (Prime Key) Time and date when the TDWM exception cache was written. |
| QueryID | DECIMAL(18,0) NOT NULL | --Z(17)9 | System-wide unique ID to identify the query. |
| UserName | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | Name of the user with this exception. |
| SessionID | INTEGER | --,---,---,--9 | The session identifier. |
| RequestNum | INTEGER | --,---,---,--9 | Client request number for all queries. For statements within stored procedure CALL statements, the request number is the same as the CALL. |
| LogicalHostID | SMALLINT | -(5)9 | Unique identifier of the logon source for the logged query. A value of zero indicates an internal session. |
| AcctString | VARCHAR(128) UNICODE NOT CASESPECIFIC | X(128) | The user unexpanded logon account string. |
| WDID | INTEGER | --,---,---,--9 | The workload definition under which the query was classified. |
| OpEnvID | INTEGER | --,---,---,--9 | ID of the operational environment currently activated by TDWM. |
| SysConID | INTEGER | --,---,---,--9 | ID of the system condition currently activated by TDWM. |
| ClassificationTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | The time when the query was classified. |
| ExceptionTime | TIMESTAMP(6) NOT NULL | YYYY-MM-DDBHH:MI:SS.S(6) | The time when the query encountered an exception. |
| ExceptionValue | INTEGER | --,---,---,--9 | Exception type. |
| ExceptionAction | CHAR(10) LATIN NOT CASESPECIFIC | X(10) | The action taken by TDWM on this exception. |
| NewWDID | INTEGER | --,---,---,--9 | Specifies the workload definition into which the query was moved because of exception handling. |
| ExceptionCode | INTEGER NOT NULL | --,---,---,--9 | The error code encountered. |
| ExceptionSubCode | INTEGER | --,---,---,--9 | . |
| ErrorText | VARCHAR(1024) UNICODE NOT CASESPECIFIC | X(1024) | The text from the error if ErrorCode is not 0. |
| ExtraInfo | VARCHAR(200) UNICODE NOT CASESPECIFIC | X(200) | Used to track queries. |
| RuleID | INTEGER | --,---,---,--9 | The rule ID that caused TDWM to reject a query or logon. Note: This field is not populated in all cases. |
| WarningOnly | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Specifies warning code T for true if the error was reported while running TDWM in the warning mode or is not logged at all. A null is found in the field if WarningOnly is not true. |
| RejectionCat | SMALLINT | -(5)9 | The category of TDWM rules that caused this rejection. |