Optimizing performance in DB2

You can change configuration settings at the registry, database manager, and the database levels. The registry level controls all DB2® databases and DB2 applications. The database manager controls the main configuration settings for all databases. Each individual database instance can also have its own settings at the database level.

Before you begin

To change settings, you must log in as the instance owner, which is the owner that created the specific instance, for example, db2inst1. In a Windows environment, the user who installed the database is the instance owner. In a UNIX or Linux environment, the root user installs the database and creates the instance owner. After installation of the database, only the instance owner can change the database settings.

About this task

Optimal performance is subjective and dependent on your environment and the needs and expectations of your users. In general, optimal performance typically includes response times within a tested and acceptable limit and the optimal uses of system resources. Hardware use should be efficient, which means that you do not have unused processing cycles or overworked system resources.

Any values for database settings are offered as a starting point, which you can refine to meet the needs of your deployment. Values were determined through performance testing in several different environments, which include the AIX®, Windows, and Linux operating systems.

To determine the optimal performance settings for your environment, conduct performance tests before deployment.



Feedback