DB2 Version 9.7 for Linux, UNIX, and Windows

When event monitor counting starts

Event monitor counting starts at zero, and represents a count since a number of starting points.

If you start a statement event monitor after a statement starts, the monitor will start collecting information when the next SQL statement starts. As a result, the event monitor will not return information about statements that the database manager is executing when the monitor was started. This is also true for transaction information.

Event monitor data cannot be reset, except by turning the event monitor off (stopping), and then starting it again.