17.00 - DeleteOldInDoubtV - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

Category: Operations

Database: DBC

View Column Data Type Format Comment
LogicalHostId SMALLINT NOT NULL ---,--9 Returns a unique identifier of the logon source for the logged query. A value of zero indicates an internal session.
SessionNumber INTEGER NOT NULL --,---,---,--9 Note: SessionID, SessionNo, and SessionNumber have the same meaning. Returns the session identifier of the session that had the in-doubt transaction.
CoordTaskId VARBYTE(30) NOT NULL X(60) column identifies the coordinator Id of the in-doubt session.
RunUnitId VARBYTE(30) NOT NULL X(60) Returns the identity of the run unit that had the in-doubt transaction.
LogonUserName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the ID of the user who ran the in-doubt transaction.
ResolvingUserLogonName VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL X(128) Returns the identity of the user who resolved the in-doubt transaction.
CommitOrRollback CHAR(1) LATIN NOT CASESPECIFIC NOT NULL X(1) This column identifies whether the in-doubt session was committed (C) or rollbacked (R).
UserLogonDate DATE NOT NULL YY/MM/DD Returns the date that the specified user logged on.
UserLogonTime FLOAT NOT NULL 99:99:99 Returns the time that the specified user logged on.
CompletionDate DATE NOT NULL YY/MM/DD This column identifies the time the in-doubt session was resolved.
CompletionTime FLOAT NOT NULL 99:99:99 This column identifies the time the in-doubt session was resolved.
Options CHAR(1) LATIN NOT CASESPECIFIC X(1) This field is assigned to NULL initially. It is not used by the system and users may update this one-character column to suit their needs.