Import IBM db2 backup image to AWS RDS IBM Db2

Question

I want to restore an IBM DB2 backup image (**SAMPLE.0.db2inst1.DBPART000.20230723133415.001 **) to an AWS RDS IBM DB2 instance. Upon researching, I found that we can use the stored procedure `**rdsadmin.restore_database**` to accomplish this. However, I'm curious whether there's an alternative method to restore the backup image to AWS RDS IBM DB2 without using this stored procedure.

Sitaram, Vijay · Answer

Because there is no host access to Db2 database, the restore and rollforward function has to be performed using rdsadmin stored procedure. Below are the steps to perform a restore from native IBM Db2 backup image (offline backup) to Amazon RDS for Db2:

**Full offline backup and restore with S3 Integration**
1. * Copy native Db2 database backup image to S3 using aws s3 cp command 
2. * Enable S3 Integration – Attach IAM role to RDS Db2 instance
3. * Restore database [rdsadmin.restore_database] stored procedure

---
You can also use full online database backup with transaction logs to restore to RDS for Db2:

**Full online backup and restore with S3 Integration**
1. Copy native Db2 database backup image and transaction logs to S3 
2. Enable S3 Integration – Attach IAM role to RDS Db2 instance to access 
3. Start restore [rdsadmin.restore_database]. Set backup_type to ONLINE
4. Start rollforward [rdsadmin.rollforward_database]. Set complete_rollforward to FALSE
5. Complete rollforward [rdsadmin.complete_rollforward]

Import IBM db2 backup image to AWS RDS IBM Db2

Add your answer

Relevant content