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. |