Ȩ > ÀÚ·á½Ç > News Letter
 
Download
News Letter
Site Link
XpertMon ´º½º·¹ÅÍ 59È£ - DB2 V9.7 ÀÌÇØÇϱâ
2010/01/28 14:37 17889

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ÀÇ Æ¯Â¡À» Àü¹ÝÀûÀ¸·Î ÀÌÇØÇÏ°íÀÚ ÇÕ´Ï´Ù.

 

´ëÇ¥ÀûÀΠƯ¡Àº ¾Æ·¡¿Í °°½À´Ï´Ù.

  1. Partitioned indexes (Global Indexes à Local Indexes)
  2. Read Only Standby for HADR (Standby Only à Read Only)
  3. Oracle PL/SQL compatibility
  4. Enhanced compression
  5. Statement Concentrator (New : Using Parameter Marker)
  6. Online Table Move (New)
  7. 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’ °ªÀ» ³Ö¾îÁÖ¸é °¡´ÉÇÕ´Ï´Ù.

 

 

 

Bit Position

±â´É

Bit Position

±â´É

1 (0x01)

ROWNUM

7 (0x40)

DATE data type 1

2 (0x02)

DUAL

8 (0x80)

TRUNCATE TABLE

3 (0x04)

Outer join operator (+)

9 (0x100)

Character literals

4 (0x08)

CONNECT BY

10 (0x200)

Collection methods

5 (0x10)

NUMBER data type 1

11 (0x400)

Data dictionary-compatible views 1

6 (0x20)

VARCHAR2 data type 1

12 (0x800)

PL/SQL compilation 2

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¿¡ ´ëÇ¥ÀûÀÎ ±â´É¸¸À» ¾ð±ÞÇÏ¿´½À´Ï´Ù. Â÷ÈÄ ±â´Éµé¿¡ ´ëÇÑ ³»¿ëÀÌ Ãß°¡µÇ´Â ´ë·Î ÀÚ¼¼ÇÑ ³»¿ëÀ¸·Î Çѹø ´õ ã¾Æ ºËµµ·Ï ÇÏ°Ú½À´Ï´Ù.

¸ñ·Ï ±Û¾²±â ¼öÁ¤