The system table <DATABASE_SYSTEM_ADMINITRATOR>.HISTORYINFO displays information regarding data history. This history is necessary for providing data for a consistent view.
FILENO |
FIXED(10) |
Number of the history file |
FIRSTTRANS |
CHAR(20) |
Oldest transaction that has not yet been processed by the garbage collector |
LASTTRANS |
CHAR(20) |
Most recent transaction that has not yet been processed by the garbage collector |
PAGECOUNT |
FIXED(10) |
Number of pages used by the history file and all undo log files referenced by it |
HISTORYTYPE |
CHAR(16) |
History type (LIVECACHE | MULTIVERSIONREAD | GARBAGE ONLY) |
PARTITIONID |
FIXED(5) |
Identification of the partition |
IMPORTED |
CHAR(3) |
History file has been imported (YES | NO) |