DB2 Version 9.7 for Linux, UNIX, and Windows

CREATE EVENT MONITOR FOR TRANSACTIONS statement has been deprecated

The use of the CREATE EVENT MONITOR FOR TRANSACTIONS statement to monitor transaction events has been deprecated. Its use is no longer recommended and might be removed in a future release.

Details

In previous releases, if you wanted to monitor transaction events, you had to issue the CREATE EVENT MONITOR FOR TRANSACTIONS statement to create a transaction event monitor. Version 9.7 includes a new event monitor infrastructure that provides an entirely new set of monitor elements and methods to monitor DB2® events. As a result, if you want to monitor transaction events in DB2 Version 9.7, using the CREATE EVENT MONITOR FOR UNIT OF WORK statement is the suggested method.

User response

Use the CREATE EVENT MONITOR FOR UNIT OF WORK statement to create a transaction event monitor.