IBM DB2

Tune DB2 components such as the server and indexes.

Tuning the IBM DB2 server
Tune the registry and database manager settings and the automatic buffer pool size and auto extends.
Tuning the IBM DB2 indexes
Tuning the application platform, reserve, and lease indexes can improve performance.
Internal lease benchmarks
Lease Management and Lease Accounting performance testing used a database that was loaded with approximately 17,000 lease abstracts and 24,000 leases with other large amounts of portfolio data to represent a large customer deployment of the lease application. The performance test indexes were applied to the data-load and benchmark-test environments to improve overall throughput and response times as a result of this project.
Performance test indexes
Testing identified long-running SQL statements for data load, single user, and multi user test indexes. These statements were then analyzed with the IBM DB2 SQL Advisor and appropriate indexes were created.

Parent topic: Tuning the database server