1 问题现象
应用日志抛出http://www.cndba.cn/hbhe0316/article/4890

No FCM buffers are available SQLCODE=-6040

（二）问题诊断

#db2 get dbm cfg | grep -i fcm
 FCM_NUM_BUFFERS为AUTOMATIC(10240)
 FCM_BUFFER_SIZE为32768
 执行命令
#db2 ? SQLCODE6040

If the error persists, increase the number of FCM buffers (
fcm_num_buffers ) specified in the database manager configuration file,
then try the request again.

If FCM_NUM_BUFFER is already set to automatic, you should also check the
overall memory consumption on your system to determine if other
applications are using inappropriate amounts of memory, and preventing
the allocation of FCM buffers.

IBM建议收集内存日志查看。http://www.cndba.cn/hbhe0316/article/4890

(三) 数据收集http://www.cndba.cn/hbhe0316/article/4890

nohup sar -S 1 360 >>/tmp/sar.swap.out &
nohup sar -r 1 360 >> /tmp/sar.mem.out &
nohup vmstat -wt 1 360 >> /tmp/vmstat.wt.out &
nohup db2pd -dbptnmem -alldbp -rep 5 10 –o /tmp/db2pd.dbptnmem.out &
nohup db2pd -inst -memset -mempool -alldbp -rep 5 10 -o /tmp/db2pd.setpools.out &
nohup db2 get snapshot for fcm for all dbpartitionnums global >>/tmp/db2getsnapshot.out
nohup db2pd –db <dbname> -act –rep 5 10 –o /tmp/db2pd.act.out

(四)恢复步骤
查看了收集日志，并不是系统内存以及数据库内存不足导致FCM不足，调整了MAX_QUERYDEGREEhttp://www.cndba.cn/hbhe0316/article/4890

db2 update dbm cfg using MAX_QUERYDEGREE 32

版权声明：本文为博主原创文章，未经博主允许不得转载。

DB2