O'Reilly logo

DB2 9 for Developers by Philip K. Gunning

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

In this chapter, we build on the information covered in Chapter 11, concentrating on evaluating and tuning DB2 instance and database configuration parameters based on output from the DB2 monitoring facilities. We’ll use data from the following DB2 facilities and tools:

  • Snapshot monitoring

  • SQL administrative routines

  • SQL convenience views

  • Health Center and Health Monitor

  • Memory Visualizer

  • Activity Monitor

  • db2pd utility

  • Memory Tracker

  • Event monitors

You’ll learn how to use the output from these monitoring facilities, and I’ll recommend which monitoring facilities to use for various performance problems. We’ll also discuss how to arrive at specific tuning and performance recommendations, examine the new DB2 9 Self Tuning Memory Manager ...

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