SQL Access to Event Monitor Data
Event monitors log data as specified database events occur. For instance, you can create an event monitor to collect monitor data for deadlocks, transactions, and connections. You can use event monitors to alert you to immediate problems or to track impending problems.
As of DB2 UDB v8.1, DB2 can write event monitor data to tables. Prior to v8.1, users had to write their own applications to parse the event monitor data, organize and filter the data, and then archive it. With the event monitor data being directed into tables, it is already being archived and can easily be filtered and analyzed.
For every event type an event monitor collects, target tables are created for each of the associated logical data groups. ...
Get DB2® Version 8: The Official Guide now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
