½ºÅ×ÀÌ¡ º¹»ç À¯Æ¿¸®Æ¼, ½ºÅ×ÀÌ¡ Àü´Þ À¯Æ¿¸®Æ¼ ¶Ç´Â µ¥ÀÌÅͺ£À̽º Á¤¸® À¯Æ¿¸®Æ¼¸¦ »ç¿ëÇϱâ Àü¿¡ ´ÙÀ½À» ¼öÇàÇϽʽÿÀ.
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Àº µ¥ÀÌÅͺ£À̽ºÀÇ À̸§ÀÔ´Ï´Ù.
db2 connect to db_name
db2 alter bufferpool IBMDEFAULTBP size n
db2 terminate
¿©±â¼, nÀº ÃÖÀûÀÇ ¹öÆÛ Ç® Å©±â¸¦ º¯°æÇϽʽÿÀ.
![]() |