DB2事件監(jiān)控的命令
DB2事件監(jiān)控都有哪些命令呢？這是很多人都提到過的問題，下面就為您詳細介紹DB2事件監(jiān)控的命令，希望對您能有所幫助。
DB2事件監(jiān)控創(chuàng)建后可以象快照監(jiān)控一樣打開和關(guān)閉
DB2事件監(jiān)控類型：
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).
啟動事件監(jiān)控
SET EVENT MONITOR evmon1 STATE = 1
關(guān)閉事件監(jiān)控
SET EVENT MONITOR evmon1 STATE = 0
刪除事件監(jiān)控
DROP EVENT MONITOR evmon1
刷新事件監(jiān)控
FLUSH EVENT MONITOR evmon1 BUFFER
【編輯推薦】
