tailieunhanh - Creating an Event Monitor for Statements

Một sự kiện theo dõi bảng ghi dòng sự kiện vào bảng SQL, điều này làm cho nắm bắt, phân tích cú pháp, và quản lý dữ liệu theo dõi sự kiện dễ dàng • Cần SYSADM hoặc DBADM để tạo ra một sự kiện bảng theo dõi • Cú pháp: CREATE MONITOR SỰ KIỆN stmtmon CHO BÁO CÁO WHERE APPL_NAME = 'NEWAPP 'VÀ AUTH_ID =' BBDS 'VIẾT CHO BẢNG IN event_tblspace CONNHEADER (TABLE STMT_EVT_CH, IN TBS_EVMON), STMT (TABLE STMT_EVT_STMT, IN TBS_EVMON, hàm TRUNC), CONTROL (TABLE STMT_EVT_CTRL, IN TBS_EVMON) BUFFERSIZE 2000 NONBLOCKED OR VIẾT CHO FILE' / tmp / dlevents. | REDUCE IMPACT Creating an Event Monitor for Statements A table event monitor streams event records to SQL tables this makes capture parsing and management of event monitoring data easy Need SYSADM or DBADM to create a table event monitor Syntax CREATE EVENT MONITOR stmtmon FOR STATEMENTS WHERE APPL_NAME NEWAPP AND AUTH_ID BBDS WRITE TO TABLE IN event_tblspace CONNHEADER TABLE STMT_EVT_CH IN TBS_EVMON STMT TABLE STMT_EVT_STMT IN TBS_EVMON TRUNC CONTROL TABLE STMT_EVT_CTRL IN TBS_EVMON BUFFERSIZE 2000 NONBLOCKED OR WRITE TO FILE tmp dlevents OR WRITE TO PIPE home riihi dlevents Sample Output Statement Event Monitor Query SQL Monitoring Interfaces Administrative Views Easy-to-use application programming interface h Execute administrative functions through SQL Table functions MON_GET_. h Introduced in DB2 h Enhanced reporting and monitoring of the database system data objects and the package cache h Lightweight - has a lower impact on the system than existing system monitor and snapshot .