解决Db2 Static Commit 有时过慢的问题

现象：应用程序访问DB2时，不定期出现延时1分钟左右的情况

分析方法：

--分析SQL
db2 "create event monitor SQLCOST for statements write to FILE '/home/analyze'"
db2 "set event monitor SQLCOST state = 1"
--隔几分钟
db2 "set event monitor SQLCOST state = 0"
db2evmon -db mbf -evm SQLCOST > sqltrace.txt
db2 "drop event monitor SQLCOST"

发现：

Appl Seq number: 02725

  Record is the result of a flush: FALSE
  -------------------------------------------
  Operation: Static Commit
  Package  :
  Consistency Token  :
  Package Version ID  :
  Cursor   :
  Cursor was blocking: FALSE
  -------------------------------------------
  Start Time: 03/30/2011 08:15:50.214237
  Stop Time:  03/30/2011 08:16:42.738230
  Elapsed Execution Time:  52.523993 seconds
  Number of Agents created: 1
  User CPU: 0.000079 seconds
  System CPU: 0.000014 seconds

共用时52.523993 seconds

怀疑 LOGFILSIZ 过小导致此问题。

 

解决方法：
db2 update db cfg for mps using LOGFILSIZ 10240
db2stop force;db2start