PERFM keyword
Most performance problems can be resolved through system tuning and should be handled by the Db2 system administrator.
About this task
- 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.