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

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南