2 Answers
- Newest
- Most votes
- Most comments
1
DB2 for z/OS is now a source for DMS: https://docs.aws.amazon.com/SchemaConversionTool/latest/userguide/CHAP_Source.DB2zOS.html
answered 2 years ago
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:
- Use SCT to convert the SCHEMA from DB2 into the target database schema (such as RedShift or Amazon Aurora).
- 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 years ago
Thanks This is specifically for DB2 zOS not LUW
Relevant content
- asked 3 months ago
- asked 2 years ago
- asked a day ago
AWS OFFICIALUpdated 2 years ago- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago
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?