AWS AmazonRDS documentation change
Summary
Added documentation for backing up Db2 databases to Amazon S3 using rdsadmin.backup_database stored procedure
Security assessment
The change documents backup procedures and S3 integration without mentioning security vulnerabilities or security-specific features. While backups are a security best practice, this appears to be a general operational documentation update rather than addressing specific security issues or describing security controls.
Diff
diff --git a/AmazonRDS/latest/UserGuide/db2-managing-databases.md b/AmazonRDS/latest/UserGuide/db2-managing-databases.md index a75e76a61..c77f0e335 100644 --- a//AmazonRDS/latest/UserGuide/db2-managing-databases.md +++ b//AmazonRDS/latest/UserGuide/db2-managing-databases.md @@ -5 +5 @@ -Creating a databaseConfiguring settings for a databaseModifying database parametersConfiguring log retentionListing log informationDeactivating a databaseActivating a databaseReactivating a databaseDropping a databaseRestoring a databaseListing databasesCollecting information about databasesForcing applications off of databasesGenerating performance reports +Creating a databaseConfiguring settings for a databaseModifying database parametersConfiguring log retentionListing log informationDeactivating a databaseActivating a databaseReactivating a databaseDropping a databaseBacking up a databaseRestoring a databaseListing databasesCollecting information about databasesForcing applications off of databasesGenerating performance reports @@ -32,0 +33,2 @@ You can also perform common management tasks such as monitoring, maintenance, an + * Backing up a database + @@ -245,0 +248,45 @@ You can drop a database by calling the stored procedure only if certain conditio +## Backing up a database + +To back up a database in your RDS for Db2 DB instance to Amazon S3, call the `rdsadmin.backup_database` stored procedure. For more information, see [BACKUP DATABASE command](https://www.ibm.com/docs/en/db2/11.5.x?topic=commands-backup-database) in the IBM Db2 documentation. + +###### Note + +This stored procedure uses the integration with Amazon S3. Make sure that you have configured the integration before proceeding. For more information, see [Integrating an Amazon RDS for Db2 DB instance with Amazon S3](./db2-s3-integration.html). + +###### To back up a database + + 1. Connect to the `rdsadmin` database using the master username and master password for your RDS for Db2 DB instance. In the following example, replace `master_username` and `master_password` with your own information. + + db2 "connect to rdsadmin user master_username using master_password" + + 2. Create a VPC gateway endpoint for S3. If you already have a VPC gateway endpoint for S3, skip to Step 4. + +For an RDS for Db2 DB instance to be able to interact with Amazon S3, you must have a VPC and an Amazon S3 gateway endpoint for private subnets to use. For more information, see [Step 1: Create a VPC gateway endpoint for Amazon S3](./db2-troubleshooting.html#db2-creating-endpoint). + + 3. Confirm the VPC gateway endpoint for S3. For more information, see [Step 2: Confirm that your VPC gateway endpoint for Amazon S3 exists](./db2-troubleshooting.html#db2-confirming-endpoint). + + 4. Back up a database by calling `rdsadmin.backup_database`. For more information, see [rdsadmin.backup_database](./db2-sp-managing-databases.html#db2-sp-backup-database). + + db2 "call rdsadmin.backup_database( + ?, + 'database_name', + 's3_bucket_name', + 's3_prefix', + 'backup_type', + 'compression_option', + 'util_impact_priority', + 'num_files', + 'parallelism', + 'num_buffers')" + + 5. Terminate your connection. + + terminate + + 6. (Optional) Confirm that the backup files were uploaded to your Amazon S3 bucket under `s3_prefix/dbi_resource_id/db_name`. If the files don't appear at `s3_prefix/dbi_resource_id/db_name`, check the status of backing up your database to identify any issues. For more information, see [rdsadmin.get_task_status](./db2-user-defined-functions.html#db2-udf-get-task-status). If you can't resolve any identified issues, contact [AWS Support](https://aws.amazon.com/premiumsupport/). + + 7. (Optional) After the backup to Amazon S3 completes, you can restore the backup to an RDS for Db2 DB instance or to another location such as a local server. For information about restoring to an RDS for Db2 DB instance, see Restoring a database. + + + +