Category: Operations
Database: DBC
| View Column | Data Type | Format | Description |
|---|---|---|---|
| LogicalHostId | SMALLINT NOT NULL | ---,--9 | 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. Session identifier of the session that had the in-doubt transaction. |
| CoordTaskId | VARBYTE(30) NOT NULL | X(60) | Coordinator ID of the in-doubt session. |
| RunUnitId | VARBYTE(30) NOT NULL | X(60) | Identity of the run unit that had the in-doubt transaction. |
| LogonUserName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | ID of the user who ran the in-doubt transaction. |
| ResolvingUserLogonName | VARCHAR(128) UNICODE NOT CASESPECIFIC NOT NULL | X(128) | Identity of the user who resolved the in-doubt transaction. |
| CommitOrRollback | CHAR(1) LATIN NOT CASESPECIFIC NOT NULL | X(1) | Indicates whether the in-doubt session was committed (C) or rollbacked (R). |
| UserLogonDate | DATE NOT NULL | YYYY/MM/DD | The date that the specified user logged on. |
| UserLogonTime | FLOAT NOT NULL | 99:99:99 | The time that the specified user logged on. |
| CompletionDate | DATE NOT NULL | YYYY/MM/DD | The time the in-doubt session was resolved. |
| CompletionTime | FLOAT NOT NULL | 99:99:99 | The time the in-doubt session was resolved. |
| Options | CHAR(1) LATIN NOT CASESPECIFIC | X(1) | Initialized to NULL. Not used by system. You may update this one-character column to suit your needs. |