DB2事件监控的命令_DB2_数据库_程序员俱乐部

中国优秀的程序员网站程序员频道CXYCLUB技术地图
热搜:
更多>>
 
您所在的位置: 程序员俱乐部 > 数据库 > DB2 > DB2事件监控的命令

DB2事件监控的命令

 2013/8/9 17:21:04    程序员俱乐部  我要评论(0)
  • 摘要:DB2事件监控都有哪些命令呢?这是很多人都提到过的问题,下面就为您详细介绍DB2事件监控的命令,希望对您能有所帮助。DB2事件监控创建后可以象快照监控一样打开和关闭DB2事件监控类型:Database-Recordsaneventrecordwhenthelastapplicationdisconnectsfromthedatabase.Tables
  • 标签:事件 命令

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

发表评论
用户名: 匿名