Building and scaling SAP business information warehouse on DB2 UDB ESE / / [Chuck Ballard ... et al.]

• Record Nr.: UNINA9910806141903321
• Pubbl/distr/stampa: San Jose, CA, : IBM, International Technical Support Organization, 2004
• Edizione: [1st ed.]
• Descrizione fisica: xvi, 380 p. : ill
• Collana: IBM redbooks; DB2 information management software
• Altri autori (Persone): BallardChuck
• Disciplina: 005.74/5
• Soggetti: Data warehousing; Management information systems; Business enterprises - Computer networks
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Note generali: "SG24-7094-00."
• Nota di bibliografia: Includes bibliographical references and index.
• Nota di contenuto: 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.
• Sommario/riassunto: SAP is a leading ERP vendor, with a large install base. A key element in their product set is the SAP Business Information Warehouse (BW). The primary objective of this IBM Redbooks publication is to provide guidelines to help you implement your SAP Business Information Warehouse on DB2 UDB ESE. Two major considerations when building a business information warehouse are scalability and performance. In this book, we have demonstrated the wide range of scalability of BW when implemented on DB2, while maintaining the performance requirements that are so critical. The parallelism and data partitioning capabilities of DB2 Universal Database ESE, enables a robust, highly scalable, and high performance business information warehouse. For a common understanding, we first discuss the concepts of data warehousing and then describe the SAP architecture and robust component capabilities of the SAP business information warehouse. To help in your implementation, we provide guidelines for how to configure SAP BW when it is built on DB2. We also describe and discuss the key capabilities and parameters to help you get the best from DB2. Key topics such as sizing, partitioning, performance tuning, and systems administration, are discussed to assist in the implementation and maintenance of your system. This book will help enable you to more quickly and easily implement a robust SAP BW on DB2 UDB ESE.