程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 數據庫知識 >> DB2數據庫 >> DB2教程 >> DB2事件監控的命令

DB2事件監控的命令

編輯:DB2教程

DB2事件監控都有哪些命令呢?這是很多人都提到過的問題,下面就為您詳細介紹DB2事件監控的命令,希望對您能有所幫助。

DB2事件監控創建後可以象快照監控一樣打開和關閉

DB2事件監控類型:
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).

啟動事件監控
SET EVENT MONITOR evmon1 STATE = 1

關閉事件監控
SET EVENT MONITOR evmon1 STATE = 0

刪除事件監控
DROP EVENT MONITOR evmon1

刷新事件監控
FLUSH EVENT MONITOR evmon1 BUFFER

  1. 上一頁:
  2. 下一頁:
Copyright © 程式師世界 All Rights Reserved