DB2 10 for LUW Extends IBM’s DBMS Leadership in Even More Ways

IBM finally announced and will be making its new DB2 10 for Linux, UNIX and Windows (LUW) available to everyone April 30th.  IBM is always focused on better performance, reliability, availability and scalability and this new DB2 LUW version extends DB2 DBMS leadership over the competition.  In my last two previous weeks’ blogs I talked about several of the great features.  In the first week I highlighted the new Adaptive Compression, Temporal Data and new security Row and Column Access Controls.  Last week I talked about the improvements in the disaster recovery (HADR) capabilities, the DB2 access paths improvements and how the DB2 pureScale codebase is consolidated with this new DB2 10 for LUW version. 

This week I’ll highlight three more areas where DB2 10 for LUW extends its industry lead over its competitors by providing other additional capabilities designed for the latest demands of big data and robust computing capabilities. 

First DB2 10 for LUW provides new multi-temperature data management.  As our databases continue to grow larger every year this DB2 LUW capability provides a way to provide different storage management for different attributes of the data.  For example, in some systems database transactions reference the newest 20% of the database most frequently.  With the new DB2 LUW multi-temperature data management capabilities this high volume 20% of the database can be managed and directed to the fastest solid state drives and other data segregated to other storage devices.  This multi-temperature data management capability allows the data to remain online and be moved to other storage group devices as a background function when desired.  Through several functional administration aspects administrators can assign data attribute tags to interface with DB2 LUW’s workload management (WLM) capabilities. 

The DB2 LUW WLM management policies along with multi-temperature data management tags also provide improved query performance.  DB2 LUW knows the temperature and importance of the data and WLM is able to recognize the most important queries within the workloads and adjust the performance impact of queries running against the old non-high-performance data.  This adjustment provides extra resources for the critical workloads, better system management and improved performance through the new DB2 10 for LUW multi-temperature data management feature.

Next, DB2 10 for LUW also incorporates the new NoSQL Graph Store and the SPARQL query language.  The new graph data triples are becoming popular for big data processing.  The World Wide Web Consortium-W3C’s Resource Description Framework (RDF) standard has been approved, speeding graph data triples adoption by all types of new users and systems.  These factors paved the way for DB2 10 for LUW to incorporate and optimize this new standard data graph triple storage.  Typical data graph triple processing includes many self-joins and self-referencing situations and incorporating these techniques within DB2 10 for LUW improves processing tremendously over other existing Graph Store DBMS. 

Also by incorporating the SPARQL query language, DB2 LUW is able to include many new types of Java RDF APIs and support for HTTP SPARQL end-point queries. 

Third, DB2 10 for LUW offers a new Continuous Data Ingest utility for all types of data warehousing and online data requirements.  This new Continuous Data Ingest utility provides a way to continuously intake data into a table with no downtime impact and minimal query workload impact.  By avoiding any table locks, validating the data through SQL expressions and supporting various types of DML statements, the DB2 10 for LUW Continuous Data Ingest utility is able to process high volumes of data into robust database systems.  By also being available for the DB2 LUW Data Partition Facility (DPF) platform, the Continuous Data Ingest utility is able to route the rows to the correct partition and continuously process data for all types of data warehousing and big data requirements.

These and the other new features within DB2 10 for LUW continue to lead the industry in performance, reliability, availability and scalability.  Get a free copy of this new DB2 10 for LUW when IBM releases the new version April 30th.


I will be providing my first TWITTER comments during this year’s IDUG conference in May.  I will highlight the various conference activities, presentations, vendors and IBM announcements.  Please sign up to follow me on TWITTER (@DBeulke) and get all the latest IDUG DB2 related news from the conference. 


Sign up for IDUG today!

I look forward to speaking at the IDUG DB2 Tech Conference 2012 North America conference.  The conference will be held in Denver, Colorado on May 14-18, 2012.  Sign up today at www.idug.org.

Also, I am beginning to plan my Regional DB2 User Group support for the rest of 2012.  Please send an email to me at moc.ekluebevadnull@evad if you would like me to come and speak or offer a DB2 class at your local user group.


Dave Beulke is an internationally recognized DB2 consultant and DB2 training and education instructor.  Dave helps his clients improve their strategic direction, dramatically improve performance and reduce their CPU demand saving millions in their systems, databases and application areas within their mainframe, UNIX and Windows environments.

Leave a Reply

You can use these HTML tags

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>