´ÙÇü ¹®¼­ ¶ó¿ìÆÃ ½Ã DB2 SQLCODE -444 ¿À·ù ¼öÁ¤

DB2 UDB ±¸¼º¿¡ µû¶ó ´ÙÇü(¸Ê üÀÎ) ¹®¼­¸¦ ¶ó¿ìÆÃÇÒ ¶§ SQLCODE -444 ¿À·ù ¸Þ½ÃÁö°¡ ³ªÅ¸³¯ ¼öµµ ÀÖ½À´Ï´Ù. ÀÌ·¯ÇÑ ¿À·ù ¸Þ½ÃÁö´Â ÆÄÀÏ
{INSTALL DIR}\was\profiles\bcgdocmgr\logs\bcgdocmgr\bcg_router.log¿Í
<DB2Home>\SQLLIB\bin\db2diag.log¿¡¼­ ãÀ» ¼ö ÀÖ½À´Ï´Ù. ÀÌ ¸Þ½ÃÁö°¡ ¹ß»ýÇϸé DB2 µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ ¸Å°³º¯¼ö SHEAPTHRES °ªÀ» ´Ã·Á¾ß ÇÕ´Ï´Ù. ÀÌ ¸Å°³º¯¼öÀÇ °ªÀº DB2 ÀνºÅϽº ³»ÀÇ ÀÓÀÇÀÇ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ Á¤ÀÇµÈ ÃÖ´ë srotheap °ªÀÇ ÃÖ¼Ò 2¹èÀÔ´Ï´Ù. »ùÇà ¸í·ÉÀÌ ´ÙÀ½¿¡ Á¦°øµÇ¾î ÀÖ½À´Ï´Ù.

db2 UPDATE DBM CFG USING SHEAPTHRES xxxxx IMMEDIATE

SHEAPTHRES °ªÀ» º¯°æÇÑ ÈÄ¿¡µµ SQLCODE -444°¡ °è¼ÓµÇ´Â °æ¿ì, WPG µ¥ÀÌÅͺ£À̽ºÀÇ STMTHEAP ¹× APPLHEAPSZ °ªÀ» ÁÙ¿©¾ß ÇÒ ¼öµµ ÀÖ½À´Ï´Ù. »ùÇà ¸í·ÉÀÌ ´ÙÀ½¿¡ Á¦°øµÇ¾î ÀÖ½À´Ï´Ù.

db2 UPDATE DB CFG FOR <dbname> USING STMTHEAP xxxxx

db2 UPDATE DB CFG FOR <dbname> USING APPLHEAPSZ xxxxx

ÀÌ ¼³Á¤À» º¯°æÇϱâ Àü¿¡ DBA¿¡°Ô ¹®ÀÇÇϰųª DB2 °ü¸®ÀÚ ¾È³»¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.

Copyright IBM Corp. 2003, 2005