on 07-27-2015 11:41 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.