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 réponse
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
répondu il y a 2 mois
profile picture
EXPERT
vérifié il y a un mois

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions