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