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

 

 

 

【编辑推荐】

DB2 Merge语句的用法

DB2流程控制子句一览

深入探讨DB2表连接原理

db2日志保存的两种方式

四种常用的DB2循环语句

责任编辑:段燃 来源: 互联网
相关推荐

2010-11-04 11:07:56

DB2管理命令

2010-08-26 11:37:38

DB2命令

2010-11-03 15:19:46

DB2装入命令

2010-11-01 17:10:45

DB2命令行

2010-08-27 15:13:14

DB2命令AIX

2010-11-04 14:12:24

DB2快照监控

2010-09-07 16:11:19

执行DB2命令

2010-08-16 09:48:28

DB2数据库

2010-08-19 13:59:01

DB2命令

2011-03-11 17:52:33

DB2命令

2010-11-03 15:24:36

DB2数据库命令

2010-08-18 15:14:08

DB2恢复命令

2010-11-04 14:25:19

DB2 SQL文执行计

2010-08-05 15:17:43

DB2提高IMPORT

2010-08-02 13:05:01

DB2应用

2010-08-09 10:36:20

执行DB2命令

2010-09-30 10:13:35

DB2常用命令

2010-07-30 13:16:21

IBM DB2事件监视

2011-03-14 17:03:21

DB2数据库性能监控

2010-08-31 14:01:00

DB2SQL脚本
点赞
收藏

51CTO技术栈公众号