Home > Dataroom > News Letter
 
Download
News Letter
Site Link
XpertMon ???? 59? - DB2 V9.7 ????
2010/01/28 14:37 13896

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

XpertMon ???? 60? - DB2 9.7 ??... ITEG 2010-02-10 13925
- XpertMon ???? 59? - DB2 V9.7 ?... ITEG 2010-01-28 13896
XpertMon ???? 58? - ????? ?? S... ITEG 2010-01-13 7934
List Write Modify