Feature spotlights

Database flexibility

Enables you to optimize database performance based on transactional and analytical workloads. Provides clustering for high-speed transactional workloads. Offers in-memory columnar technology to deliver very fast performance without the constraints of other in-memory systems. Handles all workload types locally or in the cloud.

High availability, disaster recovery and workload management

Provides high availability and disaster recovery (HADR) for partial and complete site failures. Protects against data loss by replicating data changes from a source database. Includes capabilities for always-available transactions. When coupled with HADR, this further mitigates the impact of unplanned outages. Offers advanced workload management to optimize the handling of mixed workloads and random inputs and outputs.

Simple to administer

Enables you to easily administer, monitor, manage and optimize the performance of Db2 databases. Simplifies database administrative tasks for both expert and novice users. Consolidates information in a single graphical interface that is accessible from any standard web browser.

Developer tooling

Includes IBM Data Studio, a collaborative tool to streamline database development and simplify administration, and IBM InfoSphere® Data Architect, which helps you discover, model and standardize diverse data assets. Also provides SQL compatibility features to help reduce the cost and risk of migrating legacy Oracle database applications to Db2.

Advanced security

Provides native data encryption at rest to assist with security and regulatory requirements. Includes encryption of the entire database and backup images. Provides simple access control methods for developing highly secure database applications.

Better performance with AI

Facilitates deeper insights more quickly and supports AI applications with greater ease. Combined with Db2’s existing performance-boosting technology, the AI enhancements of Db2 version 11.5 make Db2 an ideal solution to help your business climb the ladder to a robust AI practice.

Data science support

Supports languages like PYTHON and GO, architectures like JSON and collaborative development environments like Jupyter Notebooks to help ensure developers and DBAs have access to innovative data science tools. Ultimately, this serves two functions: Db2 developers can now access and use data science features to drive deeper insights, and data scientists can rely on the performance, dependability and general enterprise-readiness of Db2.

Significantly faster querying

Optimizes data platform performance with well executed queries. Based on customer engagements, IBM's own distinguished engineer estimates that 25–30 percent of customer DBA time is spent managing access paths  —  where even minor performance regressions can cause disruption to the business and increase the impact to IBM support. This level of effort makes it difficult for today’s DBAs to support other areas of their business.