HISTORYCLEANUPSTATISTICS

The system table SYSINFO.HISTORYCLEANUPSTATISTICS contains details about the activities which have taken place since the last database system start and which belong to tasks that delete information.

Structure

HISTORYCLEANUPSTATISTICS
TASKID	FIXED(10)	ID of the task
ACTIVE	CHAR(3)	Task is currently active (YES \| NO)
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

HISTORYCLEANUPSTATISTICSRESET

Concepts of the Database System, How Databases Log Data Changes