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
feita há 2 anos995 visualizações
2 Respostas
1
AWS
respondido há 2 anos
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

respondido há 2 anos
  • Thanks This is specifically for DB2 zOS not LUW

Você não está conectado. Fazer login para postar uma resposta.

Uma boa resposta responde claramente à pergunta, dá feedback construtivo e incentiva o crescimento profissional de quem perguntou.

Diretrizes para responder a perguntas