Getting up and running with DB2 BLU tables (DB2 10.5) in a nutshell

Summary
DB2 10.5 has been made available recently. One of the most interesting features is Columnar based tables and the BLU technology. This article will help you to get up and running in no time with your first BLU table.

Introduction
This week IBM made available DB2 10.5 for download and you can get a trial version of the product free of charge.

I have been looking after BLU tables and this was a great temptation to give it a try.
Indeed, one of the most relevant features of DB2 10.5 is the introduction of BLU Acceleration and Columnar tables. This is a new technology (to DB2 LUW) that has the potential to dramatically accelerate analytics queries. A key advantage is that BLU is embedded directly into the DB2 kernel and its implementations should be transparent for us, the users, apart of its performance advantages, of course.
Now we can create column organized tables, in contra-position to traditional row organized tables, in DB2 databases. DB2 10.5 embeds a vector processing engine in its core that takes in charge its handling. Some publications describe queries qualifying and touching 10 Terabytes of data being resolved in seconds, or less. A statement that is strong enough to keep many of us indifferent, right?
Another very interesting characteristic of Columnar based tables is simplicity. Whereas a row organized table requires the usual set of interactions that goes from designing the physical model to creating the best indexes for performance, BLU tables just need to be created and loaded. And that’s it. No more questions asked.

These notes are a recollection of the steps that I followed, and the problems that I encountered, while creating my first set of BLU tables. Hopefully these notes will help you to get started quickly with BLU as well.

Read more here: http://www.toadworld.com/platforms/ibmdb2/b/weblog/archive/2013/06/...

Views: 112

Add a Comment

You need to be a member of The World of DB2 to add comments!

Join The World of DB2

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

Forum

Introducing IBM Db2 for z/OS Developer Extension for Microsoft Visual Studio Code

Started by Calene Janacek in Application Development and DB2 Jul 30. 0 Replies

We are excited to announce that the first iteration of IBM Db2 for z/OS Developer Extension is available now as a free downloadable extension in the…Continue

QMF Governor

Started by Maitena Gallastegi Ginea in Application Development and DB2. Last reply by Maitena Gallastegi Ginea Jul 30. 4 Replies

Hi,We are using QMF Governor to limit the QMF queries of users.We have configured correctly and it is working OK. We want to get statistics of those queries canceled by QMF Governor but we are not able to discover where that information is stored.…Continue

© 2020   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service