¼­¹ö ½ÃÀÛ ½Ã DB2 SQLCODE -444 ¿À·ù ¼öÁ¤

WebSphere Partner Gateway ±¸¼º¿ä¼Ò(bcgconsole, bcgreceiver, bcgdocmgr) Áß Çϳª¸¦ ½ÃÀÛÇÒ ¶§ SQLCODE -444 ¿À·ù ¸Þ½ÃÁö°¡ ¹ß»ýÇϸé DB2 Database Manager SHEAPTHRES ¸Å°³º¯¼öÀÇ °ªÀ» ´Ã·Á¾ß ÇÕ´Ï´Ù. ÀÌ ¸Å°³º¯¼öÀÇ °ªÀº DB2 ÀνºÅϽº ³»ÀÇ ÀÓÀÇÀÇ µ¥ÀÌÅͺ£À̽º¿¡ ´ëÇØ Á¤ÀÇµÈ ÃÖ´ë sortheap °ªÀÇ 2¹è ÀÌ»óÀ̾î¾ß ÇÕ´Ï´Ù. ÀÌ ¼³Á¤À» º¯°æÇϱâ Àü¿¡ µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ¿¡°Ô ¹®ÀÇÇϰųª DB2 °ü¸®ÀÚ ¾È³»¼­¸¦ ÂüÁ¶ÇϽʽÿÀ. »ùÇà ¸í·ÉÀÌ ´ÙÀ½¿¡ Á¦°øµÇ¾î ÀÖ½À´Ï´Ù.

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 °ü¸®ÀÚ ¾È³»¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.

¿À·ù ¸Þ½ÃÁö´Â ±¸¼º¿ä¼Ò¿¡ µû¶ó ´ÙÀ½ ·Î±× ÆÄÀÏ¿¡ ÀÖ½À´Ï´Ù.

{INSTALL DIR}\was\profiles\bcgconsole\logs\bcgconsole\bcg_console.log

{INSTALL DIR}\was\profiles\bcgreceiver\logs\bcgreceiver\bcg_receiver.log         

{INSTALL DIR}\was\profiles\bcgdocmgr\logs\bcgdocmgr\bcg_docmgr.log

¶ÇÇÑ <DB2Home>\SQLLIB\bin\db2diag.log ÆÄÀÏ¿¡ ÀÖÀ» ¼öµµ ÀÖ½À´Ï´Ù.

Copyright IBM Corp. 2003, 2005