Chapter 17. Database Performance Considerations
Performance is probably the most important factor in databases and database applications. If performance was not important, people would simply create applications that store their data in flat files rather than purchase highly optimized relational database management systems.
Tuning a DB2 system to obtain optimal performance can be a lengthy process. Poor performance is usually a result of:
Inefficient SQL
Suboptimal system (hardware) design
Suboptimal instance configuration
Suboptimal database configuration
Lack of proper maintenance
No Workload Management
While you may not have a lot of control over the server and disks that are used for the database server, especially in a large UNIX shop, the hardware ...
Get Understanding DB2®: Learning Visually with Examples, Second Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
