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 réponse
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
répondu il y a un mois
  • Thanks Subhashr, this helps.

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions