migration tool for DB2 zOS to AWS RDS

0

Hello all, just wondering if anyone had any solutions for extracting data from DB2 zOS into AWS RDS or redshift using DMS. Struggling to find an effective solution.

  • DMS doesn't work with Db2 zOS as source. There are many third party CDC technologies that work with Db2 zOS - IBM Data replication, Oracle Goldengate to name a few. Is it important that you have CDC?

kblaauw
posta 2 anni fa995 visualizzazioni
2 Risposte
1
AWS
con risposta 2 anni fa
0

You can use AWS SCT to convert schemas, code objects, and application code from IBM Db2 LUW. AWS SCT supports as a source Db2 LUW versions 9.1, 9.5, 9.7, 10.1, 10.5, 11.1, and 11.5.

This would involve a 2-step process:

  1. Use SCT to convert the SCHEMA from DB2 into the target database schema (such as RedShift or Amazon Aurora).
  2. Use DMS (Database Migration Service) to read the source and write to the target. Note: You need to have JDBC connectivity to both the Source and Target databases.

More details are here: https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.DB2LUW.html

con risposta 2 anni fa
  • Thanks This is specifically for DB2 zOS not LUW

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande