¾È³çÇϼ¼¿ä. DB2 ¹× XpertMon »ç¿ëÀÚ ¿©·¯ºÐ!
¢ß ¾ÆÀÌƼ¿¢½ºÆÛÆ®±×·ì DB »ç¾÷ºÎÀÔ´Ï´Ù.
À̹øÁÖºÎÅÍ 3ÁÖ°£Àº V8.2 ÀÇ »õ·Î¿î ±â´É¿¡ ´ëÇؼ ´Ù·ïº¸°Ú½À´Ï´Ù.
ÀÌ·¯ÇÑ »õ·Î¿î ±â´ÉÀº °ËÅ並 ÅëÇØ °è¼ÓÀûÀ¸·Î XpertMon ¿¡ Àû¿ëµË´Ï´Ù.
¸¹Àº µµ¿òÀÌ µÇ½Ã±æ ¹Ù¶ó¸ç, Ȥ½Ã¶óµµ ¾Ë°í ½ÍÀº ³»¿ëÀ̳ª ÁÖÁ¦°¡ ÀÖÀ¸½Ã´Ù¸é ¸ÞÀÏ·Î
º¸³»ÁֽʽÿÀ. ÂüÁ¶ÇÏ¿© ¹Ý¿µÇϵµ·Ï ÇÏ°Ú½À´Ï´Ù.
What`s new in the world of back-ups
V8.2¿¡¼´Â ´ÙÀ½°ú °°ÀÌ ¼¼°¡Áö ¹é¾÷ ±â´ÉÀÌ Ãß°¡µÇ¾ú½À´Ï´Ù.
- ¹é¾÷ ÆÄÀÏ¿¡ LOG ¸¦ ÇÔ²² ÀúÀåÇÏ´Â ±â´É. ¿Â¶óÀÎ ¹é¾÷¿¡ LOG °¡ ÇÔ²² ÀúÀåµÇ¹Ç·Î,
ÀçÇغ¹±¸¼¾Å¸¸¦ ±¸ÃàÇÏ´Â °æ¿ì LOG¸¦ µû·Î º¹»çÇÒ ÇÊ¿ä°¡ ¾øÀ½
- ¹é¾÷ Throttling
- ÀÚµ¿ ¹é¾÷ ÆĶó¹ÌÅÍ Æ©´×
±â´É 1 - ¹é¾÷ ÆÄÀÏ¿¡ LOG Ãß°¡
- Å×½ºÆ® ȯ°æ : Archive LOG ¹æ½ÄÀ» »ç¿ëÇÏ´Â Sample DB
- Å×½ºÆ® ½Ã³ª¸®¿À
- Department Å×ÀÌºí¿¡ Insert ¼öÇàÇÕ´Ï´Ù.
- ·Î±×¸¦ Æ÷ÇÔÇÏ´Â Online ¹é¾÷ ¼öÇàÇÕ´Ï´Ù.
¹é¾÷ ÆÄÀÏÀº include logs ¶ó´Â ¿Â¶óÀÎ ÆĶó¹ÌÅ͸¦ »ç¿ëÇßÀ¸¹Ç·Î ¹é¾÷À̹ÌÁö¿Í
Log ÆÄÀÏÀ» Æ÷ÇÔÇÏ°í ÀÖ½À´Ï´Ù.
$] db2 backup db sample online to /home/udbese include logs
- »õ·Î¿î µ¥ÀÌÅͺ£À̽º·Î 2)¹ø ¹é¾÷ À̹ÌÁö·Î º¹±¸ÇÕ´Ï´Ù. logtarget À̶ó´Â
»õ·Î¿î ÆĶó¹ÌÅ͸¦ ÀÔ·ÂÇÏ°í, ¹é¾÷À̹ÌÁö°¡ ÀÖ´Â µð·ºÅ丮¸íÀ» Àû¾îÁÖ¸é
¹é¾÷ ÆÄÀÏ ¾È¿¡ ÀúÀåµÇ¾î ÀÖ´Â LOG ¸¦ ÀÌ¿ëÇÏ¿© º¹±¸ÇØÁÝ´Ï´Ù.
$] db2 restore db sample from /home/udbese into newdb
logtarget /home/udbese
- Rollforward ¸¦ ¼öÇàÇÕ´Ï´Ù. ÀÌ ¶§ ·Î±×¸¦ º¹»çÇÒ ÇÊ¿ä°¡ ¾ø½À´Ï´Ù.
´Ü¼øÈ÷ Rollforward pending À» ÇØÁ¦ÇÏ´Â °Í¿¡ ºÒ°úÇÕ´Ï´Ù.
$] db2 rollforward db newdb to end of logs and stop
- »õ·Î¿î µ¥ÀÌÅͺ£À̽º¿¡ Á¢¼ÓÇغ¸¸é Department Å×ÀÌºí¿¡ »õ·Î¿î row µé¾îÀÖÀ½À»
È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù.
¹é¾÷ À̹ÌÁö È®ÀÎ ¹æ¹ý
¹é¾÷ ÆÄÀÏÀÌ ·Î±×¸¦ Æ÷ÇÔÇÏ°í ÀÖ´ÂÁö ¾ø´ÂÁö ¿©ºÎ¸¦ È®ÀÎÇÏ´Â ¹æ¹ýÀº ´ÙÀ½°ú °°½À´Ï´Ù.
$] db2ckbkp -h ¹é¾÷ÆÄÀϸí | find /i "Include"
==> ¸¸¾à °ªÀÌ 1 À̸é LOG ¸¦ Æ÷ÇÔÇÑ´Ù´Â °ÍÀÌ°í, 0 À̸é LOG ¸¦ Æ÷ÇÔÇÏÁö ¾Ê´Â´Ù´Â ÀǹÌÀÓ
±â´É 2 - ¹é¾÷ Throttling
Throttling ±â´ÉÀº V8.1 ºÎÅÍ Ãß°¡µÈ ±â´ÉÀÔ´Ï´Ù.
Runstats ³ª Rebanlance, Backup °ú °°Àº À¯Æ¿¸®Æ¼´Â Resource¸¦ ¸¹ÀÌ »ç¿ëÇÒ ¼ö Àֱ⠶§¹®¿¡,
Resource ¸¦ Control ÇÏ´Â ±â´ÉÀÌ Ãß°¡µÇ¾ú½À´Ï´Ù.
¹æ¹ýÀº ´ÙÀ½°ú °°½À´Ï´Ù.
- DBM CFG ÆĶó¹ÌÅÍÀÎ UTIL_IMPACT_LIM °ªÀ» ¼³Á¤
$] db2 update dbm cfg using UTIL_IMPACT_LIM 10
¹éºÐÀ²·Î, 100À» ÁÖ¸é, throttling ÀÌ ¹ß»ýÇÏÁö ¾ÊÀ¸¸ç, 10À» ÁÖ¸é, À¯Æ¿¸®Æ¼´Â 20%ÀÌ»ó
Resource¸¦ »ç¿ëÇÏÁö ¾Êµµ·Ï Á¦ÇѵÊ
- Backup ½Ã¿¡ ÆĶó¹ÌÅÍÀÎ UTIL_IMPACT_PRIORITY ¸¦ »ç¿ë
$] db2 backup db sample online to /home/udbese util_impact_priority 75 include
logs
°¡Àå ³·Àº priority´Â 1ÀÌ°í °¡Àå ³ôÀº priority´Â 100ÀÔ´Ï´Ù.
- List utility¸¦ »ç¿ëÇÏ¿© utilityÀÇ progress¸¦ checkÇÕ´Ï´Ù. 75 ÀÓÀ» º¼ ¼ö ÀÖ½À´Ï´Ù.
$] db2 list utilities
ID = 3
Type = BACKUP
Database Name = SAMPLE
Partition Number = ¨ª
Description = online db
Start Time = 2005-05-06 13:37:28.977758
Throttling:
Priority = 75
Progress Monitoring:
Estimated Percentage Complete = 77
|
- Priority¸¦ º¯°æÇÒ ¼ö ÀÖ½À´Ï´Ù.
$] db2 set UTIL_IMPACT_PRIORITY for 3 to 0
¿©±â¼ 3Àº ù¹ø° ¶óÀÎÀÇ ID À̸ç, 0 Àº »õ·Î ¼³Á¤ÇÒ priority ÀÔ´Ï´Ù.
0À¸·Î ¼³Á¤Çϸé Unthrottled Mode ·Î ½ÇÇàµÇ´Â °ÍÀÔ´Ï´Ù.
±â´É 3 - ÀÚµ¿ ¹é¾÷ ÆĶó¹ÌÅÍ Æ©´×
V8.2¿¡¼´Â ¹é¾÷°ú °ü·ÃµÈ ÆĶó¹ÌÅ͸¦ ¼³Á¤ÇÏÁö ¾Ê¾Æµµ, DB2 °¡ ÃÖ»óÀÇ °ªÀ» ¼³Á¤ÇÏ¿©
¹é¾÷À» ¼öÇàÇÕ´Ï´Ù.
¾Æ·¡¿Í °°ÀÌ ÆĶó¹ÌÅ͸¦ ÁöÁ¤ÇÏÁö ¾Ê°í ¹é¾÷À» ½ÇÇàÇغ¸°í, ¼º´É°ú °ü·ÃµÈ ÆĶó¹ÌÅ͸¦
ÁöÁ¤ÇÏ°í ¹é¾÷À» ´Ù½Ã ½ÇÇàÇØ ºÃÀ» ¶§ ¾î´À ÂÊÀÌ ºü¸¥Áö Å×½ºÆ® ÇØ º¸µµ·Ï ÇÏ°Ú½À´Ï´Ù.
- ¹é¾÷ 1 ( without ÆĶó¹ÌÅÍ) : 3ºÐ 15ÃÊ ¼Ò¿ä
$] db2 backup db sample online to /home/udbese
- ¹é¾÷ 2 ( with ÆĶó¹ÌÅÍ) : 4ºÐ 3ÃÊ ¼Ò¿ä
$] db2 backup db sample online to /home/udbese with 12 buffers buffer 1024
ÀÌ °á°ú°¡ °¡´ÉÇÑ ÀÌÀ¯´Â DB2°¡ ÃÖÀûÀÇ ÆĶó¹ÌÅ͸¦ ¾Ë¾Æ¼ ¼±ÅÃÇÏ¿´±â ¶§¹®ÀÔ´Ï´Ù.
XpertMon for DB2 UDB V2
DB »ç¾÷ºÎ
Tel : 02-2108-1458
Fax : 02-2108-1459
Mobile : 011-896-6545
E-mail :
hjlee@iteg.co.kr
URL :
http://iteg.co.kr