Object documentationHISTORYCLEANUPSTATISTICS Locate this document in the navigation structure

 

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