Building and scaling SAP business information warehouse on DB2 UDB ESE

Building and scaling SAP business information warehouse on DB2 UDB ESE

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...

Descripción completa

Detalles Bibliográficos
Autor Corporativo: International Business Machines Corporation. International Technical Support Organization (-)
Otros Autores: Ballard, Chuck (-)
Formato: Libro electrónico
Idioma:Inglés
Publicado: San Jose, CA : IBM, International Technical Support Organization 2004.
Edición:1st ed
Colección:IBM redbooks.
DB2 information management software.
Materias:
SAP Business information warehouse.
IBM Database 2.
Data warehousing.
Management information systems.
Business enterprises > Computer networks.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009755205606719
Tabla de Contenidos:
  • 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.

Ejemplares similares