Using the performance trace for diagnosis

While the performance trace is primarily a tuning aid, it can sometimes be useful for diagnosis because degraded performance can also indicate a Db2 problem, one for which you would specify the PERFM keyword in building a keyword string to describe the problem.

You can use the performance trace to determine whether degraded performance represents such a problem or the need for subsystem tuning. Often degraded performance is a symptom of a WAIT or LOOP problem, and the performance trace can help you make this determination. In addition, performance trace classes 6 and 7 can help you detect locking problems.