Front cover -- Contents -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Introduction -- Management summary -- Structure of the redbook -- Chapter 1. SAP Business Information Warehouse (BW) -- 1.1 Data warehousing -- 1.1.1 Informational databases -- 1.1.2 Data warehousing -- 1.2 SAP BW positioning -- 1.3 SAP business solutions -- 1.4 SAP NetWeaver -- 1.5 SAP Business Intelligence and SAP BW -- 1.6 SAP BW customer scenario -- 1.7 Requirement for scalability -- Chapter 2. SAP BW technical overview -- 2.1 SAP BW information model -- 2.2 Dataflow in SAP BW -- 2.3 Information access -- 2.4 Hierarchies -- 2.5 Extended star schema (InfoCubes) -- 2.6 Dataload into InfoCube -- 2.7 Aggregates -- 2.7.1 Aggregate example -- 2.7.2 Maintaining aggregates -- 2.8 Compression of requests -- 2.9 Operational data store (ODS) -- 2.10 The SAP BW functional components -- 2.11 SAP BW business content -- Chapter 3. DB2 UDB ESE technical overview -- 3.1 The architecture -- 3.2 Functions and components -- 3.2.1 Database objects -- 3.2.2 Concurrency, locking and isolation levels -- 3.2.3 Parallel processing and partitioning -- 3.2.4 Cost-based optimizer -- 3.2.5 Join methods for distributed tables -- 3.2.6 Static and dynamic SQL statements -- 3.2.7 DB2 64-bit -- 3.3 DB2 monitoring and tuning tools -- 3.4 DB2 Version 8: a few highlights -- 3.4.1 Catalog caching -- 3.4.2 RUNSTATS enhancements -- 3.4.3 Multi-dimensional clustering -- 3.4.4 Concurrency features -- 3.4.5 High availability features -- 3.4.6 Connection concentrator -- 3.4.7 Merge statement -- 3.4.8 Multi-FixPak install for UNIX -- Chapter 4. Building SAP BW on DB2 -- 4.1 Value of building SAP BW on DB2 UDB ESE -- 4.1.1 Scalability -- 4.1.2 High performance -- 4.1.3 Ease of administration -- 4.2 Business advantage: the value proposition.

4.2.1 Low TCO -- 4.2.2 Reduced sizing risk and cost -- 4.3 SAP BW on DB2: value details -- 4.3.1 Architecture and features -- 4.3.2 Database layout -- 4.3.3 Parallel processing on multiple database partitions -- 4.3.4 Intra-partition parallelism -- 4.3.5 SAP BW query processing on DB2 -- 4.3.6 Use of distribution statistics for query optimization -- 4.3.7 New features of the DBA Cockpit 6.40 -- Chapter 5. Project test environment -- 5.1 Hardware configuration -- 5.2 Software configuration -- 5.2.1 Operating system -- 5.2.2 Database management system -- 5.2.3 SAP Business Information Warehouse -- 5.2.4 Front-end software -- 5.3 Installation, scaling, and performance test scenarios -- 5.4 SAP BW sample application -- Chapter 6. Implementing SAP BW on DB2 -- 6.1 Sizing SAP BW on DB2 -- 6.2 Implementation approaches -- 6.2.1 The Implementation Assistant -- 6.3 Preinstallation activities -- 6.3.1 Component considerations -- 6.4 Installation planning -- 6.4.1 The SAP Installation Notes -- 6.4.2 The installation checklists -- 6.4.3 System planning and preparation -- 6.5 Installation procedure -- 6.5.1 Installing the IBM DB2 Universal Database -- 6.5.2 Installing the Central Instance -- 6.5.3 Installing the SAP Database Instance -- 6.6 Post-installation activities -- 6.6.1 Additional post-installation activities -- 6.7 Business Information Warehouse definitions -- 6.7.1 BW general settings -- 6.7.2 Installing the SAP Business Content Add-on -- 6.7.3 Installing an additional Dialog Instance -- 6.8 HACMP for high availability -- 6.8.1 High availability and fault tolerance -- 6.8.2 HACMP clusters -- Chapter 7. Administration of SAP BW -- 7.1 Role-based administration -- 7.2 DB2 UDB administration -- 7.3 Periodic activities -- 7.3.1 Storage management -- 7.3.2 Tablespace and container administration -- 7.3.3 The optimizer and runstats.

7.3.4 Tablespace reorganization -- 7.4 Backup and recovery -- 7.4.1 Defining a backup/recovery strategy and policy -- 7.4.2 Managing the DB2 UDB logfiles -- 7.4.3 Performing DB2 UDB backups -- 7.4.4 Database recovery -- 7.5 Authorization to administer SAP BW -- 7.6 Archiving SAP BW data -- Chapter 8. SAP BW performance -- 8.1 The approach -- 8.2 Health check -- 8.2.1 SAP Notes related to performance and system configuration -- 8.2.2 How to keep DB2 database statistics current with SAP BW -- 8.2.3 How to control DB2 log space consumption with SAP BW -- 8.2.4 Recommended configuration parameters -- 8.3 Performance tuning -- 8.3.1 General SAP BW tuning -- 8.3.2 Tuning DB2 UDB ESE -- 8.4 Performance monitoring of SAP BW on DB2 UDB -- 8.4.1 Performance bottlenecks -- 8.4.2 Proactive monitoring -- 8.4.3 Problem analysis and resolution -- Chapter 9. Scaling out the database -- 9.1 Options for installing and scaling the database -- 9.2 Scaling steps -- 9.2.1 Partitioning the database -- 9.2.2 Relocating database containers -- 9.2.3 Moving database partitions to another server -- 9.3 Summary -- Chapter 10. Scalability factors of SAP BW on DB2 UDB ESE -- 10.1 DB2 scalability studies -- 10.2 Performance study for SAP BW on DB2 UDB EEE -- 10.2.1 Hardware environment -- 10.2.2 Scalability of single and multi-user SAP BW queries -- 10.2.3 Scalability of dataload from PSA into InfoCube -- 10.2.4 Summary of scalability test results -- 10.3 SAP Business Warehouse on DB2 UDB Sun Cluster -- 10.3.1 Hardware and software setup -- 10.3.2 Description of tests -- 10.3.3 Results of scalability tests -- 10.4 Performance of partitioned and unpartitioned database -- Appendix A. SQL analysis with SAP BW -- Glossary -- Abbreviations and acronyms -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Help from IBM -- Index.

Back cover.