DB2 V9.5 ?? Migration ?? ? TIP-2
?????. DB2 ? XpertMon ??? ???! ? ????????? DB??????.
?? ?? XpertMon ????? ?? ??? ???? ???? ? ? ???? ????? ?? ?? ??? ?? ???, XpertMon? ??? ????? ?? ???? History? ????(DPF, OLTP, Batch …) ? ?? ??? KPI? ???? ?? ?? ???? ? ??? ??? ????. ?? ???? ???? ???? ????? ??? ???? ?? ???? ?????.
?? ?? ??? “Migration ?? ? DB2 V9.5? ???? ??” ? ?? ?? ????? ?????.
???? ?? ????? ???, ?? ?????? ?? ???? ( www.iteg.co.kr) ???? ????? ?? ? ????. ???? ?? ?? ???? ??? ??? ??? ??????. ???? ????? ?????.
AGENDA
1. ????
A. DB2 version check
B. OS pre-requirement
3. MIGRATION ? ???
A. DB2 V9.1 ? V9.5 ? ????
B. DB2 V9.5 ? ??
3. MIGRATION ? ??
A. “db2imigr” ? ???? ??
B. “Side-by-Side” ? ???? ??
4. MIGRATION ? ???? ??
3. MIGRATION ? ?? ? ??? ??
?? Section ?? ??? ??? ?????? ?? ????? DB2 V9.5? Migration? ???? ?????.
Migration? “db2imigr”? ?? ???? ??? ?? image? backup ?? ? DB2 V9.5 ?? restore ?? ??, ?? ???? ?? ??? ?? ? ????.
????, ?? ? ?? ??? ??? ????? ?????.
A. In-place ??
i. “db2imigr” ? ?? Migration ????, ??? command? ?? migration? ???? ?????.
ii. ??
? ?? migration ?? ?? instance ? DB2 V9.5 ??? ?? ??? “db2imigr” ? ???? “db2ckmig” ? ?????.
????> db2ckmig <-e|db_name> -l logpath [-u user] [-p passwd]
l “db2ckmig” ?? ? ???? ??? ??? ????.
ü ???? ? DB ??
ü DB ?? ?? (?? ??, ???? ??, ???? ?? ?)
ü ??????? ?? ?? ??
ü UDT, Array, Binary, Decfloat, Varbinary, XML? ?? ?? ??
ü ??? ?? DATALINK ??? ?? ?? ?? ??
ü Migration ? ???? ??? ?????
ü HADR ?? ?? (Primary ?? ?? ????)
ü SYSCATSPACE? DMS? ???? ???, ?? ?? ??? ? ???? ?? ?? 50% ??? ?? ??? ?? ? ??
l “db2ckmig” ?? ???????.
l logpath ?? /data/iteg04/ckmig.out ? ?? ?? ??? ????.
l “db2ckmig” ? ?? ?? “Successful” ???? ????, “db2imigr” ? ?????.
? ??? ???? Instance ? migration ? ? ????.. [user : root]
????> db2imigr [-a AuthType] -u FencedID InstName
l “db2imigr” ?? ???????.
l $DB2_HOME ?? migration.log ?? output ? ?????.
l ????? Instance? Migration ? ?? $DB_HOME ? migration.log ? ????, ??? ?? ???? ?????.
? db2level ? ??? Instance ? DB2 v9.5 ? ?????? ????, ??? ??? Database? ??? ??? ??? ???.
l ??? ?? “????? ?? DB ? migration ????” ?? ???? ???? ?? DB? migration??????.
? Instance? Migration ? ??? ?? ?? Database? Migration ????.
????> db2 migrate db DB?
l ??? ?? ??? ???? Migration??? ??? ? ????.
B. Side-By-Side ??
i. Backup and Restore
? ??, ?? Version??? Offline-Full Backup ? ?????.
? V95 ???? ??? INSTANCE? Backup Image ? restore ???.
* DAS Migration - ?? DAS ?? ? “dasmigr” ?? ???? ???..
4. MIGRATION ? ?? ? ??? ??
?? Section ?? ??? ??? ?????? ?? ????? DB2 V9.5? Migration? ???? ?????.
Migration? “db2imigr”? ?? ???? ??? ?? image? backup ?? ? DB2 V9.5 ?? restore ?? ??, ?? ???? ?? ??? ?? ? ????.
????, ?? ? ?? ??? ??? ????? ?????.
B. In-place ??
iii. “db2imigr” ? ?? Migration ????, ??? command? ?? migration? ???? ?????.
iv. ??
? ?? migration ?? ?? instance ? DB2 V9.5 ??? ?? ??? “db2imigr” ? ???? “db2ckmig” ? ?????.
????> db2ckmig <-e|db_name> -l logpath [-u user] [-p passwd]
l “db2ckmig” ?? ? ???? ??? ??? ????.
ü ???? ? DB ??
ü DB ?? ?? (?? ??, ???? ??, ???? ?? ?)
ü ??????? ?? ?? ??
ü UDT, Array, Binary, Decfloat, Varbinary, XML? ?? ?? ??
ü ??? ?? DATALINK ??? ?? ?? ?? ??
ü Migration ? ???? ??? ?????
ü HADR ?? ?? (Primary ?? ?? ????)
ü SYSCATSPACE? DMS? ???? ???, ?? ?? ??? ? ???? ?? ?? 50% ??? ?? ??? ?? ? ??
l “db2ckmig” ?? ???????.
l logpath ?? /data/iteg04/ckmig.out ? ?? ?? ??? ????.
l “db2ckmig” ? ?? ?? “Successful” ???? ????, “db2imigr” ? ?????.
? ??? ???? Instance ? migration ? ? ????.. [user : root]
????> db2imigr [-a AuthType] -u FencedID InstName
l “db2imigr” ?? ???????.
l $DB2_HOME ?? migration.log ?? output ? ?????.
l ????? Instance? Migration ? ?? $DB_HOME ? migration.log ? ????, ??? ?? ???? ?????.
? db2level ? ??? Instance ? DB2 v9.5 ? ?????? ????, ??? ??? Database? ??? ??? ??? ???.
l ??? ?? “????? ?? DB ? migration ????” ?? ???? ???? ?? DB? migration??????.
? Instance? Migration ? ??? ?? ?? Database? Migration ????.
????> db2 migrate db DB?
l ??? ?? ??? ???? Migration??? ??? ? ????.
C. Side-By-Side ??
ii. Backup and Restore
? ??, ?? Version??? Offline-Full Backup ? ?????.
? V95 ???? ??? INSTANCE? Backup Image ? restore ???.
* DAS Migration - ?? DAS ?? ? “dasmigr” ?? ???? ???..
4. MIGRATION ? ???? ??
A. ??? V9.5 ??
DB2 9.1 Component Name
|
DB2 9.5 Component Name
|
DB2 Client
|
IBM Data Server Client
|
DB2 Runtime Client
|
IBM Data Server Runtime Client
|
IBM DB2 Driver for JDBC and SQLJ
|
IBM Data Server Driver for JDBC and SQLJ
|
IBM DB2 Driver for ODBC and CLI
|
IBM Data Server Driver for ODBC and CLI
|
DB2 Developer Workbench
|
IBM Data Studio
|
i. DB2 V9.5?? Migration? ???? ???, DB2 ?????? ?? Migration ??? ??? ?????.
ii. DB2 V8.X ? DB2 V9.1 Client ? ?? DB2 V9.5?? ??? ????, DB2 V7.X ? ?? ??? ? ?? ???? ????.
iii. DB2 ESE ?? ??? ??? DPF(Database partitioning Feature)? “DB2 Enterprise Warehouse Feature)” ? ??? ????? ??? License? ???????.
B. ??? V9.5 ??
i. ???? DB ???? ??
ü Processing ?? à Multi-Thread ??
ü ???? Resource ??
ü ?? ?? ?? ???? ????: $> db2pd –edus
?) Memory Model ? ???
i. STMM (Self Tuning Memory Manager) : Memory ?? ?????? ?? “Automatic”?? ?????? ??????? ???.
ii. INSTANCE_MEMORY : “Automatic”?? ? ??? ??, ?? Main Memory ? 75~95% ??? ??
iii. APPL_MEMORY: “Automatic”?? ? ??? ??, ???? ??? ?? ? ? ??? ?? ?? ???.
iv. DB2_MEM_TUNING_RANGE: STMM ? ??? ?? INSTANCE? ??? ?? Memory ?
http://publib.boulder.ibm.com/infocenter/db2luw/
v9r5/topic/com.ibm.db2.luw.admin.perf.doc/doc/c0011762.html
?) AGENT ?????
i. NUM_POOLAGENTS, MAX_COORDAGENTS, MAX_CONNECTIONS, FENCED_POOL ?? ??Parameter ?? ??? “Automatic” ?? ???.
ii. ??? Registry ?? ? DB????
ü DB2_UPDDBCFG_SINGLE_DBPARTITION: DPF ?? ?? DB?? ?? ???? DB?? Parameter ?? ????? ? ? ????, ???? NO.
ü YES ? ?? ?: UPDATE ? RESET DB CFG ?? dbpartitionnum ??? ???? ?? ???.
?) ??? DBM CFG ??
i. AGENT_STATCK_SZ : Windows ????? ???? ?? ?? ????? ???.
ii. MON_HEAP_SZ, FENCED_POOL : Default ?? “Automatic”?? ???.
?) ??? DB CFG ??
i. APPLHEAPSZ, DATABASE_MEMORY, SORTHEAP, DBHEAP, STAT_HEAP_SZ, STMTHEAP, SHEPTHRES_SHR: Default?? “Automatic”?? ???.
iii. ??? DDL
ü File-System? ???? Tablespace??? “NO FILE SYSTEM CACHING” ?? ???.
ü ????? ??? Tablespace? ??? “ALTER TABLESPACE <??????? ?> REDUCE “ ??? ??? ?? ????.
ü DDL ??? ???? ?? ???.
iv. ??? DB Operation ??
?) ????????
i. DB CFG? “AUTO_MAINT” ?? ON?? ???.
ii. “AUTO_STMT_STATS”? ON?? ?????, ??? ???? ?? ????? ??? ? ??.
iii. ????: ?? “CATALOGCACHE_SZ” ? 25% ?????? “AUTOMATIC”?? ?????? ?? ??.
v. ??? Application ??
ü DB? ?? Migration ? runtime library? ?? rebind??? ???.
ü DB2 V8 32bit ?? DB2 V9.5 64bit?? Migration? DB2 V8? Fix pack 6??? ??? SQL Procedure? ??? ???? ???.
ü JAVA Application? ?? Migration
i. DB2 JDBC Type 3 Driver ?? : ??? Migration ?? ?.(DB2 V9.1?? ????)
ii. DB2 JDBC Type 2 Driver ?? : ??? ???? Migration ???.
iii. ??? PHP Extension ??
iv. ??? IBM_DB2 ? ?? ??? PDO_IBM extension? ?? ?.
vi. ??? UTIL ? TOOL
?) Explain ? ??
i. ? ????? Timeron Cost? ?? ??? ???.
?) Index Builder ? Intra-parallel ??? ???? ??]
i. DBM CFG ? INTRA_PARALLEL ???? ???.
?) ??????(RHF: Recovery History File)? ?? ?? prune ??
i. ?? PRUNE HISTORY??? ?? ???? ???? ?? DB CFG ? AUTO_DEL_REC_OBJ ?? ON ?? ???? ???? ?? ????? ?.
?) DPF????? ?? ????
i. BACKUP DATABASE ??? “ON DBPARTITIONNUM” ??? ???? ?? Partition ?? ?? Partition? ?? BACKUP ????? ????.
ii. Roll Forward ? “END OF BACKUP” ???? ?? DPF DB ???? ??.
vii. ??? ???? ??
?) ??? Logging ??? ??
i. db2diag.log ? ADM ???? ????? ?.
ii. “db2diag.log -e ADM ” ??? ?? db2diag.log ???? ADM???? Filtering ???.
?) ?? ??? ?????
i. PD_GET_DIAG_HIST : ???? ? ???? ??? SQL? ?? ???? ?.
?) Lock Timeout ??? ??
i. “DB2_CAPTURE_LOCKTIMEOUT” registry?? ??
- ??? ? “DB2DIAGPATH” ??? LockTimeout? ???? Application? ?? ??? ???
?) Snapshot Database ? ??? ??
i. ????????? ??? ?? ??? ??? ???.
- STATS_CACHE_SIZE, STATS_FABRICATIONS, SYNC_RUNSTATS, ASYNC_RUNSTATS, STATS_FABRICATE_TIME, SYNC_RUNSTATS_TME
viii. ??? ?? View ? Routine
DB2 V9.1
|
DB2 V9.5
|
ADMIN_GET_TAB_INFO ??? ??
|
ADMINTABINFO ?? ?
ADMIN_GET_TAB_INFO_V95 ??? ??
|
SNAP_GET_APPL ??? ??
|
SNAPAPPL ?? ?
SNAP_GET_APPL_V95 ??? ??
|
SNAP_GET_APPL_INFO ??? ??
|
SNAPAPPL_INFO ?? ?
SNAP_GET_APPL_INFO_V95 ??? ??
|
SNAP_GET_BP ??? ??
|
SNAPBP ?? ?
SNAP_GET_BP_V95 ??? ??
|
SNAP_GET_DB_V91 ??? ??
|
SNAPDB ?? ?
SNAP_GET_DB_V95 ??? ??
|
SNAP_GET_DBM ??? ??
|
SNAPDBM ?? ?
SNAP_GET_DBM_V95 ??? ??
|
SNAP_GET_DYN_SQL_V91 ??? ??
|
SNAPDYN_SQL ?? ?
SNAP_GET_DYN_SQL_V95 ??? ??
|
|