Migrate DB2 (11.5) on AIX (IBMX 7.2) to Aurora Postgres

Question

Hello,
I am working on migrating DB2 (11.5) on AIX (IBMX 7.2) to Aurora Postgres. So far have not found any workable solution.
One solution is a 2 step solution
1. Move from DB2 AIX to RDS DB2 
2. Use DMS to migrate from RDS DB2 to Aurora Postgres
Challenge:
1. Long down time because of large database data transfer to S3 and then restore.
2. Validating the DB and data twice

So far AWS documentation does not talk about DMS and SCT support for DB2 on AIX. Any suggestions or pointers to a workable solution would be appreciated.

Thanks

Answer

Hi,

Yes, probably a 2-step migration with DB2 LUW on RDS as intermediate step is a safe option.

This brand new blog post is interesting: https://aws.amazon.com/blogs/database/migrate-from-self-managed-db2-to-amazon-rds-for-db2-using-aws-dms/

You may also want to look at https://www.dbisoftware.com/db2nightshow/20220408DB2Night244.pdf to see all options for DB2 AIX -> DB2 LUW

This guidance from IBM may also be useful: https://www.ibm.com/support/pages/cross-platform-data-migrations

This guide will help for step #2: https://wiki.postgresql.org/images/d/d1/DB2UDB-to-PG.pdf

Best,

Didier

Migrate DB2 (11.5) on AIX (IBMX 7.2) to Aurora Postgres

Conteúdo relevante