DB2 10.1 for LUW reduces overall database licensing, administration and storage costs whilst improving operational efficiency

Business Benefits

DB2 10.1 is the latest LUW release from IBM and comes with a wealth of new features offering exciting new capabilities that can help save you time and money.

With a reduction in overall database licensing, administration and storage costs, DB2 10.1 delivers real and quantifiable business benefits through increased performance, enhanced security, management features, extreme scalability and faster applications development.

Improved Productivity and Cost Savings

DB2 10.1 aids developers’ and database administrators’ productivity, eases the effort and expense of deploying new applications, and takes advantage of query performance and compression involvements to help lower overall data management costs.

Top Functions

DB2 10.1 for LUW enables users to create time-aware tables and queries in less than an hour, protect data privacy with less duplication and designate optimal storage allocation for data based on its currency. Data can be compressed dynamically and incrementally and the new version lowers the costs and risks of creating and maintaining point-in-time queries.

Key Benefits & Improvements

  • Reduced Data Management Costs
  • Improved Productivity
  • Faster Performance
  • Enhanced Security
  • Improved Reliability
  • Faster Application Development
  • Simplified Administration
  • Query Performance and Compression Improvements

Listen to Iqbal Goralwalla explain further benefits of the new version in the following podcast: Click to Listen


Further functions of DB2 10.1 for LUW include:

Optimized Storage Utilisation: Multi-Temperature Data Management allows for grouping of hot, warm, and cold data on varying storage systems to help optimize performance while minimising cost.

Further Storage Savings with Improved Compression: Significant enhancements are evident with DB2's industry-leading compression technologies that now include the new Adaptive Compression, which can further help reduce storage needs.

Easier Business Trend Analysis and Application Development: Time Travel Query, based on the SQL 2011 standard, is integrated into the database engine to provide significant performance and manageability advantages.

Security Enhancements: Row and Column Access Control provides easy and flexible control over data access.

Performance Enhancements: DB2 10.1 LUW adds many enhancements designed to further increase the performance of queries.  Zigzag join is now available and is capable of delivering sub-second response time on complex multi-dimensional queries.

Continuous Data Ingest Utility: The ingest utility allows the seamless roll-in of external data feeds with minimal impact on operations, including long-running queries.

DB2 pureScale: The DB2 pureScale feature brings clustering technology to DB2 on distributed IBM Power® System and System x® platforms. Learn more

If you would like to find out more about the new DB2 10.1 functions and how they could benefit you, please give one of our experts a call on 0870 2411 550.