- Newest
- Most votes
- Most comments
Based on the error you're encountering, there are a few important points to address:
Connection Requirement:
Before calling rdsadmin.backup_database, you must be connected to the rdsadmin database. The procedure is only available when you're connected to this specific database. After completing your backup operation, you should terminate the connection.
Correct Procedure Syntax:
The rdsadmin.backup_database stored procedure has specific required and optional parameters. The required parameters are:
out_task_id(output parameter for the task ID)database_name(the name of the database to back up)s3_bucket_name(the Amazon S3 bucket name)s3_prefix(the Amazon S3 prefix)
Optional parameters include:
backup_type(ONLINE or OFFLINE, default is ONLINE)compression_option(YES or NO, default is YES)util_impact_priority(1-100, default is 50)num_files(number of backup files, default is 1)parallelism(degree of parallelism, default is 1)num_buffers(number of buffers, default is 2)
Prerequisites: To use the backup functionality, you need to:
- Ensure your DB instance has backups enabled with a retention period of at least 1 day
- Have the appropriate Amazon S3 integration configured for your RDS for Db2 instance
- Verify that you have the necessary IAM roles and permissions set up for S3 access
Checking Task Status:
After initiating a backup, you can check its status using the rdsadmin.get_task_status stored procedure with the task ID returned from the backup operation.
If you continue to experience issues after verifying these requirements, you may want to check for any stored procedure errors specific to your configuration or contact AWS Support for further assistance with your specific instance setup.
Sources
Troubleshooting for Amazon RDS for Db2 - Amazon Relational Database Service
Stored procedures for databases for RDS for Db2 - Amazon Relational Database Service
