Object documentationMULTIVERSIONREADSTATISTICS Locate this document in the navigation structure

 

The system table SYSINFO.MULTIVERSIONREADSTATISTICS provides details about operations for preserving consistent reading since the last start of the database instance.

Structure

MULTIVERSIONREADSTATISTICS

MINTRANSACTIONID

FIXED(15)

ID of the oldest transaction for which the history data has to be retained

RETAINHISTORY

CHAR(3)

Retain the history data for the transactions started after the transaction indentified via MINTRANSACTIONID (YES | NO)

HISTORYANCHORFROMFILECOUNT

FIXED(20)

Number of pages whose entry points into history data had to be recreated via additional page access

HISTORYANCHORFROMPAGECOUNT

FIXED(20)

Number of pages whose entry points into history data could be created directly from the page

HISTORYANCHORTOFILECOUNT

FIXED(20)

Number of pages whose entry points into history data had to be stored on an additional page while writing

HISTORYANCHORTOPAGECOUNT

FIXED(20)

Number of pages whose entry points into history data could be stored on the page itself while writing

HISTORYACCESSCOUNT

FIXED(20)

Number of accesses to history data

PERCENTAGEPAGESCOPIEDFORWRITE

FIXED(3)

Percentage of pages to be written that have to be copied before being written to the memory (%)