Displaying database and Db2 Connect performance values

While you are conducting maintenance, or if you are trying to improve overall database performance, it is good to review the current performance values to determine if you have to perform database maintenance or tuning.

About this task

To display database and Db2 Connect performance values using the Performance Monitor:


  1. Choose the performance counters whose values you want displayed from the Add to box. This box displays a list of performance objects providing performance data.
  2. Select an object to see a list of the counters it supplies. A performance object can have multiple instances. For example, the LogicalDisk object provides counters such as % Disk Read Time and Disk Bytes/sec; it also has an instance for each logical drive in the computer, including C: and D:.