DB2 V9.5 ?? Migration ?? ? TIP-1
![](/files/fcFiles/Image/NL_img01.jpg)
??????. DB2 ? XpertMon ??? ???! ? ????????? DB??????.
?? ?? XpertMon ????? ?? ??? ???? ???? ? ? ???? ????? ?? ?? ??? ?? ???, XpertMon? ??? ????? ?? ???? History? ????(DPF, OLTP, Batch …) ? ?? ??? KPI? ???? ?? ?? ???? ? ??? ??? ????. ?? ???? ???? ???? ????? ??? ???? ?? ???? ?????.
?? ?? “DB2 V9.5 ?? Migration ?? ? TIP” ? ?? ????? ?????.
???? ?? ????? ???, ?? ?????? ?? ???? ( www.iteg.co.kr) ???? ????? ?? ? ????. ???? ?? ?? ???? ??? ??? ??? ??????. ???? ????? ?????.
AGENDA
1. ????
A. DB2 version check
B. OS pre-requirement
2. MIGRATION ? ???
A. DB2 V9.1 ? V9.5 ? ????
B. DB2 V9.5 ? ??
3. MIGRATION ? ?? ? ??? ??
A. “db2imigr” ? ???? ??
B. “Side-by-Side” ? ???? ??
4. MIGRATION ? ???? ??
1. ????
??? Migration ? ???? ????? ??? ? ????? ???? ???.
A. DB2 Version
i. ?? ???? DB2 version ? V8.1 (DB2 V8 PTF6x) ?? ? ??? DB2 Version ? V8.2 (DB2 v8 PTF7x) ???? Upgrade ? ?? Migration ? ???? ???.
ii. ?? ???? DB2 version ? V8.2 ?? ? ??? ?? V9.5 ? Migration ? ?????.
B. OS pre-requirement
![](/files/fcFiles/Image/News Letter/NL_img_20091110_01.jpg)
i. V9???? DB2 INSTANCE ? ????? OS Kernel ?? ??? ?? ???, DB2 V9.5 ? ??? 64bit ?? Upgrade? ??? ???.
ii. Linux ? ?? 32bit ? ??? Memory Limit ? ???? ???, 64 bit ? upgrade ? ?? ?????.
C. ????
i. log file ? trace ????? ?? /tmp ? 20MB ??? ?????.
2. MIGRATION ? ???
?? ?? ?? ?????? ???? DB2 V9.5 Migration ? ? ????? ????? ???.
?? ? ????? DB2 V9.5? Thread ????, DB2 V9.1.0.x ? Process ???? ?? ???????.
??, Process ??? Thread ??? ?? ??? ??? ???? Version ??? ????? ?????.
Process ??? heavy-weight ??? db2agent??? request? ?? db2gds? ????? ???? ? process? ???? ??? ???, Thread ??? light-weight ??? Proc-ess? ???? ??? ???? Thread? ?? ????, stack, register ?? ??? ?? ???.
?? ? ???? ???? ?? ????? ?????.
A. DB2 V9.1 ? V9.5? ??? ???? ??
i. V9.1.0.x ? ????
l ??? db2gds ????? db2agent? request ? ?? ????? spawn?? ???..
![](/files/fcFiles/Image/News Letter/NL_img_20091110_02.jpg)
l Memory ???
ii. V9.5 ? ????
l V9.5? thread ??? ???? ??, spawn ??? db2gds ? ??? ?? ? ? ????.
l Thread ?????? parent-child ??? ? ??? ?? ???? ???.
![](/files/fcFiles/Image/News Letter/NL_img_20091110_04.jpg)
l ?????
B. DB2 V9.5 ? ??
l Thread ???? ?? resource ??? ?? Performance ? ??.
l ?? ???? STMM (Self Tuning Memory Manager) ????.
l ??? Automatic Object Maintenance? Dynamically Performance ??.
l Flash Copy ??.
l DB2 HADR Cluster Setup ??.
l Automatic Storage ? reduce ????? ?? DBA ? ??? ???.
l Non-Root User? ????
è Instance ??? ????
è OS????? ??? ? ??.
è DPF ???? ??.
è ????? Configuration Assist? ??? ? ??.
è ?? ??? ???? ??
– IBM Data Studio
– DB2 Embedded Application Server (DB2 EAS)
– DB2 Query Patroller
– DB2 Net Search Extender
– Locally installed DB2 Information Center
|
?? ??? “Migration?? ? ?? ??” ? ??? ?????? ?? ??? ?????.
XpertMon for DB2 UDB V3
DB ???
Tel : 02-2108-1458
Fax : 02-2108-1459
URL : http://iteg.co.kr
|