Database performance tuning
Database performance tuning can dramatically affect the throughput of your application. For example, if your 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 WebSphere® Application Server supports the
integration of many different database products, each one with unique
tuning configurations, consult your database vendor documentation
for comprehensive tuning information. This information center provides
introductory material in the following topics:
DB2® tuning parameters
DB2 Universal Database performance tips
DB2 tuning tips for z/OS