IBM® DB2® Version 10.1 for Linux, UNIX, and Windows continues to deliver database efficiency, simplicity, and reliability. Important new features and enhancements address the needs of your business. Whether your needs are improving business critical reliability and performance, simplifying consolidation and security, increasing business insight, reducing costs, or providing a resilient system for the valuable information assets of your company, DB2 Version 10.1 delivers.
Your DB2 database provides comprehensive compression for almost every type of database object including table data, indexes, temporary tables, XML documents, log files and backup images. In previous versions, classic row compression helped lower storage costs and improve query performance. DB2 Version 10.1 further enhances classical table compression through a new type of compression, adaptive compression.
The adaptive compression feature improves table compression through an advanced row compression technique that uses two levels of compression dictionaries (table-level and page-level) to improve compression ratios, particularly as data changes. Page-level compression dictionaries are smaller than table-level dictionaries so as data changes on a page it is easy to update automatically and quickly, and removes the need to perform table reorganizations to update page-level dictionaries.
Even easier, in DB2 Version 10.1, new tables use adaptive compression by default. Existing tables from previous DB2 releases can easily use adaptive compression by simply enabling it.
For more information about adaptive compression, see Row compression rates and ease of use have improved.
DB2 Version 10.1 provides critical enhancements to security and auditing by introducing row and column access control (RCAC) as a solution to help you further secure your data. RCAC is sometimes referred to as fine-grained access control or FGAC.
RCAC security allows you to easily create varying security rules at the data level. These security rules ensure that users, who are members of the approved roles or groups, see only the data they are allowed to see, and removes security constraints and performance headaches resulting from complex views and predicates. Setup is quick and simple, and security is easy to handle even for complex enterprise systems.
For more information about RCAC, see Row and column access control (RCAC) enhances data security.
Reduce risk and cost associated with growing your distributed database solution by providing extreme capacity and application transparency. Designed for continuous availability, high availability capable of exceeding even the strictest industry standard, the IBM DB2 pureScale® Feature tolerates both planned maintenance and component failure with ease.
The DB2 pureScale Feature was first introduced in Version 9.8. Version 10.1 builds on DB2 pureScale Feature support.
For more information, see DB2 pureScale Feature enhancements.
Assign priority to data (hot, warm, cold) and dynamically assign it to different classes of storage. For example, transaction records for the current quarter can be stored on high-performance storage, and after the quarter ends and the data is no longer considered hot, it can be moved to cheaper storage. Total cost of ownership savings are considerable, allowing efficient deployment of storage hardware, and minimal administrative overhead.
For more information about multi-temperature storage, see Multi-temperature data storage can provide fast access to data.
Building on prior release performance improvements (such as, automatic performance improvements and RUNSTATS command improvements), DB2 Version 10.1 performance improvements focus on reducing CPU processing time without causing significant administration or application changes. Most performance improvements are implemented by simply upgrading to Version 10.1. You can gain significant performance improvements from improved query optimizer techniques and functionality including star schema query optimization, improved data and index prefetching, and improved use of statistical views. There are also additional RUNSTATS command improvements, improved performance for queries on tables with composite indexes, as well as improved multi-core parallelism.
DB2 Version 10.1 makes it simpler for you to write and run efficient SQL queries, as well as, making your existing SQL queries run faster, often without any changes.
For more information, see Performance enhancements.
If you work with relational database products other than DB2 products, Version 10.1 builds on existing functionality, interfaces, and compatibility features to provide additional enhancements that make DB2 products more familiar to you. These enhancements reduce the time and complexity of enabling applications written for other relational database products to run quickly in a DB2 environment.
For more information, see SQL compatibility enhancements.
Time Travel Query makes your database time-aware and keeps a history of your data changes using temporal tables. You can travel to the past and query your data as it appeared at different points in time.
Time Travel Query is easily enabled for existing tables using the ALTER TABLE statement, including existing tables from previous DB2 releases. You can store and retrieve time-based data without additional application logic.
For more information about Time Travel Query, see Manage and query time-based data using temporal tables.
DB2 Version 10.1 contains many other enhancements and new functionality. For details, see the enhancements listed in What's New.