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
질문됨 2년 전995회 조회
2개 답변
1
AWS
답변함 2년 전
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

답변함 2년 전
  • Thanks This is specifically for DB2 zOS not LUW

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