Setting database parameter values
The values that you assign to certain database configuration (DB CFG) parameters affect the behavior of IBM® Db2® Data Management Console.
The table below lists the recommended values for these parameters:
Database Parameter | Description | Recommended value |
---|---|---|
MON_REQ_METRICS | For basic data collection of statements, activities, workloads, etc. | BASE |
MON_ACT_METRICS | For basic data collection of statements, activities, workloads, etc. | BASE |
MON_OBJ_METRICS | For data collection of database objects, such as TABLE, TABLESPACE, etc. | BASE |
MON_RTN_DATA | For data collection of stored procedure | BASE |
MON_LW_THRESH | For data collection of blocking and waiting connections | 30,000,000 (microseconds) |
MON_DEADLOCK | For data collection of blocking and waiting connections | WITHOUT_HIST |
MON_LOCKTIMEOUT | For data collection of blocking and waiting connections | HISTORY |
MON_LOCKWAIT | For data collection of blocking and waiting connections | HISTORY |
Note: Enabling Locking event monitor option in Administration > Event monitor profile
page, updates the MON_LW_THRESH, MON_DEADLOCK,
MON_LOCKTIMEOUT, and MON_LOCKWAIT parameters of the target
database to the recommended value.