Category: Query
Database: DBC
View Column | Data Type | Format | Comment |
---|---|---|---|
ProcID | DECIMAL(5,0) NOT NULL | -(5)9 | Returns 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 | Returns a 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 | Returns 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 | Returns a 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) | Returns the user unexpanded logon account string. |
WDID | INTEGER | --,---,---,--9 | Returns the workload definition under which the query was classified. |
OpEnvID | INTEGER | --,---,---,--9 | Returns the ID of the operational environment currently activated by TDWM. |
SysConID | INTEGER | --,---,---,--9 | Returns the ID of the system condition currently activated by TDWM. |
ClassificationTime | TIMESTAMP(6) | YYYY-MM-DDBHH:MI:SS.S(6) | Returns the time when the query was classified. |
ExceptionTime | TIMESTAMP(6) NOT NULL | YYYY-MM-DDBHH:MI:SS.S(6) | Returns 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 | Returns the error code encountered. |
ExceptionSubCode | INTEGER | --,---,---,--9 | . |
ErrorText | VARCHAR(1024) UNICODE NOT CASESPECIFIC | X(1024) | Returns 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 | Returns 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) | Returns warning code T for true if the error was reported while running TDWM in the warning mode, or it is not logged at all. A null is found in the field if WarningOnly is not true. |
RejectionCat | SMALLINT | -(5)9 | Contains the category of TDWM rules that caused this rejection. |