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