Add IBM DB2 sources

 

+

Search Tips   |   Advanced Search

 

Overview

To capture resource monitoring data from IBM DB2, configure the data source.

Your DB2 administrator must turn on the snapshot monitor switches for the resource monitoring data to collect. If the monitor switches are off, none of the resource counter groups will contain counters.

For more info on the DB2 snapshot monitor...


Configure the DB2 data source

  1. On the Location page, specify the connection and authentication information for the instance of DB2 to use to capture resource monitoring data.

    If you need to change the port used to communicate with the computer that is running DB2, change the information in Connection.

  2. Under Database Settings, type a name in Database Name and partition number in Partition number.

    If the instance of DB2 to monitor uses the Database Partitioning Feature (DPF), then change the partition number to the partition to monitor. Otherwise, leave the partition number set to the default, 0.

  3. Type the user ID and password for DB2 in Authentication.

    To collect resource monitoring data from DB2, the specified user account must have SYSADM, SYSCTRL, SYSMAINT, or SYSMON authority.

    1. Select Save Password to save password locally.

      If you do not save password, you might be prompted for it (depending on the host system configuration) when you edit the configured location or when you run test schedules that use the location.

  4. Optional: On the Monitoring Status page, click...

      Check Monitoring Status

    ...to determine the state of the monitor switches on the DB2 server.

    The states of the following monitor switches are checked:

    DFT_MON_BUFPOOL

    Buffer pool switch

    DFT_MON_LOCK

    Lock switch

    DFT_MON_SORT

    Sort switch

    DFT_MON_STMT

    Statement switch

    DFT_MON_TABLE

    Table switch

    DFT_MON_TIMESTAMP

    Timestamp switch

    DFT_MON_UOW

    Unit of work switch

  5. On the Resource page, select the type of data to capture.

    The tree view shows the database server and its counter groups and counters. Be selective; monitoring all possible resource data requires substantial amounts of memory. Clear the Show only selected counters check box to see all available counters. Hold mouse pointer over a counter to see details about what that counter measures.

  6. Configure the options on the Options page.

    1. In Polling Interval specify in seconds the interval, for collecting resource data.

      For example, if you accept the default of 5 seconds, counter information is collected at 5-second intervals from the specified host during the schedule run.

    2. In Timeout Interval specify in seconds the time to wait for a response.

      If the resource monitoring host does not respond within this amount of time during a schedule run, an error is logged.