DB2 Universal Database for iSeries; IBM eServer iSeries; Operations Navigator; SAP
|Abstract: System i with DB2 for i5/OS leads the industry in SAP BI-D and SAP BW benchmark certifications with ten #1 certifications in the past two years. The article Industry Leading BI Performance With System i and DB2 for I5/OS Using BI on SAP NetWeaver describes the implementation of BI on SAP NetWeaverTM on System i and discusses technology features of DB21 which contribute to its performance success in the BI (Business Intelligence) technology segment. While hardware and software technology are key, performance improvements can almost always be achieved with intelligent tuning.|
This article is a follow-on to the aforementioned article and provides a step by step performance tuning scenario of the SAP BI-D benchmark queries using i5 Navigator.
Examples examined include:
.. Filtering plan cache statements to identify “expensive” queries
.. Using Visual Explain to graphically illustrate query implementation
.. Measuring impact of relevant indexes and MQTs for performance of BI queries
.. Utilizing DB2’s Index Adviser
While the examples used were specific to the BI-D benchmark queries, the steps performed and suggestions offered could apply to any application which generates similar queries.
Business Intelligence; Enterprise Application Solutions (EAS/ERP)
IBM System i Family
BI, BW, SAP, ERP, Business Intelligence, Business Warehouse, DB2, i5/OS, Operations Navigator, i5 Navigator, performance
|Is this your first visit to Techdocs (the Technical Sales Library)?