Migrating a Db2 for LUW database to Amazon EC2 - AWS Prescriptive Guidance

Migrating a Db2 for LUW database to Amazon EC2

Feng Cai, Shunan Xiang, and Venkatesan Govindan, Amazon Web Services (AWS)

February 2024 (document history)

Amazon Relational Database Service (Amazon RDS) now supports the IBM Db2 database engine.

Amazon RDS for Db2 automates time-consuming database administration tasks, such as provisioning, backups, software patching, and monitoring, to free up time to innovate and drive business value. However, Amazon RDS for Db2 doesn’t provide host access or SYSADM access, and it has other limitations. Customers who need host and SYSADM access can run Db2 for LUW (Linux, UNIX, and Windows) on Amazon Elastic Compute Cloud (Amazon EC2).

One of the biggest migration challenges that customers face is moving on-premises Db2 LUW workloads that are running on a big-endian platform such as IBM AIX to Amazon EC2, which is a little-endian platform. Currently, there is no easy way to convert Db2 data from big endian to little endian without unloading and reloading.

Considering these challenges, this guide covers the pros and cons of tested options for both big-endian and little-endian migration.