DB2 Optimization Techniques for SAP Database Migration And Unicode Conversion
An IBM Redbooks publication
Published 17 August 2009
IBM Form #: SG24-7774-00
Authors: Christian Andreas, Waldemar Gaida, Hans-Jurgen Moldowan, Thomas Rech
SAP® migrations are a standard process nowadays. This IBM® Redbooks® publication describes optimization strategies and best practices for migrating SAP systems toward IBM DB2 for Linux, UNIX, and Windows, as well as for performing Unicode conversions. We discuss DB2-specific recommendations and best practices.
This book is intended for experienced SAP migration consultants involved in operating system and database migrations or Unicode conversions, choosing IBM DB2 as a target database platform. It addresses the advanced SAP migration techniques, considerations for database layout and tuning, and unique DB2 capabilities such as compressing the target database while loading data.
This book provides in-depth information about the best practices and recommendations for the source system database export, the advanced migration techniques, database layout and configuration, database import recommendations, SAP NetWeaver Business Warehouse, as well as background information about Unicode. We summarize our recommendations in one chapter that can be used as a quick reference for experienced migration consultants.
Table of contents
Chapter 1. Introduction
Chapter 2. Migration essentials
Chapter 3. Tools overview
Chapter 4. Export optimization techniques
Chapter 5. Advanced optimization techniques
Chapter 6. Basic DB2 layout and configuration options
Chapter 7. Import optimization
Chapter 8. Tips for monitoring the system copy process
Chapter 9. Considerations for migrating SAP NetWeaver BW-based systems
Chapter 10. Unicode details
Chapter 11. Setup for a Unicode migration
Appendix A. Background information
Others who read this publication also read
Follow IBM Redbooks
Follow IBM Redbooks