Announcing Amazon RDS for Db2 12.1 with additional community edition

Amazon Relational Database Service (Amazon RDS) for Db2 now supports IBM Db2 12.1, the latest generation of the Db2 database engine. Alongside this upgrade, we’re introducing a new edition: Community Edition (db2-ce). You now have three edition choices when you provision an Amazon RDS for Db2 instance.

In this post, we walk through what’s new in Db2 12.1, introduce the Community Edition and when to use it, show you how to get started using the AWS Management Console, AWS Command Line Interface (AWS CLI), and Terraform, and cover the upgrade path from Db2 11.5.

What’s new in Db2 12.1

IBM Db2 12.1 is a significant release with more than 200 new features and enhancements. The highlights most relevant to RDS customers include:

AI-powered query optimization

Db2 12.1 integrates an AI Query Optimizer that uses machine learning (ML) to improve cardinality estimation. Cardinality estimation is the engine’s prediction of how many rows will flow through each step of a query plan. More accurate estimates lead to better query plans, which means improved performance for complex analytical and mixed workloads without any manual tuning. Models are trained faster, are more compact, and produce more accurate results with each successive mod pack release.

Namespace separation and multi-tenancy

Db2 12.1 introduces logical namespace separation. You can use it to isolate different sets of database schemas from each other within a single database. This gives database administrators a clean way to segment data objects for multiple teams or application tiers without the overhead of separate database instances.

Security enhancements

This release adds tablespace management authority, so DBAs can delegate tablespace creation and management within a storage group. This is a meaningful improvement for least-privilege access models. Combined with the existing RDS for Db2 integration with AWS Key Management Service (AWS KMS) and AWS Secrets Manager, this gives you a layered security posture that spans both the database engine and the AWS infrastructure layer.

Improved manageability

Additional enhancements in 12.1 cover external table management, centralized KMIP client certificate handling, and online movement of columnar tables. The 12.1.4 mod pack, the version launching with RDS for Db2 today, focuses specifically on reducing operational friction and expanding data connectivity to modern data platforms.

Introducing Community Edition (db2-ce)

Community Edition is a free-to-use-license edition of Db2, introduced with the 12.1 release, designed for developers, partners, and teams running smaller workloads. It carries the same Db2 code base as Standard and Advanced Editions. The difference is in resource entitlements rather than feature depth.

Community Edition carries the following resource limits imposed by the IBM license:

These limits apply at the Db2 engine level regardless of the underlying Amazon Elastic Compute Cloud (Amazon EC2) instance size. When you select an instance class for a Community Edition deployment, choose one that stays within this envelope. For example, db.r7i.xlarge (4 vCPUs, 32 GB RAM) or db.m7i.xlarge (4 vCPUs, 16 GB RAM) stays within the core limit, and Db2 will use up to 8 GB of that memory.

Note: Instance classes that exceed these thresholds are not blocked at provisioning time, but Db2 will only utilize resources up to the license limits.

On Amazon RDS for Db2, Community Edition means you can spin up a fully managed Db2 12.1 instance with no IBM software license cost. You pay only for the underlying AWS infrastructure (instance, storage, and I/O), following the standard RDS pricing model.

Note: Even though Community Edition carries no IBM license fee, Amazon RDS for Db2 still requires an IBM customer ID and IBM site ID in the DB parameter group for all editions, including db2-ce. These IDs are how IBM tracks usage and entitlement. You can obtain them at no charge by registering on the IBM website using your IBM account. For details on how these IDs are used and where to enter them, see Amazon RDS for Db2 licensing.

This lowers the barrier to getting started with Db2 on AWS for:

• Application development and testing – provision a Db2 instance for every branch or sprint without accumulating license costs.
• Proof of concept work – evaluate Db2 capabilities before committing to a production license.
• Small production workloads – run modest applications where the resource envelope of Community Edition is sufficient.

When your requirements grow, upgrading from Community Edition to Standard or Advanced Edition is a straightforward in-place engine edition change. You don’t need to migrate data or rebuild your infrastructure.

All existing RDS for Db2 capabilities apply to Db2 12.1

The full set of managed capabilities that you rely on with Db2 11.5 carries forward to Db2 12.1 across all three editions:

High availability

• Multi-AZ deployment with synchronous standby and automatic failover.

Disaster recovery and read scaling

• Read replicas and standby replicas, including cross-Region replicas for geographic disaster recovery.

Automated operations

• Automated backups with point-in-time recovery (PITR), automated minor version patching, and automated storage scaling.

Security

• Encryption at rest using AWS KMS customer managed keys.
• Encryption in transit using SSL/TLS.
• Kerberos authentication using AWS Directory Service for Microsoft Active Directory or on-premises Active Directory.
• AWS Identity and Access Management (IAM)-based role separation for monitoring, Amazon Simple Storage Service (Amazon S3) integration, directory service access, and audit logging.

