Setting up event monitor profile

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

Procedure

To set up event monitor profile for your database connection:

  1. Access the console.
  2. On the Databases page, click the connection that you want to work on.
  3. From the navigation menu, go to Settings > Event monitor profile.
    The Event monitor profile page appears.
    • 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 various 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.
      Note: Locking event monitor and Utility event monitor is not applicable for Data Virtualization and Big SQL databases.
  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 the table space usage size, click Scale. In the Scale tablespace window, use the slider to specify the new value for table space size and click Scale.

    For Data Virtualization and Big SQL databases, a 4 GB tablespace named "TS4MONITOR" is created during database deployment.
    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 persist 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 OFF.
    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 to be recorded. 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" or "yes" or "on" or "true".
    • If the console stops or can no longer reach the monitor database, ATS eventually disables the event monitor. Otherwise, you need to disable the event monitor manually.
    Workload table For activity event monitor and statistics event monitor, the table lists all workloads on the database.

    Except CONSOLE_WORKLOAD, DV_ WORKLOAD and BIGSQL_WORKLOAD, you can enable, disable, and customize the other workload settings.
  5. Click Save.