Database performance tuning

Database performance tuning can dramatically affect the throughput of the application. For example, if the application requires high concurrency (multiple, simultaneous interactions with backend data), an improperly tuned database can result in a bottleneck. Database access threads accumulate in a backlog when the database is not configured to accept a sufficient number of incoming requests.

Because WAS supports the integration of many different database products, each one with unique tuning configurations, consult the database vendor documentation for comprehensive tuning information. This information center provides introductory material in the following topics:

• DB2 tuning parameters

---

Subtopics

DB2 tuning parameters

 

Related tasks

Tuning the application serving environment
Enable request metrics

 

Related

Data access tuning parameters