Select your cookie preferences

We use essential cookies and similar tools that are necessary to provide our site and services. We use performance cookies to collect anonymous statistics, so we can understand how customers use our site and make improvements. Essential cookies cannot be deactivated, but you can choose “Customize” or “Decline” to decline performance cookies.

If you agree, AWS and approved third parties will also use cookies to provide useful site features, remember your preferences, and display relevant content, including relevant advertising. To accept or decline all non-essential cookies, choose “Accept” or “Decline.” To make more detailed choices, choose “Customize.”

Amazon RDS for Db2 stored procedure reference

Focus mode
Amazon RDS for Db2 stored procedure reference - Amazon Relational Database Service

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.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

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

Buffer pools

Use the rdsadmin.alter_bufferpool stored procedure to modify a buffer pool for an RDS for Db2 database.

rdsadmin.alter_tablespace

Tablespaces

Use the rdsadmin.alter_tablespace stored procedure to modify a tablespace for an RDS for Db2 database.

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 an RDS for Db2 database.

rdsadmin.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

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 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 an RDS for Db2 database. 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 an RDS for Db2 database.

rdsadmin.create_database

Databases

Use the rdsadmin.create_database stored procedure to create an RDS for Db2 database.

rdsadmin.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

Tablespaces

Use the rdsadmin.create_tablespace stored procedure to create a tablespace for an RDS for Db2 database.

rdsadmin.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

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

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

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

Buffer pools

Use the rdsadmin.drop_bufferpool stored procedure to drop a buffer pool from an RDS for Db2 database.

rdsadmin.drop_database

Databases

Use the rdsadmin.drop_database stored procedure to drop an RDS for Db2 database.

rdsadmin.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

Tablespaces

Use the rdsadmin.drop_tablespace stored procedure to drop a tablespace from an RDS for Db2 database.

rdsadmin.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

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

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

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

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

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

Tablespaces

Use the rdsadmin.rename_tablespace stored procedure to rename a tablespace for an RDS for Db2 database.

rdsadmin.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

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

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.

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 an RDS for Db2 database. 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 an RDS for Db2 database.

rdsadmin.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

Databases

Use the rdsadmin.show_configuration stored procedure to return one or more settings that are modifiable for an RDS for Db2 database.

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 an RDS for Db2 database.
PrivacySite termsCookie preferences
© 2025, Amazon Web Services, Inc. or its affiliates. All rights reserved.