½ºÅ×ÀÌ¡ ¼­¹ö ¹®Á¦Á¡ ÇØ°á (Windows NT, Windows 2000, AIX, ¹× Solaris)

  1. ½ºÅ×ÀÌ¡ ¼­¹ö ¸í·É stgcopy ¹× stgprop¸¦ »ç¿ëÇÏ´Â µ¿¾È ´ÙÀ½°ú °°Àº ¸Þ½ÃÁö¸¦ ¹ÞÀ» ¼ö ÀÖ½À´Ï´Ù.
  2.         SQLSTATE 54001: The statement is too long or too complex.

    µ¥ÀÌÅͺ£À̽ºÀÇ stmtheap Å©±â¸¦ µ¥ÀÌÅͺ£À̽º ±¸¼º¿¡ Á¦¾ÈµÈ ´ë·Î ¼³Á¤Çß´ÂÁö È®ÀÎÇϽʽÿÀ. ÁõºÐÀ» Áö¿øÇÒ ¸¸Å­ ¸Þ¸ð¸®°¡ ÃæºÐÇÑÁö °ËÁõÇØ¾ß ÇÕ´Ï´Ù.

  3. ½ºÅ×ÀÌ¡ º¹»ç À¯Æ¿¸®Æ¼°¡ 󸮸¦ ¿Ï·áÇÏÁö ¸øÇß´Ù¸é µ¥ÀÌÅͺ£À̽º ·Î±×°¡ ³Ê¹« À۱⠶§¹®ÀÏ ¼ö ÀÖ½À´Ï´Ù. DB2 ¸í·É â¿¡¼­ ´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇϽʽÿÀ.
           db2 update database configuration for staging_server using logprimary 50        logfilsiz 1000
           db2 terminate
           db2stop
           db2start

    ¿©±â¼­, staging_server´Â ½ºÅ×ÀÌ¡ ¼­¹ö µ¥ÀÌÅͺ£À̽ºÀÇ À̸§ÀÔ´Ï´Ù. ¹®Á¦°¡ Áö¼ÓµÇ¸é logprimary ¶Ç´Â logfilsiz ¸Å°³º¯¼ö¿¡ ´ëÇØ ´õ ³ôÀº °ªÀ» »ç¿ëÇØ º¸½Ê½Ã¿À.
  4.  
  5. db2inst1°ú °°Àº DB2 »ç¿ëÀÚ°¡ ¿Ã¹Ù¸£°Ô ±¸¼ºµÇ¾ú´ÂÁö È®ÀÎÇϽʽÿÀ. ´ÙÀ½ ¸í·ÉÀ» ÀÔ·ÂÇϸé ÀÚ¿ø ÇѰ谡 ³ªÅ¸³³´Ï´Ù. ulimit -a

    µ¥ÀÌÅÍ ¼¼±×¸ÕÆ®¸¦ 240MB·Î ±¸¼ºÇÏ°í ½ºÅÃÀ» 16MB·Î ±¸¼ºÇϽʽÿÀ.

    ÀÚ¼¼ÇÑ ³»¿ëÀº DB2 ¸í·É ÂüÁ¶¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.

°ü·Ã ŽºÅ©

IBM copyright