CollDatabase (DB2UDB_COLLECTORS)

The CollDatabase collector collects information for the DB2_DB application class and provides the values to an extensive set of parameters for monitoring DB2 databases.

Some of the DB2DB_PERFORMANCE application class parameters receive values from the CollPerformance collector.

For the CollDatabase parameter to be online, you need to set the monitor switch, DFT_MON_LOCK, DFT_MON_SORT, and DFT_MON_BUFFPOOL to ON.

Execute the following command as the instance owner at the command prompt:

db2 update dbm cfg using DFT_MON_LOCK ON

db2 update dbm cfg using DFT_MON_SORT ON

db2 update dbm cfg using DFT_MON_BUFFPOOL ON

The DB2 instance must be restarted for changes to take effect.

Default parameter attributes

Attribute	Default value
Application class	DB2UDB_COLLECTORS
Command type	PSL
Platform	All
Active at installation	yes
Parameter type	Standard, used as collector
Polling Schedule	Every 20 minutes
Icon style	Boolean
Sets Values For	Consumer parameters of the following classes: DB2DB_CAPACITY_parameters DB2DB_LOCK_parameters DB2DB_LOG_parameters DB2DB_PERFORMANCE_parameters DB2DB_SQL_parameters