We need to migrate data from AS/400 (DB2/400) to AWS (MySQL)

0

We need to migrate 200G data from AS/400 (Database is DB2/400) to AWS (MySQL). Any lead please. How to do this one or anyone had done this in past.

  • We at Micro Focus do this all the time. We have tools to automate this data migration.

asked 2 years ago1583 views
4 Answers
0

AWS DMS does not support Db2 on AS/400 at the moment.

Look into Precisely instead which supports near real-time replication from midrange systems including AS/400: https://aws.amazon.com/about-aws/whats-new/2023/11/aws-mainframe-modernization-replication-precisely-ibm-i/

AWS
vg
answered 5 months ago
  • is precisely connect supports bidirectional synchronization (not only changes made in DB2 will be replicated to AWS RDS, but also changes made in AWS RDS will be replicated to DB2(AS/400)?

0

At this moment, AWS DMS does not support Db2/400 as a source. There are CDC tools like Qlik Replicate that can migrate data from Db2/400 to Amazon RDS for MySQL.

You can also use an ETL tool like AWS Glue to extract, transform and load data from Db2/400 to Amazon RDS for MySQL.

AWS
vg
answered 2 years ago
0

We are also looking for solution/options to replicate DB2 database running on IBMi (aka AS400) to AWS. Please share any ideas/options/solutions which we were already implemented for this use case.

Utham
answered 7 months ago
0

any news regarding the support Db2/400 as a source for DMS?

Andrea
answered 5 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions