数据库系统特别慢，CUP高峰占到了90多，原因查不出来。
EDU ID TID Kernel TID EDU Name USR (s) SYS (s)
=====================================================================================
23 139974657697536 4937 db2agent (BZPRO) 0 8859.210000 41.770000
用db2pd -edus抓出这个特别大。
刚接触DB2不久，求大神帮帮忙。
7同行回答
- select * from ( select rownumber() over() as rownumber_, j.REMIT_ID,j.ELECT_RECE_BILL,j.REMIT_NAME,j.REMIT_TIME,j.AMOUNT,j.OPER_TYPE,j.IS_RECONC,j.CENTER_CODE,(select count(APP_ID) from TBZ_APP_HAS_REMIT b where b.REMIT_ID=j.REMIT_ID) as APPCOUNT from TBA_REMIT_INFO j where j.CENTER_CODE = ? ) as temp_ where rownumber_ between 1 and 10 126702072 SQL0445W Value "select function0_.FUNCTION_ID as FUNCTION1_8_, function0_.FU" 是用这条语句吗。
- select * from sysibmadm.snapdyn_sql order by total_usr_cpu_time desc fetch first 5 rows only
- select * from ( select rownumber() over() as rownumber_, j.REMIT_ID,j.ELECT_RECE_BILL,j.REMIT_NAME,j.REMIT_TIME,j.AMOUNT,j.OPER_TYPE,j.IS_RECONC,j.CENTER_CODE,(select count(APP_ID) from TBZ_APP_HAS_REMIT b where b.REMIT_ID=j.REMIT_ID) as APPCOUNT from TBA_REMIT_INFO j where j.CENTER_CODE = ? ) as temp_ where rownumber_ between 1 and 10 126702072 SQL0445W Value "select function0_.FUNCTION_ID as FUNCTION1_8_, function0_.FU" has been truncated. SQLSTATE=01004 是这个SQL。还报了一个错误，是怎么回事。
在cpu负载高峰期，运行下列命令：
1 db2pd -edus -interval=15 top=5 # 根据 usr(或sys） delta 一列找出最耗cpu的 edu id，
2 根据第一步找到的edu id，
db2pd -d
记录下上面edu id对应的appl handle
3 db2pd -d
找出对应的应用在干啥，跑的什么sql。。。
然后，，然后看你自己的了
- select * from ( select rownumber() over() as rownumber_, j.REMIT_ID,j.ELECT_RECE_BILL,j.REMIT_NAME,j.REMIT_TIME,j.AMOUNT,j.OPER_TYPE,j.IS_RECONC,j.CENTER_CODE,(select count(APP_ID) from TBZ_APP_HAS_REMIT b where b.REMIT_ID=j.REMIT_ID) as APPCOUNT from TBA_REMIT_INFO j where j.CENTER_CODE = ? ) as temp_ where rownumber_ between 1 and 10 126702072 SQL0445W Value "select function0_.FUNCTION_ID as FUNCTION1_8_, function0_.FU" has been truncated. SQLSTATE=01004 是这个SQL。还报了一个错误，是怎么回事。