InDoubtLogV - Advanced SQL Engine - Teradata Database

Data Dictionary

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
Published
January 2021
Language
English (United States)
Last Update
2021-01-22
dita:mapPath
prb1610499325399.ditamap
dita:ditavalPath
hoy1596145193032.ditaval
dita:id
B035-1092
lifecycle
previous
Product Category
Teradata Vantageā„¢

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) Returns the coordinator that had the in-doubt transaction.
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) The InDoubtLogV.CommitOrRollback 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 The InDoubtLogV.CompletionDate column identifies the date the in-doubt session was resolved.
CompletionTime FLOAT NOT NULL 99:99:99 The InDoubtLogV.CompletionTime 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.