IBM Support

[Db2] データベース・ヒープが不足 (SQL0956C) したり、データベース・ヒープが周期的に増加することがある

Question & Answer


Question

アプリケーションが SQL0956C で失敗し、Db2 診断ログ (db2diag.log) に DIA8302C No memory available in the database heap が多数記録されたり、db2pd -alldbs -memp で観察するとデータベース・ヒープ (dbh) が 15分毎に増加することがあります。 このメモリー・エラーや、メモリー使用量増加の理由と対処方法を教えてください。

[{"Type":"MASTER","Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"ARM Category":[{"code":"a8m0z000000GozAAAS","label":"Memory"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Versions"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
30 April 2025

UID

swg21625200