Licensing flexibility

• Bring Your Own License (BYOL) – use your existing IBM Db2 licenses tracked through AWS License Manager.
• Hourly licensing via AWS Marketplace – pay-as-you-go IBM license billing, available for Standard and Advanced Editions.
• Community Edition (db2-ce) – no IBM software license fee, but an IBM customer ID and site ID are still required. Obtain them at no charge on the IBM website.

Observability

• Amazon CloudWatch metrics and logs for database performance monitoring.
• Enhanced Monitoring for OS-level metrics.
• Self enabled Db2 Monitoring using an AWS Lambda function.

Getting started

You can launch an RDS for Db2 12.1 instance today using the AWS Management Console, AWS CLI, AWS CloudFormation, or Terraform.

Console

1. Navigate to Amazon RDS in the AWS Console and choose Create database.
2. Select IBM Db2 as the engine.
3. Choose engine version 12.1.4 and select your edition: db2-ce, db2-se, or db2-ae.
4. Configure instance class, storage, Multi-AZ, and VPC settings.
5. Provide your IBM customer ID and IBM site ID. These are required for all editions including Community Edition. For Standard and Advanced Editions, you might alternatively select the AWS Marketplace license option for hourly billing.
6. Choose Create database.

CLI

aws rds create-db-instance \
    --db-instance-identifier my-db2-12-1 \
    --engine db2-ce \
    --engine-version 12.1.4.0.sb00080714.r1 \
    --db-instance-class db.r6i.xlarge \
    --master-username admin \
    --manage-master-user-password \
    --allocated-storage 100 \
    --storage-type gp3 \
    --db-subnet-group-name my-subnet-group \
    --vpc-security-group-ids sg-xxxxxxxxxxxxxxxxx \
    --no-publicly-accessible

Note: Choose latest engine version at the time of deploy using the following command:

aws rds describe-db-engine-versions \
    --query "DBEngineVersions[?contains(Engine,'db2')].{Engine:Engine,Version:EngineVersion,Family:DBParameterGroupFamily}" \
    --region <RegionName> --output table

Terraform

If you prefer infrastructure as code, a modular Terraform template for RDS for Db2 is available in the GitHub repository. The template covers remote state, networking, IAM roles, AWS KMS encryption, parameter groups, the RDS instance, and AWS License Manager integration in seven composable modules. For a full walkthrough, see Deploying Amazon RDS for Db2 using Terraform.

To select Community Edition, set the engine and edition in 5-rds/terraform.tfvars:

engine = "db2-ce"
engine_version = "12.1.4"

In 4-parameter-group/terraform.tfvars, the parameter group module accepts ce as a valid edition for Db2 12.1. IBM customer ID and site ID are still required even for Community Edition. Set them in the parameter group tfvars as you would for Standard or Advanced Edition. You can obtain both IDs free of charge on the Create an IBMid page.

Upgrading from Db2 11.5.9

If you’re currently running RDS for Db2 with engine version 11.5.9, you can upgrade to 12.1 through the standard RDS major version upgrade path. Before upgrading, review the Upgrading the Db2 engine version documentation for pre-upgrade checks and application compatibility notes.

A few things to keep in mind:

• Community Edition (db2-ce) is new in 12.1 and has no equivalent in 11.5.9. If you’re migrating a 11.5.9 Standard or Advanced Edition instance, you can choose to change edition at upgrade time. However, note that choosing community edition means that your instance will be subject to lower compute (4 vCPU and 8 GB of RAM) resources enforced by IBM.
• Replicas are automatically upgraded when the source DB instance is upgraded.
• The IBM customer ID and site ID parameters in the parameter group remain required for Standard and Advanced Edition upgrades.

Availability

Amazon RDS for Db2 12.1.4+ with Community Edition in addition to db2-se and db2-ae is available today in all AWS Regions where RDS for Db2 is supported, including AWS GovCloud (US) Regions. For the full list, see Amazon RDS for Db2 availability.

Conclusion

Amazon RDS for Db2 12.1 brings IBM’s latest database engine to a fully managed service. It pairs new capabilities like the AI Query Optimizer, namespace separation, and tablespace management authority with the operational features that you already rely on, such as Multi-AZ high availability, read and standby replicas, automated backups, and encryption with AWS KMS. The new Community Edition (db2-ce) lowers the barrier to entry. You can run a fully managed Db2 12.1 instance with no IBM software license fee for development, testing, and small production workloads, and upgrade to Standard or Advanced Edition as your needs grow. Whether you provision through the console, the AWS CLI, or the Terraform template in the GitHub repository, you can get started in minutes. To get started, visit the Amazon RDS console or see the Amazon RDS for Db2 documentation. Try Amazon RDS for Db2 12.1 today, and leave your questions or feedback in the comments.

Acknowledgements

Special thanks to Rajib Sarkar for reviewing this post.

About the authors