Duration to Migrate zOS DB2 to RDS PostgreSQL

0

Any rough time taken to migrate zOS DB2 to RDS PostgreSQL? DB2 db size is 50GB, this is only for the actual data migration.
Assuming JDBC connectivity is setup, schema converted, all codes are converted.

1 Answer
1

For migrating a 50GB z/OS DB2 database to Amazon RDS for PostgreSQL using AWS Database Migration Service (AWS DMS), and assuming all necessary preparations are done, the approximate time taken would be:

Initial Load: 2-4 hours

Ongoing Replication: Minimal

Data Validation and Cutover: 1-2 hours

Total time: Approximately 4-8 hours, assuming no major issues or complexities.

It's important to note that this estimate assumes a relatively straightforward migration scenario with a moderately complex database schema and no significant data or schema transformations required during the migration process.

If you encounter any challenges or complexities, such as large numbers of tables or indexes, complex data transformations, or performance bottlenecks, the migration time could potentially increase.

Additionally, it's recommended to perform thorough testing and validation in a non-production environment before executing the actual migration to ensure a smooth and successful transition to the RDS PostgreSQL environment.

AWS
answered 8 months ago
  • Thanks Subhashr, this helps.

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