This IBM Redbook describes the benefits of DB2 V8 for SAP Business Information Warehouse. It covers best practices, and provides performance and tuning recommendations.
SAP Business Information Warehouse is the central reporting tool for almost all SAP business solutions. It is based on building blocks called InfoObjects that contain data about customers, sales, and business information.
InfoObjects include InfoSources, ODS objects, and InfoCubes. The business intelligence solution from IBM and SAP can help you aggregate and leverage this information, giving you a system-wide view of your business data and delivering it across your enterprise to support sound business decisions.However, this structure can lead to slow performance if the system is not set up and managed according to good database principles.
This redbook describes best practices for this product on a zSeries platform, and provides performance and tuning recommendations for loading and querying data. It also addresses general system administration and troubleshooting.The audience for this redbook includes SAP and DB2 administrators. Knowledge of these products and of the z/OS environment is assumed.
Useful E-Book :
-
SAP R/3 on DB2 UDB for OS/390: Application Servers on OS/390
-
SAP R/3 on DB2 for OS/390: Implementing with AIX or Windows NT Applications
Servers -
SAP R/3 on DB2 for OS/390: Database Availability Considerations
-
SAP on DB2 Universal Database for OS/390 and z/OS: Multiple Components in
One Database (MCOD) -
SAP on DB2 UDB for OS/390 and z/OS: Implementing Application Servers on
Linux for zSeries -
SAP on DB2 UDB for OS/390 and z/OS: High Availability Solution Using System
Automation -
SAP on DB2 for z/OS and OS/390: High Availability and Performance Monitoring
with Data Sharing -
New Enterprise Integration Functions for Lotus Domino for AS/400
-
Integrating WebSphere Commerce with SAP R/3 Using WebSphere InterChange
Server -
Implementing SAP R/3 4.5B Using Microsoft Cluster Server on IBM Netfinity
Servers -
IBM Content Manager CommonStore Version 7 for Domino, Exchange, and SAP
-
Enterprise Business Portals II with IBM Tivoli Access Manager
-
End-to-End Scheduling with OPC and TWS Mainframe and Distributed
Environments -
DB2 UDB for z/OS V8: Through the Looking Glass and What SAP Found There
-
Database Administration Experiences: SAP R/3 on DB2 for OS/390
-
Building and Scaling SAP Business Information Warehouse on DB2 UDB ESE
-
Best Practices for SAP Business Information Warehouse on DB2 for z/OS V8
-
Backup Solutions for SAP R/3 4.5B on Netfinity Servers running Windows NT
-
A Holistic Approach to a Reliable Infrastructure for SAP R/3 on AIX
-
A B2B Solution using WebSphere Business Integration V4.1 and WebSphere
Business Connection V1.1