Application design for performance

Designing the database and applications to be as efficient as possible is an important first step to good system and application performance. As you code applications, consider performance objectives in your application design.

Some factors that affect the performance of applications include how the program uses host variables and what bind options you choose. In turn, those factors affect how long Db2 takes to determine an access path for the SQL statements in the application.

Later in this information you can read about locking and concurrency, including recommendations for database and application design that improve performance.

After you run an application, you need to decide if it meets your performance objectives. You might need to test and debug the application to improve its performance.