JAVA系统运行db2查询很慢_DB2调优（一）监控执行缓慢的SQL

在DB2调优过程中经常希望能够获取当前生产环境中执行缓慢的sql，获取后可以针对特定慢的sql进行精确调优。以下脚本可以利用，操作还是比较繁琐，需要手动运行。

db2 connect to tablename;

db2 -x "

select current timestamp ||'|'|| stmt_text ||'|'|| member

||'|'|| NUM_EXEC_WITH_METRICS ||'|'|| TOTAL_ACT_TIME ||'|'|| TOTAL_ACT_WAIT_TIME ||'|'|| TOTAL_CPU_TIME

||'|'|| POOL_READ_TIME ||'|'|| LOCK_WAIT_TIME ||'|'|| TOTAL_SECTION_SORT_TIME ||'|'|| TOTAL_SECTION_SORTS

||'|'|| ROWS_READ ||'|'|| ROWS_RETURNED ||'|'|| POOL_DATA_L_READS ||'|'|| POOL_TEMP_DATA_L_READS

||'|'|| POOL_INDEX_L_READS ||'|'|| POOL_TEMP_INDEX_L_READS ||'|'|| POOL_DATA_P_READS

||'|'|| POOL_TEMP_DATA_P_READS ||'|'|| POOL_INDEX_P_READS ||'|'|| POOL_TEMP_INDEX_P_READS

||'|'|| SORT_OVERFLOWS ||'|'