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.
|
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 |
| EARLYDELETEOBJECTCOUNT | FIXED(20) | Number of objects deleted via thia taks before normal garbage collection |
Concepts of the Database System, How Databases Log Data Changes