?????. DB2 ? XpertMon ??? ???!
? ????????? DB ??????.
????? 3??? V8.2 ? ??? ??? ??? ???????.
??? ??? ??? ??? ?? ????? XpertMon ? ?????.
?? ??? ??? ???, ???? ?? ?? ???? ??? ????? ???
??????. ???? ????? ?????.

---

What`s new in the world of back-ups
V8.2??? ??? ?? ??? ?? ??? ???????.

1. ?? ??? LOG ? ?? ???? ??. ??? ??? LOG ? ?? ?????, ??????? ???? ?? LOG? ?? ??? ??? ??
   
2. ?? Throttling
   
3. ?? ?? ???? ??

?? 1 - ?? ??? LOG ??

• ??? ?? : Archive LOG ??? ???? Sample DB
• ??? ????
  1. Department ???? Insert ?????.
     
  2. ??? ???? Online ?? ?????.
     ?? ??? include logs ?? ??? ????? ?????? ?????? Log ??? ???? ????.
     $] db2 backup db sample online to /home/udbese include logs
     
  3. ??? ??????? 2)? ?? ???? ?????. logtarget ???
     ??? ????? ????, ?????? ?? ?????? ???? ?? ?? ?? ???? ?? LOG ? ???? ??????.
     $] db2 restore db sample from /home/udbese into newdb
     logtarget /home/udbese
     
  4. Rollforward ? ?????. ? ? ??? ??? ??? ????. ??? Rollforward pending ? ???? ?? ?????. $] db2 rollforward db newdb to end of logs and stop
     
  5. ??? ??????? ????? 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