DB2 for Linux, UNIX and Windows

Accelerate insight. Improve resiliency. Maintain flexibility.

Primary tab navigation

Features that ease development and administration

IBM® DB2® for Linux, UNIX and Windows introduces new features to help your organisation leverage analytics for better decision making, improve performance, ease database administration, streamline development, and lower data management costs.


Autonomics (US)

DB2 autonomic features can free your IT staff from many administration tasks giving them more time to focus on other activities which benefit the business.

BLU Acceleration (US)

IBM DB2 with BLU Acceleration is a breakthrough combination of innovations from IBM Research and Development Labs to simplify and accelerate reporting and analytics.

Data Warehouse Analytics (US)

DB2 warehouse analytics functionality provides high performing predictive and pattern analysis without moving your data into proprietary data mining platforms.

High Availability (US)

High availability features help ensure that your database remains operational both during planned or unplanned outages. Reduced down-time enables you to meet strict Service Level Agreements (SLAs) with no loss of data during infrastructure failures.

NoSQL Support (US)

DB2 gives you the flexibility to choose the most appropriate data model for each data management challenge.

Performance Optimisation (US)

DB2 has dominated key performance benchmarks over the years, including both OLTP and OLAP benchmarks. This world class performance means that businesses can do more work with their existing hardware, thereby avoiding or delaying costly server upgrades.

pureScale (US)

DB2 pureScale uses a cluster-based, shared-disk architecture to offer easy scalability and high availability. DB2 pureScale avoids many of the drawbacks of cluster solutions from other vendors, including the “cluster overhead” that limits their ability to scale beyond a few nodes.

pureXML (US)

With the native XML data support provided by DB2, you can enjoy breakthrough performance, minimise your data storage requirements, and benefit from IT staff productivity enhancements.

Security (US)

DB2 offers a comprehensive suite of security features that effectively and decisively minimise this threat, including access control for rows, columns and IT staff roles.

SQL compatibility (US)

The DB2 SQL compatibility feature can greatly reduce the cost and risk of moving legacy applications built for the Oracle® Database to DB2.

Storage Optimisation (US)

DB2 can dramatically reduce that cost with industry leading data compression technologies that compress tables, indexes, archive logs, temporary space, LOBs, XML, and back-up data. Adaptive data compression applies multiple compression techniques, including both table-wide and page-level compression, for maximum impact.

Time Travel Query (US)

Industry regulations and competitive pressures are prompting IT managers to maintain more data for longer periods of time and to provide better ways for business users to analyse past, current, and future events. To help organisations achieve these goals, IBM has built bi-temporal capabilities directly into the database.