AWS AmazonRDS documentation change
Summary
Updated terminology consistency by changing 'database on an RDS for Db2 DB instance' to 'an RDS for Db2 database' across multiple stored procedure descriptions. Removed entries for rdsadmin.activate_database, rdsadmin.deactivate_database, and rdsadmin.reactivate_database procedures.
Security assessment
Changes are editorial improvements for consistency and do not address specific security vulnerabilities. Removed procedures relate to database state management but lack evidence of security issue remediation. Security-related procedures like audit configuration remain documented without substantive changes.
Diff
diff --git a/AmazonRDS/latest/UserGuide/db2-stored-procedures.md b/AmazonRDS/latest/UserGuide/db2-stored-procedures.md index 38129ebe5..791075bca 100644 --- a/AmazonRDS/latest/UserGuide/db2-stored-procedures.md +++ b/AmazonRDS/latest/UserGuide/db2-stored-procedures.md @@ -11,37 +11,34 @@ Stored procedure | Category | Description -[rdsadmin.activate_database](./db2-sp-managing-databases.html#db2-sp-activate-database) | Databases | Use the `rdsadmin.activate_database` stored procedure to activate a database on a standalone RDS for Db2 DB instance. -[rdsadmin.add_groups](./db2-sp-granting-revoking-privileges.html#db2-sp-add-groups) | Granting and revoking privileges | Use the `rdsadmin.add_groups` stored procedure to add one or more groups to a user for a database on an RDS for Db2 DB instance. -[rdsadmin.add_user](./db2-sp-granting-revoking-privileges.html#db2-sp-add-user) | Granting and revoking privileges | Use the `rdsadmin.add_user` stored procedure to add a user to an authorization list for a database on an RDS for Db2 DB instance. -[rdsadmin.alter_bufferpool](./db2-sp-managing-buffer-pools.html#db2-sp-alter-buffer-pool) | Buffer pools | Use the `rdsadmin.alter_bufferpool` stored procedure to modify a buffer pool for a database on an RDS for Db2 DB instance. -[rdsadmin.alter_tablespace](./db2-sp-managing-tablespaces.html#db2-sp-alter-tablespace) | Tablespaces | Use the `rdsadmin.alter_tablespace` stored procedure to modify a tablespace for a database on an RDS for Db2 DB instance. -[rdsadmin.catalog_storage_access](./db2-sp-managing-storage-access.html#db2-sp-catalog-storage-access) | Storage access | Use the `rdsadmin.catalog_storage_access` stored procedure to catalog a storage alias for accessing an Amazon S3 bucket with Db2 data files for a database on an RDS for Db2 DB instance. -[rdsadmin.change_password](./db2-sp-granting-revoking-privileges.html#db2-sp-change-password) | Granting and revoking privileges | Use the `rdsadmin.change_password` stored procedure to change a user's password for a database on an RDS for Db2 DB instance. -[rdsadmin.complete_rollforward](./db2-sp-managing-databases.html#db2-sp-complete-rollforward) | Databases | Use the `rdsadmin.complete_rollforward` stored procedure to bring a database on an RDS for Db2 DB instance online from a `ROLL-FORWARD PENDING` state. A `ROLL-FORWARD PENDING` state occurs when you called [rdsadmin.rollforward_database](./db2-sp-managing-databases.html#db2-sp-rollforward-database) but set the `complete_rollforward` parameter to `FALSE`. -[rdsadmin.configure_db_audit](./db2-sp-managing-audit-policies.html#db2-sp-configure-db-audit) | Audit policies | Use the `rdsadmin.configure_db_audit` stored procedure to modify an audit policy for a database on an RDS for Db2 DB instance. If no audit policy exists, running this stored procedure creates an audit policy. -[rdsadmin.create_bufferpool](./db2-sp-managing-buffer-pools.html#db2-sp-create-buffer-pool) | Buffer pools | Use the `rdsadmin.create_bufferpool` stored procedure to create a buffer pool for a database on an RDS for Db2 DB instance. -[rdsadmin.create_database](./db2-sp-managing-databases.html#db2-sp-create-database) | Databases | Use the `rdsadmin.create_database` stored procedure to create a database on an RDS for Db2 DB instance. -[rdsadmin.create_role](./db2-sp-granting-revoking-privileges.html#db2-sp-create-role) | Granting and revoking privileges | Use the `rdsadmin.create_role` stored procedure to create a role to attach to a database on an RDS for Db2 DB instance. -[rdsadmin.create_tablespace](./db2-sp-managing-tablespaces.html#db2-sp-create-tablespace) | Tablespaces | Use the `rdsadmin.create_tablespace` stored procedure to create a tablespace for a database on an RDS for Db2 DB instance. -[rdsadmin.db2pd_command](./db2-sp-managing-databases.html#db2-sp-db2pd-command) | Databases | Use the `rdsadmin.db2pd_command` stored procedure collect information about a database on an RDS for Db2 DB instance. This information can help with monitoring and troubleshooting databases in RDS for Db2. -[rdsadmin.dbadm_grant](./db2-sp-granting-revoking-privileges.html#db2-sp-dbadm-grant) | Granting and revoking privileges | Use the `rdsadmin.dbadm_grant` stored procedure to grant one or more authorization types ( `DBADM`, `ACCESSCTRL`, or `DATAACCESS`) to one or more roles, users, or groups for a database on an RDS for Db2 DB instance. -[rdsadmin.dbadm_revoke](./db2-sp-granting-revoking-privileges.html#db2-sp-dbadm-revoke) | Granting and revoking privileges | Use the `rdsadmin.dbadm_revoke` stored procedure to revoke one or more authorization types ( `DBADM`, `ACCESSCTRL`, or `DATAACCESS`) from one or more roles, users, or groups for a database on an RDS for Db2 DB instance. -[rdsadmin.deactivate_database](./db2-sp-managing-databases.html#db2-sp-deactivate-database) | Databases | Use the `rdsadmin.deactivate_database` stored procedure to deactivate a database on an RDS for Db2 DB instance. You can deactivate databases to conserve memory resources. -[rdsadmin.disable_db_audit](./db2-sp-managing-audit-policies.html#db2-sp-disable-db-audit) | Audit policies | Use the `rdsadmin.disable_db_audit` stored procedure to stop audit logging and remove an audit policy from a database on an RDS for Db2 DB instance. -[rdsadmin.drop_bufferpool](./db2-sp-managing-buffer-pools.html#db2-sp-drop-buffer-pool) | Buffer pools | Use the `rdsadmin.drop_bufferpool` stored procedure to drop a buffer pool from a database on an RDS for Db2 DB instance. -[rdsadmin.drop_database](./db2-sp-managing-databases.html#db2-sp-drop-database) | Databases | Use the `rdsadmin.drop_database` stored procedure to drop a database from an RDS for Db2 DB instance. -[rdsadmin.drop_role](./db2-sp-granting-revoking-privileges.html#db2-sp-drop-role) | Granting and revoking privileges | Use the `rdsadmin.drop_role` stored procedure to delete a role from a database on an RDS for Db2 DB instance. -[rdsadmin.drop_tablespace](./db2-sp-managing-tablespaces.html#db2-sp-drop-tablespace) | Tablespaces | Use the `rdsadmin.drop_tablespace` stored procedure to drop a tablespace from a database on an RDS for Db2 DB instance. -[rdsadmin.force_application](./db2-sp-managing-databases.html#db2-sp-force-application) | Databases | Use the `rdsadmin.force_application` stored procedure to force applications off of a database on an RDS for Db2 DB instance to perform maintenance. -[rdsadmin.grant_role](./db2-sp-granting-revoking-privileges.html#db2-sp-grant-role) | Granting and revoking privileges | Use the `rdsadmin.grant_role` stored procedure to assign a role to a grantee role, user, or group in a database on an RDS for Db2 DB instance. You can also use this stored procedure to give the grantee role `DBADM` authorization to assign roles. -[rdsadmin.list_archive_log_information](./db2-sp-managing-databases.html#db2-sp-list-archive-log-information) | Databases | Use the `rdsadmin.list_archive_log_information` stored procedure to return information about archive logs for a database on an RDS for Db2 DB instance. This information includes details such as size and creation date of individual log files, and the total storage used by the archive log files. -[rdsadmin.list_users](./db2-sp-granting-revoking-privileges.html#db2-sp-list-users) | Granting and revoking privileges | Use the `rdsadmin.list_users` stored procedure to return a list of users on an authorization list for a database on an RDS for Db2 DB instance. -[rdsadmin.reactivate_database](./db2-sp-managing-databases.html#db2-sp-reactivate-database) | Databases | Use the `rdsadmin.reactivate_database` stored procedure to reactivate a database on an RDS for Db2 DB instance after you make database configuration changes. For a database on a standalone DB instance, you can use either this stored procedure or the [rdsadmin.activate_database](./db2-sp-managing-databases.html#db2-sp-activate-database) stored procedure. -[rdsadmin.remove_groups](./db2-sp-granting-revoking-privileges.html#db2-sp-remove-groups) | Granting and revoking privileges | Use the `rdsadmin.remove_groups` stored procedure to remove one or more groups from a user for a database on an RDS for Db2 DB instance. -[rdsadmin.remove_user](./db2-sp-granting-revoking-privileges.html#db2-sp-remove-user) | Granting and revoking privileges | Use the `rdsadmin.remove_user` stored procedure to remove a user from an authorization list for a database on an RDS for Db2 DB instance. -[rdsadmin.rename_tablespace](./db2-sp-managing-tablespaces.html#db2-sp-rename-tablespace) | Tablespaces | Use the `rdsadmin.rename_tablespace` stored procedure to rename a tablespace for a database on an RDS for Db2 DB instance. -[rdsadmin.restore_database](./db2-sp-managing-databases.html#db2-sp-restore-database) | Databases | Use the `rdsadmin.restore_database` stored procedure to restore a database on an RDS for Db2 DB instance from an Amazon S3 bucket. -[rdsadmin.revoke_role](./db2-sp-granting-revoking-privileges.html#db2-sp-revoke-role) | Granting and revoking privileges | Use the `rdsadmin.revoke_role` stored procedure to revoke a role from a grantee role, user, or group in a database on an RDS for Db2 DB instance. -[rdsadmin.rollforward_database](./db2-sp-managing-databases.html#db2-sp-rollforward-database) | Databases | Use the `rdsadmin.rollforward_database` stored procedure to bring a database on an RDS for Db2 DB instance online, and to apply transaction logs after you restored a database on an RDS for Db2 DB instance by calling [rdsadmin.restore_database](./db2-sp-managing-databases.html#db2-sp-restore-database). -[rdsadmin.set_archive_log_retention](./db2-sp-managing-databases.html#db2-sp-set-archive-log-retention) | Databases | Use the `rdsadmin.set_archive_log_retention` stored procedure to configure how long to retain archive log files for a database on an RDS for Db2 DB instance. You can also use this stored procedure to disable archive log retention. -[rdsadmin.set_configuration](./db2-sp-managing-databases.html#db2-sp-set-configuration) | Databases | Use the `rdsadmin.set_configuration` stored procedure to configure certain settings for a database on an RDS for Db2 DB instance. -[rdsadmin.show_archive_log_retention](./db2-sp-managing-databases.html#db2-sp-show-archive-log-retention) | Databases | Use the `rdsadmin.show_archive_log_retention` stored procedure to return the current archive log retention setting for a database on an RDS for Db2 DB instance. -[rdsadmin.show_configuration](./db2-sp-managing-databases.html#db2-sp-show-configuration) | Databases | Use the `rdsadmin.show_configuration` stored procedure to return one or more settings that are modifiable for a database on an RDS for Db2 DB instance. +[rdsadmin.add_groups](./db2-sp-granting-revoking-privileges.html#db2-sp-add-groups) | Granting and revoking privileges | Use the `rdsadmin.add_groups` stored procedure to add one or more groups to a user for an RDS for Db2 database. +[rdsadmin.add_user](./db2-sp-granting-revoking-privileges.html#db2-sp-add-user) | Granting and revoking privileges | Use the `rdsadmin.add_user` stored procedure to add a user to an authorization list for an RDS for Db2 database. +[rdsadmin.alter_bufferpool](./db2-sp-managing-buffer-pools.html#db2-sp-alter-buffer-pool) | Buffer pools | Use the `rdsadmin.alter_bufferpool` stored procedure to modify a buffer pool for an RDS for Db2 database. +[rdsadmin.alter_tablespace](./db2-sp-managing-tablespaces.html#db2-sp-alter-tablespace) | Tablespaces | Use the `rdsadmin.alter_tablespace` stored procedure to modify a tablespace for an RDS for Db2 database. +[rdsadmin.catalog_storage_access](./db2-sp-managing-storage-access.html#db2-sp-catalog-storage-access) | Storage access | Use the `rdsadmin.catalog_storage_access` stored procedure to catalog a storage alias for accessing an Amazon S3 bucket with Db2 data files for an RDS for Db2 database. +[rdsadmin.change_password](./db2-sp-granting-revoking-privileges.html#db2-sp-change-password) | Granting and revoking privileges | Use the `rdsadmin.change_password` stored procedure to change a user's password for an RDS for Db2 database. +[rdsadmin.complete_rollforward](./db2-sp-managing-databases.html#db2-sp-complete-rollforward) | Databases | Use the `rdsadmin.complete_rollforward` stored procedure to bring an RDS for Db2 database online from a `ROLL-FORWARD PENDING` state. A `ROLL-FORWARD PENDING` state occurs when you called [rdsadmin.rollforward_database](./db2-sp-managing-databases.html#db2-sp-rollforward-database) but set the `complete_rollforward` parameter to `FALSE`. +[rdsadmin.configure_db_audit](./db2-sp-managing-audit-policies.html#db2-sp-configure-db-audit) | Audit policies | Use the `rdsadmin.configure_db_audit` stored procedure to modify an audit policy for an RDS for Db2 database. If no audit policy exists, running this stored procedure creates an audit policy. +[rdsadmin.create_bufferpool](./db2-sp-managing-buffer-pools.html#db2-sp-create-buffer-pool) | Buffer pools | Use the `rdsadmin.create_bufferpool` stored procedure to create a buffer pool for an RDS for Db2 database. +[rdsadmin.create_database](./db2-sp-managing-databases.html#db2-sp-create-database) | Databases | Use the `rdsadmin.create_database` stored procedure to create an RDS for Db2 database. +[rdsadmin.create_role](./db2-sp-granting-revoking-privileges.html#db2-sp-create-role) | Granting and revoking privileges | Use the `rdsadmin.create_role` stored procedure to create a role to attach to an RDS for Db2 database. +[rdsadmin.create_tablespace](./db2-sp-managing-tablespaces.html#db2-sp-create-tablespace) | Tablespaces | Use the `rdsadmin.create_tablespace` stored procedure to create a tablespace for an RDS for Db2 database. +[rdsadmin.db2pd_command](./db2-sp-managing-databases.html#db2-sp-db2pd-command) | Databases | Use the `rdsadmin.db2pd_command` stored procedure collect information about an RDS for Db2 database. This information can help with monitoring and troubleshooting RDS for Db2 databases. +[rdsadmin.dbadm_grant](./db2-sp-granting-revoking-privileges.html#db2-sp-dbadm-grant) | Granting and revoking privileges | Use the `rdsadmin.dbadm_grant` stored procedure to grant one or more authorization types ( `DBADM`, `ACCESSCTRL`, or `DATAACCESS`) to one or more roles, users, or groups for an RDS for Db2 database. +[rdsadmin.dbadm_revoke](./db2-sp-granting-revoking-privileges.html#db2-sp-dbadm-revoke) | Granting and revoking privileges | Use the `rdsadmin.dbadm_revoke` stored procedure to revoke one or more authorization types ( `DBADM`, `ACCESSCTRL`, or `DATAACCESS`) from one or more roles, users, or groups for an RDS for Db2 database. +[rdsadmin.disable_db_audit](./db2-sp-managing-audit-policies.html#db2-sp-disable-db-audit) | Audit policies | Use the `rdsadmin.disable_db_audit` stored procedure to stop audit logging and remove an audit policy from an RDS for Db2 database. +[rdsadmin.drop_bufferpool](./db2-sp-managing-buffer-pools.html#db2-sp-drop-buffer-pool) | Buffer pools | Use the `rdsadmin.drop_bufferpool` stored procedure to drop a buffer pool from an RDS for Db2 database. +[rdsadmin.drop_database](./db2-sp-managing-databases.html#db2-sp-drop-database) | Databases | Use the `rdsadmin.drop_database` stored procedure to drop an RDS for Db2 database. +[rdsadmin.drop_role](./db2-sp-granting-revoking-privileges.html#db2-sp-drop-role) | Granting and revoking privileges | Use the `rdsadmin.drop_role` stored procedure to delete a role from an RDS for Db2 database. +[rdsadmin.drop_tablespace](./db2-sp-managing-tablespaces.html#db2-sp-drop-tablespace) | Tablespaces | Use the `rdsadmin.drop_tablespace` stored procedure to drop a tablespace from an RDS for Db2 database. +[rdsadmin.force_application](./db2-sp-managing-databases.html#db2-sp-force-application) | Databases | Use the `rdsadmin.force_application` stored procedure to force applications off of an RDS for Db2 database to perform maintenance. +[rdsadmin.grant_role](./db2-sp-granting-revoking-privileges.html#db2-sp-grant-role) | Granting and revoking privileges | Use the `rdsadmin.grant_role` stored procedure to assign a role to a grantee role, user, or group in an RDS for Db2 database. You can also use this stored procedure to give the grantee role `DBADM` authorization to assign roles. +[rdsadmin.list_archive_log_information](./db2-sp-managing-databases.html#db2-sp-list-archive-log-information) | Databases | Use the `rdsadmin.list_archive_log_information` stored procedure to return information about archive logs for an RDS for Db2 database. This information includes details such as size and creation date of individual log files, and the total storage used by the archive log files. +[rdsadmin.list_users](./db2-sp-granting-revoking-privileges.html#db2-sp-list-users) | Granting and revoking privileges | Use the `rdsadmin.list_users` stored procedure to return a list of users on an authorization list for an RDS for Db2 database. +[rdsadmin.remove_groups](./db2-sp-granting-revoking-privileges.html#db2-sp-remove-groups) | Granting and revoking privileges | Use the `rdsadmin.remove_groups` stored procedure to remove one or more groups from a user for an RDS for Db2 database. +[rdsadmin.remove_user](./db2-sp-granting-revoking-privileges.html#db2-sp-remove-user) | Granting and revoking privileges | Use the `rdsadmin.remove_user` stored procedure to remove a user from an authorization list for an RDS for Db2 database. +[rdsadmin.rename_tablespace](./db2-sp-managing-tablespaces.html#db2-sp-rename-tablespace) | Tablespaces | Use the `rdsadmin.rename_tablespace` stored procedure to rename a tablespace for an RDS for Db2 database. +[rdsadmin.restore_database](./db2-sp-managing-databases.html#db2-sp-restore-database) | Databases | Use the `rdsadmin.restore_database` stored procedure to restore an RDS for Db2 database from an Amazon S3 bucket. +[rdsadmin.revoke_role](./db2-sp-granting-revoking-privileges.html#db2-sp-revoke-role) | Granting and revoking privileges | Use the `rdsadmin.revoke_role` stored procedure to revoke a role from a grantee role, user, or group in an RDS for Db2 database. +[rdsadmin.rollforward_database](./db2-sp-managing-databases.html#db2-sp-rollforward-database) | Databases | Use the `rdsadmin.rollforward_database` stored procedure to bring an RDS for Db2 database online and to apply transaction logs after you restored an RDS for Db2 database by calling [rdsadmin.restore_database](./db2-sp-managing-databases.html#db2-sp-restore-database). +[rdsadmin.set_archive_log_retention](./db2-sp-managing-databases.html#db2-sp-set-archive-log-retention) | Databases | Use the `rdsadmin.set_archive_log_retention` stored procedure to configure how long to retain archive log files for an RDS for Db2 database. You can also use this stored procedure to disable archive log retention. +[rdsadmin.set_configuration](./db2-sp-managing-databases.html#db2-sp-set-configuration) | Databases | Use the `rdsadmin.set_configuration` stored procedure to configure certain settings for an RDS for Db2 database. +[rdsadmin.show_archive_log_retention](./db2-sp-managing-databases.html#db2-sp-show-archive-log-retention) | Databases | Use the `rdsadmin.show_archive_log_retention` stored procedure to return the current archive log retention setting for an RDS for Db2 database. +[rdsadmin.show_configuration](./db2-sp-managing-databases.html#db2-sp-show-configuration) | Databases | Use the `rdsadmin.show_configuration` stored procedure to return one or more settings that are modifiable for an RDS for Db2 database. @@ -49 +46 @@ Stored procedure | Category | Description -[rdsadmin.update_db_param](./db2-sp-managing-databases.html#db2-sp-update-db-param) | Databases | Use the `rdsadmin.update_db_param` stored procedure to update database parameters for a database on an RDS for Db2 DB instance. +[rdsadmin.update_db_param](./db2-sp-managing-databases.html#db2-sp-update-db-param) | Databases | Use the `rdsadmin.update_db_param` stored procedure to update database parameters for an RDS for Db2 database.