µ¥ÀÌÅͺ£À̽º ±¸¼º

½ºÅ×ÀÌ¡ º¹»ç À¯Æ¿¸®Æ¼, ½ºÅ×ÀÌ¡ Àü´Þ À¯Æ¿¸®Æ¼ ¶Ç´Â µ¥ÀÌÅͺ£À̽º Á¤¸® À¯Æ¿¸®Æ¼¸¦ »ç¿ëÇϱâ Àü¿¡ ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.

  1. PATH ȯ°æ º¯¼ö¸¦ ¼³Á¤ÇϽʽÿÀ.
  2. DB2 µ¥ÀÌÅͺ£À̽º¸¦ »ç¿ëÇÏ´Â °æ¿ì, ½ºÅ×ÀÌ¡ µ¥ÀÌÅͺ£À̽º ¹× ÇÁ·Î´ö¼Ç µ¥ÀÌÅͺ£À̽º¸¦ ±¸¼ºÇϽʽÿÀ. ´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇϽʽÿÀ.
  3.     db2 update db config for db_name using STMTHEAP 60000
        db2 update db config for db_name using LOCKLIST 512
        db2 update db config for db_name using LOGPRIMARY 80
        db2 update db config for db_name using LOGBUFSZ 512
        db2 update db config for db_name using DBHEAP 2048
        db2 update db config for db_name using APPLHEAPSZ 2048
        db2 update db config for db_name using PCKCACHESZ 8200
        db2 update db config for db_name using STAT_HEAP_SZ 2048
        db2 update db config for db_name using APP_CTL_HEAP_SZ 4096

    ¿©±â¼­, db_nameÀº µ¥ÀÌÅͺ£À̽ºÀÇ À̸§ÀÔ´Ï´Ù.

  4. ¼º´ÉÀ» Çâ»ó½ÃŰ·Á¸é ¹öÆÛ Ç® Å©±â¸¦ ´Ã¸®½Ê½Ã¿À. DB2 µ¥ÀÌÅͺ£À̽º Å©±â ¹× »ç¿ë °¡´ÉÇÑ ¸Þ¸ð¸®¸¦ ±âÃÊ·Î ÃÖÀûÀÇ ¹öÆÛ Ç® Å©±â¸¦ ÆÇº°ÇϽʽÿÀ. ´ÙÀ½ ¸í·ÉÀ» ½ÇÇàÇÏ¿© ±âº» ¹öÆÛ Ç® Å©±â¸¦ º¯°æÇϽʽÿÀ
  5.    db2 connect to db_name
       db2 alter bufferpool IBMDEFAULTBP size n
       db2 terminate

    ¿©±â¼­, nÀº ÃÖÀûÀÇ ¹öÆÛ Ç® Å©±â¸¦ º¯°æÇϽʽÿÀ.

  6. secofr ±ÇÇÑ ¹× 65535¿Í ´Ù¸¥ cssid°¡ ÀÖ´Â »ç¿ëÀÚ ÇÁ·ÎÆÄÀÏ·Î ·Î±×¿ÂÇϽʽÿÀ.

°ü·Ã °³³ä

°ü·ÃµÈ ÂüÁ¶

IBM copyright