By using AWS re:Post, you agree to the Terms of Use
/migration tool for DB2 zOS to AWS RDS/

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?

1 Answers
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

answered 2 months ago
  • Thanks This is specifically for DB2 zOS not LUW

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions