General

What is Amazon RDS for Db2?

Amazon Relational Database Service (Amazon RDS) for Db2 is a fully managed, highly available, and secure relational database engine that makes it easy to set up, operate, and scale Db2 deployments in the cloud.

How do I get started with Amazon RDS for Db2?

You can get started by using the AWS Management Console, the AWS Command Line Interface (AWS CLI), or AWS CloudFormation to create a new Amazon RDS for Db2 database instance. For more information, visit the Amazon RDS interface documentation.

How can I manage my Amazon RDS for Db2 instance?

You can manage your instances with the AWS Management Console or AWS CLI. You can also monitor your RDS instance performance using Amazon CloudWatch and events and log activities with Amazon RDS Enhanced Monitoring.

Licensing and version support

Which Db2 database editions are available with Amazon RDS for Db2?

Amazon RDS for Db2 supports Db2 Standard and Advanced editions of Db2 v11.5.9 for Linux, Unix, and Windows (LUW) databases.

What should I do if I’m running v11.1 or an older Db2 version?

If you are on v11.1, Amazon RDS for Db2 supports migrations through backup and restore from a snapshot of v11.1 to an Amazon RDS for Db2 instance. If you are on an older version than v11.1, we recommend you upgrade to v11.5 prior to migrating to Amazon RDS for Db2.

What Db2 licensing options are available with Amazon RDS for Db2?

Amazon RDS for Db2 offers a Bring Your Own License (BYOL) model and the ability to subscribe to hourly licenses through the AWS Marketplace. With BYOL, you can use an existing Db2 license with Amazon RDS, whereas licensing through the AWS Marketplace are new Db2 licenses and you pay only for what you use with an hourly rate per core.

Can I switch from BYOL licensing to a license through the AWS Marketplace and vice versa?

Yes, you can switch between BYOL and licensing through the AWS Marketplace using point-in-time restore and selecting the license type of your choice when you restore. Note, downtime is required when switching licensing types.

Can I switch between Db2 Standard and Advanced Editions when using licenses through the AWS Marketplace?

Yes, you can switch between Db2 Standard and Advanced Editions using a point-in-time restore and selecting the edition of your choice when you restore. Note, downtime is required when switching your database edition.

How do minor version upgrades work for Amazon RDS for Db2?

With minor version upgrades, you can choose to manually modify the engine version or enable the automatic minor version upgrade.

Options and features

What is Multi-AZ on Amazon RDS for Db2?

Amazon RDS for Db2 offers Multi-AZ deployment with one standby in a different Availability Zone (AZ) but in the same AWS Region as your primary database. It uses synchronous replication to keep data in your standby database up to date. In the event of a failure, the primary database will failover to the standby database with zero data loss and no manual intervention in as little as 60 seconds.

How does Amazon RDS storage-level backup and recovery work?

Amazon RDS for Db2 automatically takes storage-level snapshots on a daily basis. Archive logs are extracted and uploaded every 5 minutes. Snapshots are retained for up to 35 days. Snapshots can be used to recover the database management system (DBMS) or create a copy of the DBMS in a different Region with point-in-time recovery (PITR). Note: AWS automatic snapshots cannot be exported outside of AWS.

What options do we have for user authentication?

We support local user authentication and AWS Managed Microsoft Active Directory (AD) with Kerberos.

What logging and monitoring tools are supported?

Amazon RDS Enhanced Monitoring and CloudWatch are supported with Amazon RDS for Db2. Db2 diagnostic logs are available in CloudWatch. See Monitoring Metrics in a DB Instance for more information. You can also use IBM Data Management Console (DMC) to monitor Amazon RDS for Db2 instances.

Is PITR supported with Amazon RDS for Db2?

Yes, Amazon RDS for Db2 supports PITR in the same Region.

Does Amazon RDS for Db2 support encryption at rest?

Yes, Amazon RDS for Db2 supports encryption at rest using AWS Key Management Service (AWS KMS). You can bring your own encryption keys. Amazon RDS for Db2 offers additional features, including encryption in transit and network isolation using Amazon Virtual Private Cloud (Amazon VPC). To learn more about Amazon RDS security features, visit Amazon RDS Security.