Adding IBM DB2 sources

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

Before you begin

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 information on the DB2 snapshot monitor, see these topics in the DB2 documentation:System monitor switches and Snapshot monitor.

Procedure

To 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 that is used to communicate with the computer that is running DB2, change the information in Connection. Typically, your DB2 system administrator specifies this information.
  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 your password locally. If you do not save your 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 your 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.
  7. To collect the resource monitoring data for the system under test that is in the cloud, in the Cloud Options tab, click the Location in Public Cloud check box.
  8. Click Next.
  9. Specify a location and name and click Finish.
Feedback