SAP solutions on IBM DB2 UDB V8.2.2 handbook

SAP solutions on IBM DB2 UDB V8.2.2 handbook

IBM and SAP share a vision for responding to customers' specific requirements for tighter integration, platform flexibility, lower total cost of ownership, and improved performance. DB2 UDB V8.2.2 is an SAP-optimized version that uses autonomic computing technologies specifically tuned to help...

Descripción completa

Detalles Bibliográficos
Autor Corporativo: International Business Machines Corporation. International Technical Support Organization (-)
Formato: Libro electrónico
Idioma:Inglés
Publicado: San Jose, CA : IBM, International Technical Support Organization 2005.
Edición:1st ed
Colección:IBM redbooks.
Materias:
Database management.
Management information systems.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009626954906719
Tabla de Contenidos:
  • Front cover
  • Contents
  • Notices
  • Trademarks
  • Preface
  • The team that wrote this redbook
  • Acknowledgements
  • Become a published author
  • Comments welcome
  • Chapter 1. DB2 UDB and SAP
  • 1.1 Executive summary
  • 1.2 DB2 UDB V8.2.2 features for SAP systems at a glance
  • 1.2.1 New features in DB2 UDB V8.2
  • 1.2.2 New features in DB2 UDB V8.2.2
  • 1.3 SAP release matrix with DB2 UDB platforms
  • Chapter 2. DB2 UDB architecture from SAP's point of view
  • 2.1 DB2 UDB server process model
  • 2.1.1 Fault monitor facility
  • 2.1.2 A practical view of the process model
  • 2.2 DB2 UDB server memory architecture
  • 2.2.1 Database manager shared memory and FCM shared memory
  • 2.2.2 Database shared memory
  • 2.2.3 Application group shared memory
  • 2.2.4 Agent private memory
  • 2.2.5 DB2 memory architecture summary
  • 2.3 Storage concept basics
  • 2.3.1 Table space types
  • 2.3.2 DB2 UDB V8.2.2 storage management advancements
  • 2.3.3 Directory structure for DB2 UDB in SAP environments
  • 2.4 DB2 UDB partitioning concepts
  • 2.4.1 Benefits of using the database partitioning feature
  • 2.4.2 Using database partitioning feature in SAP systems
  • 2.5 Database client and SAP database layer
  • 2.5.1 Interaction between the database interface layer and DB2 UDB
  • 2.6 Terminology mapping with DB2 UDB
  • 2.6.1 DB2 UDB terms
  • 2.6.2 Terminology mapping for Oracle databases
  • 2.6.3 Terminology mapping for IBM Informix Dynamic Server databases
  • 2.6.4 Terminology mapping for MySQL MaxDB databases
  • Chapter 3. Installing SAP NetWeaver 2004s with DB2 UDB V8.2.2
  • 3.1 Test environment
  • 3.1.1 Software configuration
  • 3.1.2 Hardware configuration
  • 3.2 SAP installation guides
  • 3.3 System preparation
  • 3.3.1 The Prerequisites Checker Tool
  • 3.3.2 Checking conditions
  • 3.3.3 Running modes.
  • 3.4 Considerations: Installing SAP NetWeaver 2004s with DB2 UDB V8.2.2
  • 3.4.1 Features that are automatically switched on
  • 3.4.2 Storage management and table spaces: considerations
  • 3.4.3 Database Partitioning Feature (DPF) considerations
  • 3.5 Post installation activities: a DB2 UDB view
  • 3.6 Considerations: Installing older SAP systems with DB2 UDB V8.2.2
  • Chapter 4. Storage management in depth
  • 4.1 DB2 UDB logical and physical database objects
  • 4.1.1 Tables, indexes, and views
  • 4.1.2 Table spaces
  • 4.1.3 Table space containers
  • 4.2 Working with SMS and DMS table spaces
  • 4.2.1 SMS table spaces
  • 4.2.2 File based DMS table spaces
  • 4.2.3 Device based DMS table spaces
  • 4.3 SAP data classes (TABARTs)
  • 4.4 Space reclamation strategies
  • 4.4.1 Offline table and index reorganization
  • 4.4.2 Inplace table and index reorganization
  • 4.4.3 Criteria for reorganization
  • 4.4.4 High water mark
  • 4.5 Best practices for intelligent storage subsystems
  • 4.5.1 Database stored on single SSA/SCSI disks
  • 4.5.2 Database stored on RAID-5 arrays
  • 4.6 Moving tables and indexes using DB6CONV
  • 4.6.1 Principle of moving tables and indexes using DB6CONV
  • 4.6.2 Example: Moving table PCL2 to improve performance
  • Chapter 5. DB2 UDB configuration from SAP's perspective
  • 5.1 DB2 UDB's approach to database parameters
  • 5.2 DB2 UDB database manager configuration
  • 5.2.1 SAP recommended database manager configuration settings
  • 5.3 DB2 UDB database configuration
  • 5.3.1 SAP recommended database configuration
  • 5.4 DB2 profile registry
  • 5.4.1 DB2 registry variables and recommended settings
  • Chapter 6. SAP database administration
  • 6.1 Architectural overview
  • 6.2 Local and remote monitoring
  • 6.2.1 Concept of remote monitoring
  • 6.2.2 Configuration for remote system monitoring
  • 6.3 Screen management
  • 6.3.1 Common fields.
  • 6.3.2 Buttons in the navigation frame
  • 6.3.3 Monitoring settings
  • 6.3.4 Authorization and permission
  • 6.3.5 Lock on DBA Cockpit
  • 6.4 Monitoring
  • 6.4.1 Database monitoring
  • 6.4.2 Schema monitoring
  • 6.4.3 Buffer pool monitoring
  • 6.4.4 Table space monitoring
  • 6.4.5 Table monitoring
  • 6.4.6 Application monitoring
  • 6.4.7 SQL cache analysis
  • 6.4.8 Lock waits and deadlock analysis
  • 6.4.9 Inplace table reorganization monitoring
  • 6.5 Space management
  • 6.5.1 Table spaces
  • 6.5.2 Containers
  • 6.5.3 Tables and indexes
  • 6.5.4 Single table analysis
  • 6.5.5 History
  • 6.6 Backup management
  • 6.6.1 Backup Overview
  • 6.7 Log file management
  • 6.8 Configuration
  • 6.8.1 Database Manager
  • 6.8.2 Database
  • 6.8.3 Parameter Changes
  • 6.8.4 Database partitioning group
  • 6.8.5 Buffer Pools
  • 6.8.6 Special RUNSTATS settings and volatile tables
  • 6.8.7 CLP Command Execution
  • 6.8.8 File Systems
  • 6.8.9 Data Classes
  • 6.8.10 Monitoring Tool Settings
  • 6.9 Scheduling DBA tasks
  • 6.9.1 DBA Planning Calendar
  • 6.9.2 DBA Log
  • 6.9.3 CLP Script Maintenance
  • 6.10 Using the alert monitor
  • 6.10.1 Alert Configuration
  • 6.10.2 Alert Message Log
  • 6.11 Diagnostics
  • 6.11.1 Missing Tables and Indexes
  • 6.11.2 Help
  • 6.11.3 Control Panel
  • 6.11.4 Single System Check
  • 6.11.5 Explain
  • 6.11.6 Cumulative SQL Trace
  • 6.11.7 DBSL Trace Directory
  • 6.11.8 Trace Status
  • 6.11.9 Database Notification Log
  • 6.11.10 Database Diag Log
  • 6.11.11 Dump directory
  • 6.12 Partition Integration wizard
  • Chapter 7. Protecting your SAP data
  • 7.1 Log file management
  • 7.1.1 Basic logging concepts
  • 7.1.2 SAP log management
  • 7.1.3 DB2 UDB V8.2 log management
  • 7.1.4 Comparison of legacy and DB2 V8.2 log file management
  • 7.1.5 Migration from legacy to DB2 log file management
  • 7.2 DB2 UDB backup and recovery.
  • 7.2.1 Setting up the backup media
  • 7.2.2 Performing backups
  • 7.2.3 Recovering the database
  • 7.2.4 Redirected restore of the database
  • 7.2.5 Database relocation
  • 7.2.6 Throttling the backup utility
  • 7.3 Advanced Backup technology for a large database
  • 7.3.1 DB2 UDB functions for a large database backup/restore
  • 7.3.2 Back up and restore a large database
  • 7.3.3 Creating a hot standby database
  • 7.3.4 Taking a normal DB2 UDB backup
  • 7.3.5 Creating a database clone
  • 7.3.6 Special considerations for IBM ESS Flash Copy on AIX platform
  • 7.3.7 Offline backup image and recovery
  • 7.4 Monitoring backup, restore and recovery progress
  • 7.5 High availability
  • 7.5.1 High Availability Disaster Recovery (HADR)
  • 7.5.2 Log file shipping
  • 7.5.3 Clustered solutions
  • Chapter 8. Database problem diagnostics
  • 8.1 Introduction to PD/PSI
  • 8.1.1 What is PD/PSI?
  • 8.1.2 Problem types
  • 8.2 Tools and diagnostic data collection
  • 8.2.1 DB2 data collection and diagnostic tools
  • 8.2.2 SAP tools for diagnostic purposes
  • 8.3 Support Integration of SAP and DB2
  • 8.4 Problem research resources
  • Chapter 9. Using features of DB2 UDB V8.2 and V8.2.2 with older SAP systems
  • 9.1 Upgrading DB2 UDB to V8.2.2
  • Chapter 10. Using SAP NetWeaver 2004s Business Intelligence with DB2 UDB
  • 10.1 SAP BI technical overview
  • 10.1.1 SAP BI information model
  • 10.2 Clustering support in DB2 UDB V8.2.2
  • 10.2.1 Index clustering
  • 10.2.2 Multi-dimensional clustering (MDC)
  • 10.3 Clustering support in SAP NetWeaver 2004s BI
  • 10.3.1 Persistent Staging Area (PSA)
  • 10.3.2 DataStore objects
  • 10.3.3 InfoCube fact tables
  • 10.3.4 Aggregates
  • 10.3.5 Defining clustering for InfoCubes
  • 10.3.6 Defining MDC for DataStore objects
  • 10.4 Re-clustering InfoCubes and DataStore objects
  • 10.4.1 Re-clustering for InfoCubes.
  • 10.4.2 Re-clustering for DataStore objects
  • 10.4.3 Monitoring re-clustering requests
  • 10.4.4 Data copy
  • 10.5 InfoCube compression
  • 10.6 Data deletion with new SQL DELETE statement
  • 10.7 Use of sampled statistics
  • 10.8 Migration of SAP BI systems to DB2 UDB
  • 10.8.1 Migration procedure
  • 10.8.2 Generation of the DDL for the target database platform
  • 10.8.3 Exporting the source database
  • 10.8.4 Creating and importing the target database
  • 10.8.5 SAP BI migration post processing
  • Related publications
  • IBM Redbooks
  • Other publications
  • Online resources
  • How to get IBM Redbooks
  • Help from IBM
  • Index
  • Back cover.

Ejemplares similares