- Newest
- Most votes
- Most comments
Was able to replace the database files and folder using the instructions.
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:
-
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.
-
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.
-
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.
-
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
Hello,
Check if you have included SQL file in your online scope
Relevant content
- Accepted Answerasked a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 9 months ago
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.