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.
asked 2 months ago14 views
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:
- 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 months ago
Thanks This is specifically for DB2 zOS not LUW
Relevant questions
Using DMS and SCT for extracting/migrating data from Cassandra to S3
asked 16 days agoRDS to S3 to RDS or Redshift near realtime
Accepted Answerasked a year agoMigrate tables with LOBs from RDS MySQL to OpenSearch using DMS
asked 10 days agoCan DMS be used to extract data from an RDS Oracle Read Replica?
Accepted Answerasked 2 years agoExport data from AWS ElasticSearch to AWS RDS instance using Logstash
asked 5 months agomigration tool for DB2 zOS to AWS RDS
asked 2 months agoBest approach to migrate 3 tier angular java and db2 to AWS server less architecture
asked a month agoData Base Migration from On Prem My SQL Server to AWS RDS using DMS
asked a month agotable not replicating in DMS from MySQL RDS to Redshift RDS
asked 3 years agoDoes AWS DMS support ARRAY data type for RDS for PostgreSQL on EC2 to Aurora PostgreSQL migration?
Accepted Answerasked 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?