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.
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 |
Concepts of the Database System, How Databases Log Data Changes