O'Reilly logo

DB2® for z/OS® Version 8 DBA Certification Guide by Susan Lawson

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 18. DB2 Monitoring and Tuning

• Overview of performance and tuning

• Database monitoring

• Memory tuning

• Problem determination

Understanding the performance of the DB2 database management system, its databases, and active applications in a dynamic environment requires monitoring. This means that a database administrator should gather information about the use of the database. An application programmer may also require information about SQL statement execution. This chapter discusses gathering database information by using DB2's monitoring facilities and information about SQL statement processing.

The various DB2 facilities for monitoring and gathering information that is input into the tuning process are reviewed, along with the Explain ...

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