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