日本综合一区二区|亚洲中文天堂综合|日韩欧美自拍一区|男女精品天堂一区|欧美自拍第6页亚洲成人精品一区|亚洲黄色天堂一区二区成人|超碰91偷拍第一页|日韩av夜夜嗨中文字幕|久久蜜综合视频官网|精美人妻一区二区三区

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

目前成都創(chuàng)新互聯(lián)已為上千家的企業(yè)提供了網(wǎng)站建設(shè)、域名、虛擬主機、網(wǎng)站托管運營、企業(yè)網(wǎng)站設(shè)計、呼和浩特網(wǎng)站維護等服務(wù)，公司將堅持客戶導(dǎo)向、應(yīng)用為本的策略，正道將秉承"和諧、參與、激情"的文化，與客戶和合作伙伴齊心協(xié)力一起成長，共同發(fā)展。

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

【編輯推薦】

DB2 Merge語句的用法

DB2流程控制子句一覽

深入探討DB2表連接原理

db2日志保存的兩種方式

四種常用的DB2循環(huán)語句

本文題目：DB2事件監(jiān)控的命令
鏈接分享：http://www.dlmjj.cn/article/dpiepjj.html