Interfaces for database monitoring

There are two ways to monitor operations in your database. You can view information that shows the state of various aspects of the database at a specific point in time. Or, you can set up event monitors to capture historical information as specific types of database events take place.

You can monitor your database operations in real-time using monitoring table functions. For example, you can use a monitoring table function to examine the total amount of space used in a table space. These table functions let you examine monitor elements and metrics that report on virtually all aspects of database operations using SQL. The monitoring table functions use the newer, lightweight, high-speed monitoring infrastructure that was introduced in Version 9.7. In addition to the table functions, snapshot monitoring routines are also available. The snapshot monitoring facilities in DB2® use monitoring infrastructure that existed before Version 9.7. Generally speaking, snapshot monitoring facilities are no longer being enhanced in the product; where possible, use the monitoring table functions to retrieve the data you want to see.

Event monitors capture information about database operations over time, as specific types of events occur. For example, you can create an event monitor to capture information about locks and deadlocks as they occur in the system. Or you might create an event monitor to record when a threshold that you specify (for example the total processor time used by an application or workload) is exceeded. Event monitors generate output in different formats; all of them can write event data to regular tables; some event monitors have additional output options.

IBM® InfoSphere® Optim™ Performance Manager provides a Web interface that you can use to isolate and analyze typical database performance problems. You can also view a summary of the health of your databases and drill down. For more details, see Monitoring with Optim Performance Manager.