You are previewing SAP Solutions on IBM DB2 UDB V8.2.2 Handbook.
O'Reilly logo
SAP Solutions on IBM DB2 UDB V8.2.2 Handbook

Book Description

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 SAP users streamline installation, improve performance, and increase availability.

This IBM Redbooks publication provides information for SAP consultants and SAP system administrators. It includes the latest DB2 UDB architecture details, SAP-related features and functions, practical advice on SAP NetWeaver 2004 installations, and DB2 configuration in SAP environments.

We describe DB2 UDB’s logical and physical database objects, storage management, SAPs data classes, and space reclamation strategies, and provide the best practices for intelligent storage subsystems.

We also discuss how to use DBA Cockpit to monitor your system, DB2 UDB log file management, database backup and recovery, and high availability and clustered solutions. We introduce the Problem Description / Problem Source Identification (PD/PSI) methodology, and the troubleshooting approaches for common problems. Finally, we include a discussion of the new features of SAP NetWeaver 2004s Business Intelligence (SAP BI) with DB2 UDB V8.2.2.

Table of Contents

  1. Notices
    1. Trademarks
  2. Preface
    1. The team that wrote this redbook
    2. Acknowledgements
    3. Become a published author
    4. Comments welcome
  3. Chapter 1: DB2 UDB and SAP
    1. Executive summary
    2. DB2 UDB V8.2.2 features for SAP systems at a glance
      1. New features in DB2 UDB V8.2
      2. New features in DB2 UDB V8.2.2
    3. SAP release matrix with DB2 UDB platforms
  4. Chapter 2: DB2 UDB architecture from SAP’s point of view
    1. DB2 UDB server process model
      1. Fault monitor facility
      2. A practical view of the process model
    2. DB2 UDB server memory architecture
      1. Database manager shared memory and FCM shared memory
      2. Database shared memory
      3. Application group shared memory
      4. Agent private memory
      5. DB2 memory architecture summary
    3. Storage concept basics
      1. Table space types
      2. DB2 UDB V8.2.2 storage management advancements
      3. Directory structure for DB2 UDB in SAP environments
    4. DB2 UDB partitioning concepts
      1. Benefits of using the database partitioning feature
      2. Using database partitioning feature in SAP systems
    5. Database client and SAP database layer
      1. Interaction between the database interface layer and DB2 UDB
    6. Terminology mapping with DB2 UDB
      1. DB2 UDB terms
      2. Terminology mapping for Oracle databases
      3. Terminology mapping for IBM Informix Dynamic Server databases
      4. Terminology mapping for MySQL MaxDB databases
  5. Chapter 3: Installing SAP NetWeaver 2004s with DB2 UDB V8.2.2
    1. Test environment
      1. Software configuration
      2. Hardware configuration
    2. SAP installation guides
    3. System preparation
      1. The Prerequisites Checker Tool
      2. Checking conditions
      3. Running modes
    4. Considerations: Installing SAP NetWeaver 2004s with DB2 UDB V8.2.2
      1. Features that are automatically switched on
      2. Storage management and table spaces: considerations
      3. Database Partitioning Feature (DPF) considerations
    5. Post installation activities: a DB2 UDB view
    6. Considerations: Installing older SAP systems with DB2 UDB V8.2.2
  6. Chapter 4: Storage management in depth
    1. DB2 UDB logical and physical database objects
      1. Tables, indexes, and views
      2. Table spaces
      3. Table space containers
    2. Working with SMS and DMS table spaces
      1. SMS table spaces
      2. File based DMS table spaces
      3. Device based DMS table spaces
    3. SAP data classes (TABARTs)
    4. Space reclamation strategies
      1. Offline table and index reorganization
      2. Inplace table and index reorganization
      3. Criteria for reorganization
      4. High water mark
    5. Best practices for intelligent storage subsystems
      1. Database stored on single SSA/SCSI disks
      2. Database stored on RAID-5 arrays
    6. Moving tables and indexes using DB6CONV
      1. Principle of moving tables and indexes using DB6CONV
      2. Example: Moving table PCL2 to improve performance
  7. Chapter 5: DB2 UDB configuration from SAP’s perspective
    1. DB2 UDB's approach to database parameters
    2. DB2 UDB database manager configuration
      1. SAP recommended database manager configuration settings
    3. DB2 UDB database configuration
      1. SAP recommended database configuration
    4. DB2 profile registry
      1. DB2 registry variables and recommended settings
  8. Chapter 6: SAP database administration
    1. Architectural overview
    2. Local and remote monitoring
      1. Concept of remote monitoring
      2. Configuration for remote system monitoring
    3. Screen management
      1. Common fields
      2. Buttons in the navigation frame
      3. Monitoring settings
      4. Authorization and permission
      5. Lock on DBA Cockpit
    4. Monitoring
      1. Database monitoring
      2. Schema monitoring
      3. Buffer pool monitoring
      4. Table space monitoring
      5. Table monitoring
      6. Application monitoring
      7. SQL cache analysis
      8. Lock waits and deadlock analysis
      9. Inplace table reorganization monitoring
    5. Space management
      1. Table spaces
      2. Containers
      3. Tables and indexes
      4. Single table analysis
      5. History
    6. Backup management
      1. Backup Overview
    7. Log file management
    8. Configuration
      1. Database Manager
      2. Database
      3. Parameter Changes
      4. Database partitioning group
      5. Buffer Pools
      6. Special RUNSTATS settings and volatile tables
      7. CLP Command Execution
      8. File Systems
      9. Data Classes
      10. Monitoring Tool Settings
    9. Scheduling DBA tasks
      1. DBA Planning Calendar
      2. DBA Log
      3. CLP Script Maintenance
    10. Using the alert monitor
      1. Alert Configuration
      2. Alert Message Log
    11. Diagnostics
      1. Missing Tables and Indexes
      2. Help
      3. Control Panel
      4. Single System Check
      5. Explain
      6. Cumulative SQL Trace
      7. DBSL Trace Directory
      8. Trace Status
      9. Database Notification Log
      10. Database Diag Log
      11. Dump directory
    12. Partition Integration wizard
  9. Chapter 7: Protecting your SAP data
    1. Log file management
      1. Basic logging concepts
      2. SAP log management
      3. DB2 UDB V8.2 log management
      4. Comparison of legacy and DB2 V8.2 log file management
      5. Migration from legacy to DB2 log file management
    2. DB2 UDB backup and recovery
      1. Setting up the backup media
      2. Performing backups
      3. Recovering the database
      4. Redirected restore of the database
      5. Database relocation
      6. Throttling the backup utility
    3. Advanced Backup technology for a large database
      1. DB2 UDB functions for a large database backup/restore
      2. Back up and restore a large database
      3. Creating a hot standby database
      4. Taking a normal DB2 UDB backup
      5. Creating a database clone
      6. Special considerations for IBM ESS Flash Copy on AIX platform
      7. Offline backup image and recovery
    4. Monitoring backup, restore and recovery progress
    5. High availability
      1. High Availability Disaster Recovery (HADR)
      2. Log file shipping
      3. Clustered solutions
  10. Chapter 8: Database problem diagnostics
    1. Introduction to PD/PSI
      1. What is PD/PSI?
      2. Problem types
    2. Tools and diagnostic data collection
      1. DB2 data collection and diagnostic tools
      2. SAP tools for diagnostic purposes
    3. Support Integration of SAP and DB2
    4. Problem research resources
  11. Chapter 9: Using features of DB2 UDB V8.2 and V8.2.2 with older SAP systems
    1. Upgrading DB2 UDB to V8.2.2
  12. Chapter 10: Using SAP NetWeaver 2004s Business Intelligence with DB2 UDB
    1. SAP BI technical overview
      1. SAP BI information model
    2. Clustering support in DB2 UDB V8.2.2
      1. Index clustering
      2. Multi-dimensional clustering (MDC)
    3. Clustering support in SAP NetWeaver 2004s BI
      1. Persistent Staging Area (PSA)
      2. DataStore objects
      3. InfoCube fact tables
      4. Aggregates
      5. Defining clustering for InfoCubes
      6. Defining MDC for DataStore objects
    4. Re-clustering InfoCubes and DataStore objects
      1. Re-clustering for InfoCubes
      2. Re-clustering for DataStore objects
      3. Monitoring re-clustering requests
      4. Data copy
    5. InfoCube compression
    6. Data deletion with new SQL DELETE statement
    7. Use of sampled statistics
    8. Migration of SAP BI systems to DB2 UDB
      1. Migration procedure
      2. Generation of the DDL for the target database platform
      3. Exporting the source database
      4. Creating and importing the target database
      5. SAP BI migration post processing
  13. Related publications
    1. IBM Redbooks
    2. Other publications
    3. Online resources
    4. How to get IBM Redbooks
    5. Help from IBM
  14. Index
  15. Back cover