db2--常用命令.docVIP

1) 创建事件监控器 ???????????db2 create event monitor msql_mon for statements,connections write to table ?????????????? buffersize 4 blocked manualstart ?????????? db2 flush event monitor sql_mon ?????????? db2 set event monitor msql_mon state 1 ????????2) 找出对性能影响最大的sql语句 ????????? db2 select substr(char(agent_id),1,4) agent_id,rows_read,rows_selected, ???????????????? total_sorts,sort_oveflows,(system_cpu_time + user_cpu_time) as?cpu from ???????????????? conn_msql_connection order by cpu desc ????????? 从上面找出最耗cpu的agent_id，从中找出sql语句 ????????? db2 select substr(stmt_text,1,256) as statment from