15.10 - DeleteOldInDoubtV - 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)

Operations

DBC

 

View Column

Data Type

Format

Source Table.Column

LogicalHostId

SMALLINT

NOT NULL

---,--9 (explicit)

InDoubtResLog.LogicalHostId (Composite NUPI)

SessionNumber

INTEGER

NOT NULL

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

InDoubtResLog.SessionNumber

CoordTaskId

VARBYTE(30)

NOT NULL

X(60)

InDoubtResLog.CoordTaskId (Composite NUPI)

RunUnitId

VARBYTE(30)

NOT NULL

X(60)

InDoubtResLog.RunUnitId (CompositeNUPI)

LogonUserName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

InDoubtResLog.LogonUserName

ResolvingUserLogonName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

InDoubtResLog.ResolvingUserLogonName

CommitOrRollback

CHAR(1) LATIN

NOT CASESPECIFIC

NOT NULL

X(1)

InDoubtResLog.CommitOrRollback

UserLogonDate

DATE

NOT NULL

YY/MM/DD (explicit)

InDoubtResLog.UserLogonDate

UserLogonTime

TIME

NOT NULL

99:99:99 (explicit)

InDoubtResLog.UserLogonTime

CompletionDate

DATE

NOT NULL

YY/MM/DD (explicit)

InDoubtResLog.CompletionDate

CompletionTime

TIME

NOT NULL

99:99:99 (explicit)

InDoubtResLog.CompletionTime

Options

CHAR(1) LATIN

NOT CASESPECIFIC

X(1)

InDoubtResLog.Options

The DeleteOldInDoubt view purges entries from the in-doubt transaction log that are more than 30 days old. Before a delete operation is performed the view may also be used to display information about records eligible for deletion.

Possible Values for CommitOrRollback

 

Value

Description

C

Committed

R

Rolled back

The following statement deletes entries logged against in-doubt transactions that were entered more than 30 days before the current calendar date:

==> DELETE FROM DBC.DeleteOldInDoubtV ALL;

Result:

    DELETE COMPLETED.  5 ROWS REMOVED.