O'Reilly logo

Understanding DB2®: Learning Visually with Examples, Second Edition by Dwaine R. Snow, Michael Dang, Xiaomei Wang, Raul F. Chong

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required