cancel
Showing results for 
Search instead for 
Did you mean: 

Any performance gain after upgrade db2 9.7 to 10.5

Former Member
0 Kudos

Dear All

    Any one can share the actual performance gain on SAP after upgrade db2 from 9.7 to 10.5? many thanks!!

Regards

David Shum

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member264034
Active Contributor
0 Kudos

Dear David,

The following SCN thread may help:

http://scn.sap.com/thread/3422189 "Want opinion on performance"

IBM Upgrading to DB2 Version 10.5 roadmap - United States

"Adopting new DB2 Version 10.5 functionality​​"

https://service.sap.com/~sapidb/011000358700000843422013E/DB6UpgrGuide10_5_Vers102.pdf


Performance Improvements

New functions have been designed for DB2 10.1 to improve performance,

for example, smarter index prefetching, hash join improvements, zigzag

joins, and early aggregation.

IBM DB2 Version 10.5 for Linux, UNIX, and Windows English manuals - United States

"Troubleshooting and Tuning Database Performance"

1851853 - DB6: Using DB2 10.5 with SAP Applications

Column-Organized Tables with BLU Acceleration

Column-organized tables add columnar capabilities to DB2 databases. Data is
stored with column organization, allowing vector processing of column data. This
table format is aimed at providing performance improvements for OLAP workloads.

Kind Regards,
Aidan

Former Member
0 Kudos

Dear Aidan

      Could you please kindly provide the figure which contain "statistic stick to table level of SAP(say BW) that can indicate about performance gain(Row DB to Column DB)" in term of percentage" Many Thanks!!

Regards

David Shum

former_member264034
Active Contributor
0 Kudos

Dear David,

The following link discusses the benefits of BLU Acceleration(Row Db to Column DB).

IBM DB2 with BLU Acceleration speeds analytics

Features and Benefits of DB2 10.5

IBM DB2 for Linux, UNIX and Windows features and benefits

SCN thread with similar query:
http://scn.sap.com/thread/3348378

I hope that this is helpful.

Kind Regards,
Aidan