You can use IBM®
Db2® Data Management Console to monitor specific event types
that occur on a connected database.
To set up event monitor profile for your database connection:
- Access the console.
- In the Databases page, click the connection that you want to work
- Click the Summary drop-down menu and go to
The Event monitor profile
- Activity event monitor - The activity event monitor captures data that helps you understand the
performance and behavior of statements.
- Locking event monitor - The locking event monitor captures descriptive information about lock
events at the time that they occur.
- Utility event monitor - The utility event monitor captures a number of events that are related
to the execution of utilities.
- Statistics event monitor - The statistics event monitor captures data that can be used to
measure different aspects of system operation.
- Select an option and enter the details.
Displays the current table space setting for the event monitors on the database (the default
storage size is 2 GB). To increase or decrease the table space usage size, click the Scale
button. In the Scale tablespace window, use the slider to specify the new value for table
space size and click Scale button.
- "Enabled" indicates that this type of event monitor is enabled.
- "Disabled" indicates that this type of event monitor is disabled.
|Collect data every (minutes)
||Specifies the collect duration. The default value is 5.
|keep data for (days)
||Specifies the collect duration. The default value is 28.
|Capture in-progress query with event monitor
||For activity event monitor, you can set this option to ON to enable the activity event
monitor to collect not only the finished queries, but also the in-progress queries. The default
value is ON.
|Lock wait threshold (microseconds)
||For locking event monitor, you can specify this option to set the locking event monitor to
record locks that are locked longer than the threshold value. The default value is
||For Utility event monitor, use this option to select the utility types. The following
utilities are available:
|Use administrative task scheduler (ATS)
The Administrative Task Scheduler automates tasks to maintain the performance of your database.
For this setting, the console checks the ATS prerequisites on the monitored database.
enable the Administrative Task Scheduler, the SYSTOOLSPACE table space must be created in the
database if it does not exist. Privileges for the ADMIN_TASK_UPDATE and ADMIN_TASK_REMOVE stored
procedures are granted to the user ID that connects to the monitored database. When the
Administrative Task Scheduler is enabled, the Db2 registry
variable DB2_ATS_ENABLE is set to 1.
||For activity event monitor and statistics event monitor, the table lists all relevant
workloads. You can enable, disable, and customize the workload settings.
- Click Save.