Configuring and using event monitoring

Event monitoring lets you collect information triggered by state changes depending on event types such as databases, connections, tables, statements, transactions, deadlocks, and table spaces. It's been in DB2 for quite a while but new functionalities have been added in version 9.7. You have the choice to collect information into a file or a table.

Use caution while configuring event monitors as you may induce performance degradation if it's not configured correctly. Writing event data to files has the least impact on the database. Writing to NFS file systems is not as efficient as using a local file.

Tip

Writing event data to tables has more impact on the database, but provides easier interrogation through SQL queries. What's new in version 9.7 is the unformatted event table. It eases the burden on the database and gives you the same flexibility.

We will discuss lock monitoring as it changed in version 9.7, so we'll show you how to set it up, and start...