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
전문가
검토됨 한 달 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인

관련 콘텐츠