HAQM Relational Database Service (HAQM 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.
HAQM RDS for Db2 FAQs
General
Open allWhat is HAQM RDS for Db2?
How do I get started with HAQM 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 HAQM RDS for Db2 database instance. For more information, visit the HAQM RDS interface documentation.
How can I manage my HAQM 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 HAQM CloudWatch and events and log activities with HAQM RDS Enhanced Monitoring.
Licensing and version support
Open allWhich Db2 database editions are available with HAQM RDS for Db2?
HAQM 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, HAQM RDS for Db2 supports migrations through backup and restore from a snapshot of v11.1 to an HAQM 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 HAQM RDS for Db2.
What Db2 licensing options are available with HAQM RDS for Db2?
HAQM 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 HAQM 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 HAQM 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
Open allWhat is Multi-AZ on HAQM RDS for Db2?
HAQM 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 HAQM RDS storage-level backup and recovery work?
HAQM 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?
HAQM RDS Enhanced Monitoring and CloudWatch are supported with HAQM 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 HAQM RDS for Db2 instances.
Is PITR supported with HAQM RDS for Db2?
Yes, HAQM RDS for Db2 supports PITR in the same Region.
Does HAQM RDS for Db2 support encryption at rest?
Yes, HAQM RDS for Db2 supports encryption at rest using AWS Key Management Service (AWS KMS). You can bring your own encryption keys. HAQM RDS for Db2 offers additional features, including encryption in transit and network isolation using HAQM Virtual Private Cloud (HAQM VPC). To learn more about HAQM RDS security features, visit HAQM RDS Security.