DB2 V9.7 ÀÌÇØÇϱâ
DB2 V8.2ÀÇ 2009³â4¿ù30ÀϺηΠEOS(End Of Service)°¡ µÇ¾ú°í, ÇöÀç ¾ÈÁ¤ÀûÀ¸·Î »ç¿ëµÇ°í ÀÖ´Â DB2 V9.1Àº Fix Pack No.8±îÁö Ãâ½ÃµÈ »óÅÂÀÔ´Ï´Ù. DB2 Engine ¹æ½ÄÀÌ Process¿¡¼ Thread·Î º¯°æµÈ DB2 V9.5°¡ 2007³â12¿ù14ÀÏ GAµÈ ÀÌÈÄ ±â´ÉÀÌ ±Þ°ÝÈ÷ Çâ»óµÇ°í ÀÖ½À´Ï´Ù.
ÇöÀç´Â DB2 V9.7ÀÌ 2009³â8¿ù24ÀÏ¿¡ GAµÇ¾ú°í, DB2 pureScaleÀº 2009³â12¿ù11ÀÏ¿¡ GAµÇ¾ú½À´Ï´Ù.
<±×¸²1 : ÇöÀç±îÁöÀÇ DB2 Version º° GA¿Í EOS>
À̹ø È£¿¡¼´Â DB2 V9.7ÀÇ Æ¯Â¡À» Àü¹ÝÀûÀ¸·Î ÀÌÇØÇÏ°íÀÚ ÇÕ´Ï´Ù.
´ëÇ¥ÀûÀΠƯ¡Àº ¾Æ·¡¿Í °°½À´Ï´Ù.
- Partitioned indexes (Global Indexes à Local Indexes)
- Read Only Standby for HADR (Standby Only à Read Only)
- Oracle PL/SQL compatibility
- Enhanced compression
- Statement Concentrator (New : Using Parameter Marker)
- Online Table Move (New)
- Scan Sharing (New)
ÀÌÁ¦, ÇϳªÇϳªÀÇ Æ¯Â¡À» °£·«ÇÏ°Ô »ìÆ캸µµ·Ï ÇÏ°Ú½À´Ï´Ù.
1. Partitioned indexes
DB2 V9.5¿¡¼´Â Global Index¸¸À» Áö¿øÇÏ¿© detach/attach ½Ã Index-Rebuild¿¡ ¸¹Àº Cost°¡ ¹ß»ýÇÏ¿´½À´Ï´Ù. ±×·¯³ª, DB2 V9.7¿¡¼´Â Local Index¸¦ Áö¿øÇÏ°Ô µÇ¾î º¸´Ù ºü¸¥ µ¥ÀÌÅÍ Roll In & Roll Out, ÇÊ¿äÇÑ Partition¸¸ Reorg °¡´É ¹× ºÒÇÊ¿äÇÑ PartitionÀ» ½Å¼ÓÈ÷ Detach ÇÒ ¼ö ÀÖ°Ô µÇ¾ú½À´Ï´Ù
<±×¸²2 : V9.5 ¿Í V9.7 ÀÇ Index ±¸¼ººñ±³>
2. Read Only Standby for HADR (High Availability and Disaster Recovery)
V9.5±îÁöÀÇ HADR ±¸Á¶´Â Primary – Standby ÀÇ ±¸Á¶¿´´Ù°í º¸¸é, V9.7¿¡ Fix Pack No.1ÀÌ Àû¿ëµÇ¸é¼ Standby Server¿¡ ´ëÇÑ “Read-Only”°¡ °¡´ÉÇÏ°Ô µÇ¾ú½À´Ï´Ù.
¹°·Ð, ¸î °¡Áö Parameter setting Àº ÇÊ¿äÇÕ´Ï´Ù.
¾Æ·¡ÀÇ db2 registry variable À» setting ÇÑ ÀÌÈÄ¿¡¾ß Standby Server ÀÇ “Read-Only” ¸¦ È®ÀÎÇÒ ¼ö ÀÖ½À´Ï´Ù.
<±×¸²3 : HARD with Reads on Standby>
¸¸¾à, Primary Server¿¡¼ ¾Æ·¡ÀÇ ÀÛ¾÷ÀÌ ¹ß»ýµÉ °æ¿ì¿¡´Â Standby ServerÀÇ ¸ðµç Application ÀÌ ²÷¾îÁö°Ô µÇ¾î ÀÖÀ¸¹Ç·Î Standby Server¸¦ ¿øÈ°È÷ »ç¿ëÇÏ°íÀÚ ÇÑ´Ù¸é ÇØ´ç »çÇ×À» À¯³äÇÏ¿©¾ß ÇÕ´Ï´Ù.
3. Oracle PL/SQL compatibility
V9.7ÀÇ °¡Àå Å« Ư¡ ÁßÀÇ Çϳª·Î Oracle Migration½Ã ƯÈ÷ ¸¹ÀÌ »ç¿ëµÇ´Â OracleÀÇ ROWNUM, DUAL, TRUNCATE, CONNECT BY µîÀÇ ConversionÀÌ ¿ÏÀüÈ÷ ±¸ÇöµÇ¾ú´Ù°í ÇÒ ¼ö ÀÖ½À´Ï´Ù.
´Ü¼øÈ÷ ³»ºÎ DB2ÀÇ Function µéÀ» Á¶ÇÕÇÑ ÇüŶó¸é ConversionÀ¸·Î ÀÎÇÑ Cost°¡ ³ô¾ÆÁö°ÚÁö¸¸, ¾Æ·¡ÀÇ ±×¸²Ã³·³ “PL/SQL Native Compiler” ¹× “Source Level¿¡¼ÀÇ Debugging”ÀÌ °¡´ÉÇÔÀ¸·Î ÀÎÇØ Cost ¹× Performance¿¡ ´ëÇÑ Issue¸¦ ¾ø¾Ù ¼ö ÀÖ½À´Ï´Ù. ½ÇÁ¦ °í°´»çÀÌÆ®¿¡¼´Â 96%ÀÌ»óÀÇ PL/SQLÀ» ±×´ë·Î »ç¿ëÇÏ°Ô µÇ¾ú´Ù°í ÇÕ´Ï´Ù.
<±×¸²4 : DB2 Engine ³»¿¡¼ PL/SQL ó¸®È帧>
¸¸¾à, ÇØ´ç ±â´ÉÀ» »ç¿ëÇϱâ À§Çؼ´Â ¾Æ·¡ÀÇ DB2 Registry Variable SettingÀÌ ¿Ï·áµÈ ÀÌÈÄ¿¡ °¡´ÉÇÕ´Ï´Ù. ƯÁ¤ OracleÀÇ ±â´É¸¸À» »ç¿ëÇÏ°íÀÚ ÇÑ´Ù¸é ¾Æ·¡ÀÇ ‘ORA’ ´ë½Å ±â´É¿¡ µû¸¥ ‘Bit Position’ °ªÀ» ³Ö¾îÁÖ¸é °¡´ÉÇÕ´Ï´Ù.
http://publib.boulder.ibm.com/infocenter/db2luw
/v9r7/topic/com.ibm.db2.luw.apdv.porting.doc/doc/
r0052867.html?resultof=%22%52%4f%57%4e%55%
4d%22%20%22%72%6f%77%6e%75%6d%22%20
4. Enhanced compression
±âÁ¸ V8, V9.1, V9.5·Î DB2°¡ System default °ª¸¸À» CompressÇÏ´ø ¶§º¸´Ù ÇöÀúÇÏ°Ô Çâ»óµÇ¾ú½À´Ï´Ù. V9.7ÀÇ °æ¿ì, ÀÌÀü¿¡ Á¦°øµÇÁö ¾Ê´ø INDEX, Temporary Table, LOB CompressionÀÌ ÇöÀúÈ÷ ÁÁ¾ÆÁö¹Ç·Î ÀÎÇØ Storage Àý°¨¿¡ ¸¹Àº ±â¿©¸¦ ÇÒ ¼ö ÀÖ°Ô µÇ¾ú½À´Ï´Ù.
IBMÀÇ ºñ±³ÀÚ·á¿¡ µû¸£¸é Oracle Databaseº¸´Ù 50% »¡¶óÁö°í, SQL Server º¸´Ù 5¹è ºü¸£¸ç ÀÌ¿¡ Æ®·£Àè¼Ç¿ë ½Ã½ºÅÛÀÇ ¼¹ö ºñ¿ë Àý°¨À» °¡Á® ¿Ô´Ù°í ÇÕ´Ï´Ù.
<±×¸²5 : Compress ±â´É°³¼±°ú Performance>
5. Statement Concentrator
¾Æ·¡ÀÇ ±×¸²Ã³·³, WhereÀýÀÇ Á¶°ÇÀÌ literal·Î µÇ¾î ÀÖÀ» °æ¿ì, DB2´Â °¢°¢ÀÇ SQLÀ» compiling ÇÏ´Â ´Ü°è¸¦ °ÉÄ£ ÀÌÈÄ¿¡¾ß ½ÇÇàÀÌ °¡´ÉÇÕ´Ï´Ù. ±×·¯³ª, V9.7¿¡¼´Â ÀÌ·± LiteralÀ» Parameter Marker·Î ó¸®ÇÏ¿© Compile ¼ö¸¦ ÁÙ¿© ½ÇÇàÇÏ°Ô²û “Statement Concentrator”¸¦ Áö¿øÇÕ´Ï´Ù.
<±×¸²5 : V9.7ÀÇ Statement Concentrator>
À§ÀÇ ±â´ÉÀ» »ç¿ëÇϱâ À§Çؼ´Â DB CFGÀÇ “STMT_CONC”¸¦ ¾Æ·¡¿Í °°ÀÌ º¯°æÇÑ ÈÄ »ç¿ëÇÏ¿©¾ß ÇÕ´Ï´Ù. ÇØ´ç configuration variableÀº OFF/LITERALS µÎ °¡ÁöÀÇ °ªÀ¸·Î update °¡´ÉÇÕ´Ï´Ù.
6. Online Table Move
V9.7¿¡¼´Â ¼Õ½±°Ô TableÀ» online½Ã move ÇÒ ¼ö ÀÖ´Â ±â´ÉÀÌ Ãß°¡µÇ¾ú½À´Ï´Ù. “Online Table Move”´Â Source tableÀ» Target table·Î move ½ÃÅ°´Â µ¿¾È ¹ß»ýÇÏ´Â transactionÀ» Staging Table ¿¡ ÀûÀç ÈÄ, Target Table¿¡ Àû¿ëÇÑ ÈÄ ÀÚµ¿ »èÁ¦µÇ´Â FlowÀ» °¡Áö°í ÀÖ½À´Ï´Ù.
¸¸¾à, Online Table Move½Ã FailÀÌ ³¯ °æ¿ì´Â ¾Æ·¡ÀÇ StepÀ» ÁøÇàÇØÁà¾ß ÇÕ´Ï´Ù.
l ½ÇÆÐ ½Ã SYSTOOLS.ADMIN_MOVE_TABLE protocol table ¿¡¼ ÇØ´ç tableÀÇ »óŸ¦ È®ÀÎÇÑ ÈÄ ÀûÀýÇÑ StepÀ» ÁøÇàÇØ¾ß ÇÕ´Ï´Ù.
¨ç If the status of the procedure is INIT, use the INIT option.
¨è If the status of the procedure is COPY, use the COPY option.
¨é If the status of the procedure is REPLAY, use the REPLAY or SWAP option.
¨ê If the status of the procedure is CLEANUP, use the CLEANUP option.
|
7. Scan Sharing
ÀÌ ±â´ÉÀº Large tableÀÇ MDC Block Index ScanÀ̳ª, Table Scan µîÀÇ Cost°¡ ³ôÀ» ¼ö ¹Û¿¡ ¾ø´Â ÀÛ¾÷¿¡ ´ëÇØ º¸¿ÏµÈ Feature·Î½á, ¾Æ·¡¿Í °°Àº ÀåÁ¡À» µé ¼ö ÀÖ½À´Ï´Ù.
- °³¼±µÈ Concurrency
- º¸´Ù »¡¶óÁø Query Response Time
- Áõ°¡µÈ Throughput
¶Ç, ÇØ´ç ±â´ÉÀº Isolation LevelÀÌ RRÀ̳ª RSº¸´Ù´Â CS³ª URÀÇ application¿¡ Àû¿ëÇÒ °ÍÀ» ±ÇÀåÇÏ°í ÀÖ½À´Ï´Ù.
<±×¸²6 : V9.7ÀÇ Scan Sharing>
¼º´ÉÀûÀÎ Ãø¸é¿¡¼, IBMÀÇ º¸°í³»¿ë¿¡ µû¸£¸é MDC Block Index Scan SharingÀÇ °æ¿ì´Â Æò±Õ 47%ÀÇ query ¼º´É°³¼±ÀÌ ÀÖ¾úÀ¸¸ç, ±× Áß ½ÇÇà½Ã°£ÀÌ 56%±îÁö ÁÁ¾ÆÁø queryµµ ÀÖ¾ú´Ù°í ÇÕ´Ï´Ù.
À̹ø È£¿¡¼´Â °£´ÜÈ÷ V9.7¿¡ ´ëÇ¥ÀûÀÎ ±â´É¸¸À» ¾ð±ÞÇÏ¿´½À´Ï´Ù. Â÷ÈÄ ±â´Éµé¿¡ ´ëÇÑ ³»¿ëÀÌ Ãß°¡µÇ´Â ´ë·Î ÀÚ¼¼ÇÑ ³»¿ëÀ¸·Î Çѹø ´õ ã¾Æ ºËµµ·Ï ÇÏ°Ú½À´Ï´Ù.
|