½ºÅ×ÀÌ¡
¼¹ö ¹®Á¦Á¡ ÇØ°á (Windows NT, Windows 2000, AIX, ¹× Solaris)
- ½ºÅ×ÀÌ¡ ¼¹ö ¸í·É stgcopy ¹× stgprop¸¦ »ç¿ëÇÏ´Â µ¿¾È
´ÙÀ½°ú °°Àº ¸Þ½ÃÁö¸¦ ¹ÞÀ» ¼ö ÀÖ½À´Ï´Ù.
SQLSTATE 54001: The statement is too long or too complex.
µ¥ÀÌÅͺ£À̽ºÀÇ stmtheap Å©±â¸¦
µ¥ÀÌÅͺ£À̽º ±¸¼º¿¡ Á¦¾ÈµÈ ´ë·Î
¼³Á¤Çß´ÂÁö È®ÀÎÇϽʽÿÀ. ÁõºÐÀ» Áö¿øÇÒ ¸¸Å ¸Þ¸ð¸®°¡ ÃæºÐÇÑÁö °ËÁõÇØ¾ß ÇÕ´Ï´Ù.
- ½ºÅ×ÀÌ¡ º¹»ç À¯Æ¿¸®Æ¼°¡ 󸮸¦ ¿Ï·áÇÏÁö ¸øÇß´Ù¸é µ¥ÀÌÅͺ£À̽º ·Î±×°¡ ³Ê¹« ÀÛ±â
¶§¹®ÀÏ ¼ö ÀÖ½À´Ï´Ù. DB2 ¸í·É â¿¡¼ ´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇϽʽÿÀ.
db2 update database configuration for staging_server using logprimary 50
logfilsiz 1000
db2 terminate
db2stop
db2start
¿©±â¼, staging_server´Â ½ºÅ×ÀÌ¡ ¼¹ö µ¥ÀÌÅͺ£À̽ºÀÇ À̸§ÀÔ´Ï´Ù. ¹®Á¦°¡ Áö¼ÓµÇ¸é logprimary ¶Ç´Â logfilsiz ¸Å°³º¯¼ö¿¡ ´ëÇØ ´õ ³ôÀº °ªÀ» »ç¿ëÇØ º¸½Ê½Ã¿À.
db2inst1°ú °°Àº DB2 »ç¿ëÀÚ°¡ ¿Ã¹Ù¸£°Ô ±¸¼ºµÇ¾ú´ÂÁö È®ÀÎÇϽʽÿÀ.
´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϸé ÀÚ¿ø ÇѰ谡 ³ªÅ¸³³´Ï´Ù. ulimit -a
µ¥ÀÌÅÍ ¼¼±×¸ÕÆ®¸¦ 240MB·Î ±¸¼ºÇÏ°í ½ºÅÃÀ» 16MB·Î
±¸¼ºÇϽʽÿÀ.
ÀÚ¼¼ÇÑ ³»¿ëÀº DB2 ¸í·É ÂüÁ¶¼¸¦ ÂüÁ¶ÇϽʽÿÀ.