Transaction log extended information
(DBNAME)
| Name | Data Type | Description |
|---|---|---|
| DBNAME | string(32) | Database name |
| FIRST_LOG_PAGE | long | Page # of the first log page |
| LAST_LOG_PAGE | long | Page # of the last log page |
| STP_PAGE | long | Page # of the secondary truncation point (STP) |
| CHECKPOINT_PAGE | long | Page # of the most recent checkpoint log record |
| CHECKPOINT_MARKER | double | Record ID (RID) of the most recent checkpoint log record |
| CHECKPOINT_DATE | time | Time of the most recent checkpoint log record |
| OLDEST_TRANS_PAGE | long | Page # of the oldest transaction during the most recent checkpoint |
| OLDEST_TRANS_MARKER | double | Record ID (RID) of the oldest transaction during the most recent checkpoint |
| OLDEST_TRANS_DATE | time | Time of the oldest transaction during the most recent checkpoint |
| UNTIL_TIME_PAGE | long | Page # for UNTIL_TIME_DATE |
| UNTIL_TIME_MARKER | double | RID for UNTIL_TIME_DATE |
| UNTIL_TIME_DATE | time | Latest time that could be in the dump that can be used by the "until time" clause of "load transaction" |
| TOTAL_PAGES | double | Number of pages between the first log page and the last log page |
| STP_PAGES | double | Number of pages between the secondary truncation point (STP) and the oldest active transaction |
| ACTIVE_PAGES | double | Number of pages between the oldest transaction (during the most recent checkpoint) and the end of the log |
| INACTIVE_PAGES | double | Number of pages that will be truncated by the "dump transaction" command; number of log pages between the first log page and the first of (STP_PAGE or OLDEST_TRANS_PAGE) |
| OLDEST_ACTIVE_TRANS_PCT | double | % of the total log space assigned to the oldest active transaction in the log |
| OLDEST_ACTIVE_TRANS_SPID | long | Session process ID (SPID) having the oldest active transaction in the log |
| OLDEST_ACTIVE_TRANS_PAGE | long | Page # of the start of the oldest active transaction in the log; 0 = no active transaction |
| OLDEST_ACTIVE_TRANS_DATE | time | Time of the oldest active transaction in the log |
| IS_STP_BLOCKING_DUMP | string(4) | Whether the secondary truncation point (STP) is blocking a dump (Yes, No); whether the STP is before the start of the oldest active transaction |
| STP_SPAN_PCT | double | % of the total log space that is from the secondary truncation point (STP) to the end of the log |
| CAN_FREE_USING_DUMP_TRAN | double | % of the total log space that can be truncated with a "dump transaction" command (if the oldest active transaction is not aborted) |
| IS_DUMP_IN_PROGRESS | string(4) | Whether a "dump transaction" is currently in progress (Yes, No) |
| DATABASE_HAS_ACTIVE_TRANS | string(4) | Whether the database has any active transactions (Yes, No) |
| MERGESTATUS | long | Internal-use merge status; created by Surveillance |
| Attributes: | None |
|---|---|
| Minimum database version: | 15.7 |