1 问题现象
db2diag.log日志抛出:
https://www.cndba.cn/hbhe0316/article/4895
https://www.cndba.cn/hbhe0316/article/4895
“No memory available in “Application Heap””
DIA8301C No memory available in the application heap.
应用日志抛出:https://www.cndba.cn/hbhe0316/article/4895
SQL1221N The Application Support Layer heap connot be allocated.
2 问题诊断
查看如下参数,此问题问ASL heap堆内存不足导致,如果发现和规范不符合,理应调整至规范值,如果和规范一样,需要酌情扩大一倍。https://www.cndba.cn/hbhe0316/article/4895https://www.cndba.cn/hbhe0316/article/4895https://www.cndba.cn/hbhe0316/article/4895
db2set -all | grep -i DB2_FMP_COMM_HEAPSZ
db2 get dbm cfg | grep -i ASLHEAPSZ
db2 get db cfg for <dbname> | grep -i APPLHEAPSZ
3 恢复步骤
https://www.cndba.cn/hbhe0316/article/4895
https://www.cndba.cn/hbhe0316/article/4895
https://www.cndba.cn/hbhe0316/article/4895
https://www.cndba.cn/hbhe0316/article/4895
su - <instancename>
db2set DB2_FMP_COMM_HEAPSZ=780000
db2 update dbm cfg using ASLHEAPSZ 128
db2 update db cfg for <dbname> using APPLHEAPSZ 10240 automatic
db2stop force
db2start
db2 activate db <dbname>
版权声明:本文为博主原创文章,未经博主允许不得转载。
DB2