Object documentationGARBAGECOLLECTOR_STATISTICS Locate this document in the navigation structure

 

The system table <DATABASE_SYSTEM_ADMINISTRATOR>.GARBAGECOLLECTOR_STATISTICS describes garbage collector activity.

Structure

GARBAGECOLLECTOR_STATISTICS

TASKID

FIXED(10)

ID of the task that is running as a garbage collector

ACTIVE

CHAR(3)

Task is active (YES | NO)

ACTIVATE_COUNT

FIXED(20)

Number of times the task was activated

DELETE_OBJ

FIXED(20)

Number of persistent objects released by the garbage collectors

RELHIST_NORMAL

FIXED(20)

Number of history entries released by the garbage collectors

RELHIST_SENSITIVE

FIXED(38)

NULL value (no longer in use)

RELHIST_TRUNCATE

FIXED(38)

NULL value (no longer in use)

HIST_CREATE_FILE

FIXED(20)

Number of 'Create Container' history entries released by the garbage collectors

HIST_DELETE_OBJ

FIXED(20)

Number of 'Delete Object' history entries released by the garbage collectors

HIST_DROP_FILE

FIXED(20)

Number of 'Drop Container' history entries released by the garbage collectors

HIST_LOCK_OBJ

FIXED(20)

Number of 'Lock Object' history entries released by the garbage collectors

HIST_INSERT_OBJ

FIXED(20)

Number of 'Insert Object' history entries released by the garbage collectors

HIST_NEW_OBJ

FIXED(20)

Number of 'New Object' history entries released by the garbage collectors

HIST_UPDATE_OBJ

FIXED(20)

Number of 'Update Object' history entries released by the garbage collectors

RELPAGE_EMPTY

FIXED(20)

Number of pages released by the garbage collectors because they were empty

RELPAGE_DROPFILE

FIXED(20)

Number of pages that were released due to a 'Drop Container' statement

DROP_FILE

FIXED(1)

Number of 'Drop Container' commands carried out by the garbage collectors

DELETE_ROW

FIXED(20)

Number of table rows deleted by the garbage collectors

DELETE_INDEX

FIXED(20)

Number of primary keys deleted from index trees by the garbage collectors

More Information

Concepts of the Database System, How Databases Log Data Changes