Detailed performance monitoring

You can add detailed monitoring to periodic monitoring when you discover or suspect a problem. You can also use detailed monitoring to investigate areas that are not covered by your periodic monitoring. To minimize the cost of the detailed monitoring, limit the information to the specific application and data as much as possible.

Procedure

  • If you have a performance problem, first verify that it is not caused by faulty design of an application or database.
  • If you believe that the problem is caused by the choice of system parameters, I/O device assignments, or other factors, begin monitoring Db2 to collect data about its internal activity.
  • If you have access path problems, use the query tuning and visual explain features of IBM® Data Studio, or the Db2 EXPLAIN facility to locate and tune the problems.