DB2 Optimization Techniques for SAP Database Migration And Unicode Conversion

An IBM Redbooks publication

Published 17 August 2009

cover image

ISBN-10: 073843308X
ISBN-13: 9780738433080
IBM Form #: SG24-7774-00
(298 pages)

More options

Rate and comment

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

Follow IBM Redbooks

Follow IBM Redbooks