PERFM keyword

Most performance problems can be resolved through system tuning and should be handled by the Db2 system administrator.

About this task

Before following this procedure, use the checklist below to verify that the performance problem cannot be resolved through other means.
  • Try to tune performance.
  • Verify that the performance problem is not related to a wait or loop. Refer to Initial procedure for the WAIT/LOOP keywords.
  • If performance degraded after someone tuned Db2, verify that the tuning options selected were appropriate. Most likely, the problem can be resolved by choosing other options.

Procedure

  1. Record the actual performance, expected performance, and source of expected performance criteria.
  2. Add PERFM to the keyword string, and turn to Searching the IBM Support site for known problems and solutions.
      (free format):
      5740XYR00 R111 PERFM
      (structured format):
      PIDS/5740XYR00 LVLS/111 PERFM