31 July 2013

DB2 10.5 New Features

DB2 10.5 New Features

 A short while ago the latest release of IBM’s magnificent DB2 10.5 was released, there are several new features, which are explained in detail at the following link:

The analytics accelerating feature BLU

 IBM DB2 with BLU Acceleration speeds analytics and reporting using dynamic in-memory columnar technologies. In-memory columnar technologies provide an extremely efficient way to scan and find relevant data. Coupled with innovations such as parallel vector processing and actionable compression, it makes your analytic queries far faster and less complex. So you can connect with the information you need at breakthrough speed and volume.

1) Analytics at the speed of thought

DB2 with BLU Acceleration combines advanced, innovative capabilities to accelerate analytic workloads for databases and data warehouses.

DB2 with BLU Acceleration also integrates with IBM Cognos® Business Intelligence to provide reporting and deeper analysis. You can analyze key facts and freely explore information from multiple angles and perspectives to make more informed decisions—all from within DB2.

2) Less data storage required

DB2 with BLU Acceleration dynamically moves data from storage. Database tuning, indexes and aggregates are not needed, which improves storage efficiency and helps lower your storage space requirement. In fact, clients have reported compression rates of 10 times that of un-compressed tables.

The system uses available hardware such as memory, I/O and CPU to help reduce memory latency and processing. Hardware optimization streamlines administration and maintenance, putting less load on resources.

3) Simplicity

BLU Acceleration is fully integrated with DB2. It does not require SQL or schema changes to implement. Just load and go. Enhancements such as automation, optimization and self-tuning help to further simplify overall use.


Webinar Replay of DB2 Tech Talk: "Introduction and Technical Tour: DB2 10.5 with BLU Acceleration" with Berni Schiefer





  When we compared the performance of column-organized tables in DB2 to our traditional row-organized tables, we found that, on average, our analytic queries were running 74x faster when using BLU Acceleration. ” 

- Kent Collins, Database Solutions Architect, BNSF Railway


Advanced Recovery Solutions in DB2 10.5 webinar replay



Analytics the real world use of BIG DATA

 Real world warehousing for technical professionals

 The Real-world Use of Big Data

Big Data for Health Care (Video)

 IBM DB2 Real Application clustering with Pure Scale

 Big Data Solution Demo

Join Nicolas Morales of IBM's Big Data Enablement Team as he walks you through a Big Data solution using IBM InfoSphere BigInsights to capture, store, transform and analyze social media data.

 Pure data for operational analytics presentation

 Big Data Opportunities for Marketing

Companies that want to succeed need to deliver the right message, to the right person, at the right time, for the right price. But companies face multiple challenges. Leading marketers are using big data and analytics to deliver greater value and relevance to their customers. Learn how in this video from IBM.

 Some useful blogs

IBM DB2 Community blogs
The DB2 Guys


The DB2 IBM website for DB2 10.5 for LUW


For more information please contact me at:

Drs. Albert Spijkers
DBA Consulting
web:            http://www.dbaconsulting.nl
blog:            DBA Consulting blog
profile:         DBA Consulting profile
Facebook :   DBA Consulting on Facebook
email:          info@dbaconsulting.nl 

0 reacties:

Post a Comment