RDS for Db2 features - Amazon Relational Database Service
Supported features in RDS for Db2Unsupported features in RDS for Db2
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

RDS for Db2 features

Amazon RDS for Db2 supports most of the features and capabilities of the IBM Db2 database. Some features might have limited support or restricted privileges. For more information about the Db2 database features for specific Db2 versions, see the IBM Db2 documentation.

You can filter new Amazon RDS features on the What's New with Database? page. For Products, choose Amazon RDS. Then, you can search by using keywords such as Db2 2023.

Note

The following lists aren't exhaustive.

Supported features in RDS for Db2

RDS for Db2 supports features that include features that are native to IBM Db2 and features that are core to Amazon RDS.

Features native to IBM Db2

RDS for Db2 supports the following Db2 database features:

  • Creation of a standard database that uses a customer-defined code set, collation, page size, and territory. Use the Amazon RDS rdsadmin.create_database stored procedure.

  • Addition, deletion, or modification of local users and groups. Use the Amazon RDS stored procedures for Granting and revoking privileges.

  • Creation of roles with the Amazon RDS rdsadmin.create_role stored procedure.

  • Support for standard row-organized tables.

  • Support for analytic workload for column-organized tables.

  • Ability to define Db2-compatibility features such as Oracle and MySQL.

  • Support for Java-based external stored procedures.

  • Support for data encryption in transit by using SSL/TLS.

  • Monitoring the status of a database (ALIVE, DOWN, STORAGE_FULL, UNKNOWN, and STANDBY_CONNECTABLE).

  • Restoration of a customer-provided offline or online Linux (LE) database. Use Amazon RDS stored procedures for Managing databases.

  • Application of customer-provided Db2 archive logs to keep the database synchronized with self-managed Db2 databases. Use Amazon RDS stored procedures for Managing databases.

  • Support for Db2 instance-level and database-level auditing.

  • Support for homogeneous federation.

  • Ability to load a table from data files in Amazon Simple Storage Service (Amazon S3).

  • Authorizations granted to users, groups or roles, such as CONNECT, SYSMON, ACCESSCTRL, DATAACCESS, SQLADM, WLMADM, EXPLAIN, LOAD, or IMPLICIT_SCHEMA

Features core to Amazon RDS

RDS for Db2 supports the following core Amazon RDS features:

  • Custom parameter groups to assign to DB instances.

  • Creation, modification, and deletion of DB instances.

  • Restoration of a self-managed Db2 offline or online Linux (LE) database backup.

    Note

    To be able to restore your backup, don't provide a name for your database when you create a DB instance. For more information, see Creating an Amazon RDS DB instance.

  • Support of gp3, io2, and io1 storage types.

  • Use of Amazon Managed Microsoft AD for Kerberos authentication, and LDAP group authorization for RDS for Db2.

  • Modification of security groups, ports, instance types, storage, backup retention periods, and other settings for existing Db2 instances.

  • Deletion protection for DB instances.

  • Cross-Region point-in-time recovery (PITR).

  • Use of Amazon Key Management Service (Amazon KMS) for storage encryption and encryption at rest.

  • Multi-AZ DB instances with one standby for high availability.

  • Reboots of DB instances.

  • Updates to master passwords.

  • Restoration of DB instances to a specific time.

  • Backup and restoration of DB instances by using storage-level backups.

  • Start and stop of DB instances.

  • Maintenance of DB instances.

Unsupported features in RDS for Db2

RDS for Db2 doesn't support the following Db2 database features:

  • SYSADM, SECADM, and SYSMAINT access for the master user.

  • External stored procedures written in C, C++, or Cobol.

  • Multiple Db2 DB instances on a single host.

  • Multiple Db2 databases on a single RDS for Db2 DB instance.

  • External GSS-API plugins for authentication.

  • External third-party plugins to back up or restore Db2 databases.

  • Multi-node massively parallel processing (MPP), such as IBM Db2 Warehouse.

  • IBM Db2 pureScale.

  • High Availability Disaster Recovery (HADR).

  • Native database encryption.

  • Heterogeneous federation for Db2.

  • Cross-Region point-in-time-recovery (PITR) for encrypted backups.

  • Creation of non-fenced routines. For more information, see Non-fenced routines.

  • Creation of new non-automatic storage tablespaces. For more information, see Non-automatic storage tablespaces during migration