创建事件监控器,包含table、statementor use db2 inner tool 【db2top】 for unix versionor user sysibmadm view db2 "select substr(stmt_text,1,100),NUM_EXECUTIONS,SNAPSHOT_TIMESTAMP from sysibmadm.snapdyn_sql where SNAPSHOT_TIMESTAMP > current timestamp - ...
显示全部
创建事件监控器,包含table、statement
or use db2 inner tool 【db2top】 for unix version
or user sysibmadm view
db2 "select substr(stmt_text,1,100),NUM_EXECUTIONS,SNAPSHOT_TIMESTAMP from sysibmadm.snapdyn_sql where SNAPSHOT_TIMESTAMP > current timestamp - 100 second"
time 你可以自己指定。
or snapshot for table
呵呵,方法太多了。。。
收起