By using AWS re:Post, you agree to the AWS re:Post Terms of Use

My carddemo-db2-migration doesn't have a database folder and I can't migrate data to RDS

0

I am trying to perform the Go Live demo, however, I cannot Migrate data to the Primary Database.

  • It seems like you're trying to migrate data to an RDS instance but facing an issue with the carddemo-db2-migration not having a database folder. Could you clarify a few things?

    Are you using a specific migration tool (like AWS Database Migration Service or custom scripts)? Is the source database already set up, or are you trying to initialize it? Can you provide more details about the error or issue you're seeing during migration?

  • This is for the AWS Blu Age L3 Go Live workshop. The D:\PhotonUser\Workshop\outputs\transform\outputs location doesn't have a database folder to copy to my carddemo-db2-migration project. See this step -> https://catalog.us-east-1.prod.workshops.aws/workshops/bf71c0bc-6d8a-4d04-9c10-ab479f7f0e37/en-US/data-migration/db2

  • Nevermind, I was able to figure this part out.

asked 18 days ago30 views
3 Answers
0
Accepted Answer

Was able to replace the database files and folder using the instructions.

answered 15 days ago
0

I apologize for the confusion, but I need to clarify that the issue you're describing doesn't seem to be directly related to the standard migration processes for Amazon RDS for Db2. Without more context about your specific setup and the "Go Live demo" you're referring to, it's challenging to provide a precise answer.

However, I can offer some general guidance on migrating data to Amazon RDS for Db2:

  1. Ensure that you have a source Db2 database to migrate from. If you're missing a database folder, this could indicate an issue with your source database setup.

  2. For migrating to Amazon RDS for Db2, you typically have two main options:

    a. Using AWS services: You can use AWS Database Migration Service (AWS DMS) for one-time migrations or ongoing synchronization from Db2 on Linux, Unix, and Windows to Amazon RDS for Db2.

    b. Using native Db2 tools: You can use tools like db2look for metadata, IMPORT command for small tables or tables with LOBs, INGEST utility for streaming data without LOBs, or LOAD CLIENT command for small tables without LOBs.

  3. If you're migrating from AIX or Windows to Linux for Amazon RDS for Db2, the process typically involves backing up your database, extracting DDL files, unloading table data, moving the backup to an Amazon S3 bucket, and then loading the data into RDS for Db2.

  4. Make sure you have proper connectivity between your source database and the RDS for Db2 instance.

If you're still encountering issues, you may need to review your source database setup, ensure you have the necessary permissions, and verify that you're following the correct migration procedure for your specific use case. If the problem persists, you might want to consult AWS support or review the specific documentation for the "Go Live demo" you're attempting to perform.
Sources
Migrating to Amazon RDS for Db2 with AWS Database Migration Service (AWS DMS) - Amazon Relational Database Service
Migrating data to Amazon RDS for Db2 - Amazon Relational Database Service
Using native Db2 tools to migrate data from Db2 to Amazon RDS for Db2 - Amazon Relational Database Service
Migrating from AIX or Windows to Linux for Amazon RDS for Db2 - Amazon Relational Database Service

profile picture
answered 18 days ago
0
AWS
answered 17 days ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions