Skip to main content

Db2 Optimization Techniques for SAP Database Migration to the Cloud

A draft IBM Redbooks publication


Last updated on 20 June 2023

  1. .PDF (7.5 MB)

Share this page:   

IBM Form #: SG24-8531-00

Authors: Dino Quintero, Frank Becker, Holger Hellmuth, Joern Klauke, Thomas Rech, Alexander Seelert, Hans-Jürgen Zeltwanger and Tim Simon

    menu icon


    For many years, SAP migrations have been a standard process. We see an increasing number of customers changing their database software to IBM Db2 for UNIX, Linux and Windows or moving their existing Db2 based infrastructure from on-premises into the cloud.

    When moving to the cloud, often a heterogeneous system copy is needed due to a change of the underlying hardware architecture and operating system.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, in addition to background information about Unicode.

    We summarize our recommendations in one chapter that can be used as a quick reference for experienced migration consultants. It describes optimization strategies and best practices for migrating SAP systems to IBM Db2 for Linux, UNIX and Windows. It is intended for experienced SAP migration experts and discusses IBM Db2® specific recommendations and best practices.

    It addresses advanced SAP migration techniques, considerations for database layout and tuning, and presents unique Db2 capabilities.All techniques discussed within this book are based on extensive tests and experiences collected from countless migration projects.

    However, it is important to understand that some advanced optimizations described in this document may have side effects or may introduce risks to the overall process due to their complexity.

    Other optimizations may require changes to the production system. Therefore, these features must be chosen wisely. They should be used only if the migration downtime window makes it necessary.We want this book to be as helpful as possible.

    If you like to provide feedback on our recommendations, have suggestions or questions, you are welcome to contact the authors.

    Table of Contents

    Chapter 1. Introduction

    Chapter 2. Db2 with SAP in the Cloud

    Chapter 3. Migration essentials

    Chapter 4. Tools overview

    Chapter 5. Export optimization techniques

    Chapter 6. Basic Db2 layout and configuration options

    Chapter 7. Import/Export overlap

    Chapter 8. Data transfer options

    Chapter 9. Special cases

    Chapter 10. Tips for monitoring

    Chapter 11. Homogeneous system copy methods


    Special Notices

    The material included in this document is in DRAFT form and is provided 'as is' without warranty of any kind. IBM is not responsible for the accuracy or completeness of the material, and may update the document at any time. The final, published document may not include any, or all, of the material included herein. Client assumes all risks associated with Client's use of this document.