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:
- 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.
- 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.
- 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.
- 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.
- 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
- 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.
- Configure the options on the Options page.
- 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.
- 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.
- 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.
- Click Next.
- Specify a location and name and click Finish.