17.00 - QryLogExceptionsV - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Advanced SQL Engine
Teradata Database
June 2020
Programming Reference

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.