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
|