Skip to main content

DB2 Optimization Techniques for SAP Database Migration And Unicode Conversion

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.


Published on 17 August 2009

  1. .PDF (4.2 MB)

Share this page:   

ISBN-10: 073843308X
ISBN-13: 9780738433080
IBM Form #: SG24-7774-00

Authors: Christian Andreas, Waldemar Gaida, Hans-Jurgen Moldowan and Thomas Rech

    menu icon


    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