15.10 - QryLogExceptionsV - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Query

DBC

 

View Column

Data Type

Format

Source Table.Column

ProcID

DECIMAL(5,0)

NOT NULL

-(5)9 (explicit)

TDWMExceptionLog.ProcID (Composite NUPI)

CollectTimeStamp

TIMESTAMP(6)

NOT NULL

YYYY-MM-DDBHH:MI:SS

TDWMExceptionLog.BufferTS (Composite NUPI)

QueryID

DECIMAL (18,0)

NOT NULL

--Z(17)9

TDWMExceptionLog.QueryID

UserName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

TDWMExceptionLog.UserName

SessionID

INTEGER

--,---,---,--9 (explicit)

TDWMExceptionLog.SessionID

RequestNum

INTEGER

--,---,---,--9 (explicit)

TDWMExceptionLog.RequestNum

LogicalHostID

SMALLINT

ZZZ9 (explicit)

TDWMExceptionLog.LogicalHostID

AcctString

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

X(128)

TDWMExceptionLog.AcctString (unexpanded)

WDID

INTEGER

--,---,---,--9 (explicit)

TDWMExceptionLog.WDID

OpEnvID

INTEGER

--,---,---,--9 (explicit)

TDWMExceptionLog.OpEnvID

SysConID

INTEGER

--,---,---,--9 (explicit)

TDWMExceptionLog.SysConID

ClassificationTime

TIMESTAMP(6)

YYYY-MMDDBHH:MI:SS.S(F)Z (explicit)

TDWMExceptionLog.ClassificationTime

ExceptionTime

TIMESTAMP(6)

NOT NULL

YYYY-MMDDBHH:MI:SS.S(F)Z (explicit)

TDWMExceptionLog.ExceptionTime

ExceptionValue

INTEGER

--,---,---,--9 (explicit)

TDWMExceptionLog.ExceptionValue

ExceptionAction

CHAR(10) LATIN

NOT CASESPECIFIC

X(10)

TDWMExceptionLog.ExceptionAction

NewWDID

INTEGER

--,---,---,--9 (explicit)

TDWMExceptionLog.NewWDID

ExceptionCode

INTEGER

NOT NULL

--,---,---,--9 (explicit)

TDWMExceptionLog.ExceptionCode

ExceptionSubCode

INTEGER

--,---,---,--9 (explicit)

TDWMExceptionLog.ExceptionSubCode

ErrorText

VARCHAR(1024)

UNICODE

NOT CASESPECIFIC

X(255)

TDWMExceptionLog.ErrorText

ExtraInfo

VARCHAR(200)

UNICODE

NOT CASESPECIFIC

X(200)

TDWMExceptionLog.ExtraInfo

RuleID

INTEGER

--,---,---,--9 (explicit)

TDWMExceptionLog.RuleID

WarningOnly

CHAR(1) LATIN

NOT CASESPECIFIC

X(1)

TDWMExceptionLog.WarningOnly

RejectionCat

SMALLINT

ZZZ9

TDWMExceptionLog.RejectionCat

This view contains entries for:

1 Logons rejected due to the Teradata dynamic workload management software throttle limits

2 Queries rejected due to the Teradata dynamic workload management software object access violations

3 Queries rejected due to the Teradata dynamic workload management software throttle limits if abort option is chosen

4 Queries subject to WD exception handling

For more information about the possible values for the ExceptionValue column, see Appendix A: “View Column Values.”

Possible Values for the ExceptionAction Column

 

Value

Description

A

Abort. Cannot be combined with other actions.

C

Change workload definition (WD). NewWlcId contains the new WD.

L

Log.

E

Execute Program. ExProgram contains the program name.

T

Alert. ExAlert contains the alert name.

N

No action. This option cannot be combined with other actions and disables exception detection.

S

Abort if the statement is a SELECT and no update has been done in the current (user) transaction.

Q

Post to queue table.

Possible Values for RejectionCat

 

Value

Description

1

A rejection due to a TASM Filter rule

2

A rejection due to a TASM Throttle rule

3

A rejection due to a TASM Workload rule

The following SELECT statement retrieves the view for QryLogExceptionsV:

SELECT * from DBC.QryLogExceptionsV;

The query returns the following result:

            ProcID 16383
CollectTimeStamp 2004-06-21 16:38:34.21
        QueryID 201205134619838011
          UserName TEST1
         SessionID ?
        RequestNum ?
     LogicalHostID 1
        AcctString DBC
              WDID ?
           OpEnvID ?
          SysConID ?
ClassificationTime ?
     ExceptionTime 2004-06-21 17:38:34.21
    ExceptionValue ?
   ExceptionAction ?
           NewWDID ?
     ExceptionCode 3,152
  ExceptionSubCode ?
         ErrorText  No access allowed, For all requests, For user TEST1,           
                    Regulation applies from 00:00 to 24:00
         ExtraInfo ?
      RuleID ?
    WarningOnly ?
   RejectionCat ?