Skip to main content

Techdocs Library > White papers >

Performance Tuning BI on SAP NetWeaver Using DB2 for i5/OS and i5 Navigator



Document Author:

Susan Bestgen


Document ID:

WP101090


Doc. Organization:

Development


Document Revised:

08/20/2007


Product(s) covered:

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.

bi_whitepaper_p2.pdf



Classification:

Software

Category:

Performance

Solution(s):

Business Intelligence; Enterprise Application Solutions (EAS/ERP)

ISV(s):

SAP

Platform(s):

IBM System i

S/W Pillar(s):

Information Management

O/S:

i5/OS

Keywords:

BI, BW, SAP, ERP, Business Intelligence, Business Warehouse, DB2, i5/OS, Operations Navigator, i5 Navigator, performance


The Techdocs Library
Is this your first visit to Techdocs (the Technical Sales Library)?

Learn more


Techdocs QuickSearch

: