Object documentationHISTORYCLEANUPSTATISTICSRESET Locate this document in the navigation structure

 

The system table SYSINFO.HISTORYCLEANUPSTATISTICSRESET contains details about the activities which have taken place since the last RESET ALL STATISTICS or RESET HISTORYCLEANUPSTATISTICS and which belong to tasks containing history information which is to be deleted.

Structure

HISTORYCLEANUPSTATISTICSRESET

RESETDATE

TIMESTAMP

Time of the last RESET for these entries

TASKID

FIXED(10)

ID of the task

RESUMETASKCOUNT

FIXED(20)

Number of activations of this task

ALLOBJECTCOUNT

FIXED(20)

Number of objects deleted via this task

ALLROWCOUNT

FIXED(20)

Number of table lines deleted via this task

ALLINDEXCOUNT

FIXED(20)

Number of index entries deleted via this task

CLEANUPCOUNT

FIXED(20)

Number of history entries deleted via this task that are no longer required

CREATEOBJECTCOUNT

FIXED(20)

Number of history entries deleted via this task that pertain to CREATE objects

INSERTOBJECTCOUNT

FIXED(20)

Number of history entries deleted via this task that pertain to INSERT objects

UPDATEOBJECTCOUNT

FIXED(20)

Number of history entries deleted via this task that pertain to UPDATE objects

DELETEOBJECTCOUNT

FIXED(20)

Number of history entries deleted via this task that pertain to DELETE objects

LOCKUPDATEOBJECTCOUNT

FIXED(20)

Number of history entries deleted via this task that pertain to UPDATE FOR LOCK objects

RELEASEOBJECTPAGECOUNT

FIXED(20)

Number of pages released due to deletion of the last object stored on them

RELEASECONTAINERPAGECOUNT

FIXED(20)

Number of pages released due to deletion of complete containers

CREATECONTAINERCOUNT

FIXED(20)

Number of history entries deleted via this task that pertain to CREATE containers

DROPCONTAINERCOUNT

FIXED(20)

Number of deleted containers

DROPTREECOUNT

FIXED(20)

Number of table or index trees deleted via this task

More Information

HISTORYCLEANUPSTATISTICS

Concepts of the Database System, How Databases Log Data Changes