Object documentationHISTORYINFO Locate this document in the navigation structure

 

The system table <DATABASE_SYSTEM_ADMINITRATOR>.HISTORYINFO displays information regarding data history. This history is necessary for providing data for a consistent view.

Structure

HISTORYINFO

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