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 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
- DB2 Universal Database performance tips
- DB2 tuning tips for z/OS
Subtopics
- DB2 tuning parameters
Read this topic for parameters that we can configure for better database performance. - DB2 tuning tips for z/OS
Related tasks
Reference topic