DB2 V9.5 ?? Migration ?? ? TIP-1    

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

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

l  Memory ???

               ii.         V9.5 ? ????

l  V9.5? thread ??? ???? ??, spawn ??? db2gds ? ??? ?? ? ? ????.

l  Thread ?????? parent-child ??? ? ??? ?? ???? ???.

                                               

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