Amazon RDS for Db2 stored procedure reference

You can manage your Amazon RDS for Db2 DB instances running the Db2 engine by calling built-in stored procedures.

Stored procedure	Category	Description
rdsadmin.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	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	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	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	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	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	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	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 but set the complete_rollforward parameter to FALSE.
rdsadmin.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	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	Databases	Use the rdsadmin.create_database stored procedure to create a database on an RDS for Db2 DB instance.
rdsadmin.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	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	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	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	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	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	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	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	Databases	Use the rdsadmin.drop_database stored procedure to drop a database from an RDS for Db2 DB instance.
rdsadmin.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	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	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	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	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	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	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 stored procedure.
rdsadmin.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	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	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	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	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	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.
rdsadmin.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	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	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	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.uncatalog_storage_access	Storage access	Use the rdsadmin.uncatalog_storage_access stored procedure to remove a storage alias for accessing an Amazon S3 bucket with Db2 data files.
rdsadmin.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.

Topics

• Considerations for Amazon RDS for Db2 stored procedures

• Stored procedures for granting and revoking privileges for RDS for Db2

• Stored procedures for audit policies for RDS for Db2

• Stored procedures for buffer pools for RDS for Db2

• Stored procedures for databases for RDS for Db2

• Stored procedures for storage access for RDS for Db2

• Stored procedures for tablespaces for RDS for Db2