Testing Db2 performance

You can take measures to ensure that your test subsystem is a realistic model of your production environment.

Modeling a production environment on a test subsystem
You can improve the accuracy of access path testing by modeling the configuration and settings of a production environment in a test subsystem. The test system uses values that you specify for processor configuration, RID pool, sort pool, and buffer pool settings.
Modeling your production system statistics in a test subsystem
You can improve access path testing by updating the catalog statistics on your test system to be the same as your production system.

Parent topic: Managing Db2 performance

Related tasks

Testing and debugging an application program on Db2 for z/OS