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.