Table of contents

Setting up monitoring profile

Historical monitoring data is stored in a repository database. You need to activate repository persistence and set associated values in your monitoring profile to ensure the Db2® Data Management Console presents the data you need.

Procedure

To set up monitoring of historical data for your database connection:

  1. Access the console.
  2. In the Databases page, click on the connection that you want to work on.
  3. Click the Summary drop-down menu and go to Settings > Monitoring profile.
    The Monitoring profile page displays.
  4. Click the Monitor settings tab and enter the following details.

    Collection

    Option Description

    Monitoring is off /on

    Monitoring toggle button
    • Off - monitoring will be disabled.
    • On - monitoring will be enabled.

    Collect data every (minutes)

    Indicates the number of minutes between historical monitoring cycles. Default value is 5 minutes.

    Package cache  
    SQL statements captured

    The top N SQL statements with the metrics of highest value that is gathered from the package cache, where N is the number of SQL statements captured.

    Table data read for a collection

    The maximum number of table data that is read for a data collection.

    Locks  
    Lock wait threshold (milliseconds)

    The amount of time spent in a lock wait before an event is generated.

    Table data read for a collection

    The maximum number of table data that is read for a data collection.

    Normalize captured SQL statements

    Selecting this option will replace the literal values with question mark (?) tokens to collapse the cardinality of unique SQL statements back to a (typically small) finite set.

    Persistence

    Option Description

    Persistence is off /on

    Persistence toggle button
    • Off - monitoring data will not be stored in the repository database.
    • On - monitoring data about the selected settings will be stored in the repository database.

    Monitoring data

    Selecting this option will collect all the table function related historical information (excluding package cache) and store it in the repository database.

    Package cache

    Selecting this option will collect historical data from the Db2 package cache and store it in the repository database.

  5. Click Save.