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循环语句

分享标题：DB2事件监控的命令
转载注明：http://www.csdahua.cn/qtweb/news2/542352.html

网站建设、网络推广公司-快上网，是专注品牌与效果的网站制作，网络营销seo公司；服务项目有等

广告

声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源： 快上网