1.获得程序运行时的Application Name,Auth Id,以下面为例,那就是db2bp,DB2INST1db2 list applicationsAuth Id Application Appl. Application Id  ...
显示全部1.获得程序运行时的Application Name,Auth Id,以下面为例,那就是db2bp,DB2INST1
db2 list applications
Auth Id Application Appl. Application Id DB # of
Name Handle Name Agents
-------- -------------- ---------- -------------------------------------------------------------- -------- -----
DB2INST1 db2bp 134 *N0.db2inst1.111121023505 SAMPLE 1
2.创建名为tabforpro的TABLES,STATEMENTS事件监控器
db2 "create event monitor tabforpro for tables,statements where APPL_NAME = 'db2bp' AND AUTH_ID = 'DB2INST1' write to file '/home/db2inst1/tab/'" (路径自己创建一个)
3.打开事件监控器,重新运行程序
db2 set event monitor tabforpro state 1
4.程序运行结束,刷新、关闭事件监控器
db2 flush event monitor tabforpro
db2 set event monitor tabforpro state 0
5.输出事件监控器结果到临时文件中,查看结果
db2evmon -path /home/db2inst1/tab > /tmp/file
egrep 'Table name:|Text :' /tmp/file
收起