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.
Before monitoring and tuning, increase the size of the DB log files.
Because WebSphere Application Server 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
- (iSeries) DB2 Universal Database performance tips
- DB2 tuning tips for z/OS
Tune the application serving environment Get performance data from request metrics Data access tuning parameters