DB2 event monitoring command

What commands does DB2 event monitoring have? This is a problem that many people have mentioned. The following describes the commands for DB2 event monitoring in detail, hoping to help you.

After DB2 event monitoring is created, it can be turned on and off like snapshot monitoring.

DB2 event monitoring type:
Database-Records an event record when the last application disconnects from the database.
Tables-Records an event record for each active table when the last application disconnects from the database. An active table is a table that has changed since the first connection to the database.
Deadlocks-Records an event record for each deadlock event.
Tablespaces-Records an event record for each active table space when the last application disconnects from the database.
Bufferpools-Records an event record for buffer pools when the last application disconnects from the database.
Connections-Records an event record for each database connection event when an application disconnects from a database.
Statements-Records an event record for every SQL statement issued by an application (dynamic and static ).
Transactions-Records an event record for every transaction when it completes (COMMIT or ROLLBACK statement ).

Start event monitoring
Set event monitor evmon1 STATE = 1

Disable event monitoring
Set event monitor evmon1 STATE = 0

Delete event monitoring
Drop event monitor evmon1

Refresh event monitoring
Flush event monitor evmon1 BUFFER

Usage of DB2 Merge statements

Overview of DB2 Flow Control clauses

In-depth discussion of DB2 table connection principles

Two ways to store db2 logs

Four Common DB2 cycle statements