Table of contents

Setting up event monitor profile

You can use IBM® Db2® Data Management Console to monitor specific event types that occur on a connected database.

Procedure

To set up event monitor profile for your database connection:

  1. Access the console.
  2. In the Databases page, click the connection that you want to work on.
  3. Click the Summary drop-down menu and go to Settings > Event monitor profile.
    The Event monitor profile page displays.
    • 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.
  4. Select an option and enter the details.
    Option Description

    Tablespace usage

    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.

    Status
    • "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 30000000.
    Utility types For Utility event monitor, use this option to select the utility types. The following utilities are available:
    • BACKUP
    • LOAD
    • MOVETABLE
    • ONLINERECOVERY
    • REDISTRIBUTE
    • REORG
    • RESTORE
    • ROLLFORWARD
    • RUNSTATS
    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.
    Note: To 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.
    Workload table For activity event monitor and statistics event monitor, the table lists all relevant workloads. You can enable, disable, and customize the workload settings.
  5. Click Save.