?????. 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