Read IBM DB2 tables from Sagemaker

0

Can anyone temme how can we read db2 tables from sagemaker , please provide steps to read db2 tables . Or please confirm below

  1. Should we move database to Amazon RDS
  2. Should we use SCT and DMS to move data and schema . Kindly please confirm , would be of great help
1 個回答
0

Hi, For on-premises or self-managed Db2 databases, you can use AWS Glue to first extract, transform and load (ETL) the data into an S3 bucket and then consume it from SageMaker.

I will recommend to migrate to Amazon RDS DB2. You have a few option to migrate your tables from on-prem to Amazon RDS DB2: 1.- You can use native Db2 tools like db2look to extract the database schema and metadata. This will create DDL scripts that can then be run on the RDS DB2 database to recreate the schema. For data migration, you can use the Db2 EXPORT utility to export the table data into files. These files can then be imported into the RDS DB2 database using the IMPORT command. Here are the tools references: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/db2-native-db2-tools.html https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/db2-one-time-migration-aix-windows-linux.html

2.- The AWS Schema Conversion Tool (SCT) and AWS Database Migration Service (DMS) also support migrations from Db2 databases. SCT allows you to migrate the schema and DMS can perform full database migrations including the data. https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/db2-migration-amazon-dms.html https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/db2-migration-approaches.html

profile pictureAWS
Arifc
已回答 2 個月前
profile picture
專家
已審閱 1 個月前

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

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

回答問題指南