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 organization leverage analytics for better decision making, improve performance, ease database administration, streamline development, and lower data management costs.

Autonomics

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

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

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

High Availability

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

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

Performance Optimization

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

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

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

Security

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

SQL compatibility

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

Storage Optimization

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

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 analyze past, current, and future events. To help organizations achieve these goals, IBM has built bi-temporal capabilities directly into the database.