O'Reilly logo

Sams Teach Yourself DB2® Universal Database™ in 21 Days, Second Edition by Susan Visser, Bill Wong

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 19. Database Monitoring Tools

DB2 provides several tools to help you determine your specific performance requirements. You will learn how to use the following tools:

  • Health Monitor, which enables you to monitor a DB2 instance by allowing you to create alerts and notifications if an alert threshold is exceeded

  • Database System Monitor, a collecton of APIs that enable you to gather information on what’s occurring in the system, either at a single point in time (snapshot monitoring) or over a period of time (event monitoring)

  • Visual Explain, which enables you to graphically see the access plan the DB2 optimizer has selected for a given SQL statement

  • RUNSTATS, which allows you to collect statistics about the physical organization of data in the ...

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