How to create DB2 with BLU Acceleration database to speed your analytics applications

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.

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.

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.

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.

Below are steps to create the BLU database -

  1. Set the DB2_WORKLOAD registry variable to ANALYTICS


 2. Stop and Start the instance db2inst1

        db2stop force


  1. Create the BLU enabled database

                     db2 create database BLU_DB

  1. Connect to the TEST database   

                       db2 connect to db BLU_DB

  1. Check out the database configuration file

                db2 get db cfg | grep –I dft

You will observe that default table organization is set to COLUMN

These posts are my opinions and do not necessarily represent IBM’s positions, strategies, or opinions

Happy Reading!!


Ramya Yeleswarapu
mailto :- ramyeles@in[dot]ibm[dot]com

Views: 527


You need to be a member of ChannelDB2 to add comments!

Join ChannelDB2

Featured Downloads

Try BLU Acceleration on Cloud

© 2020   Created by channeldb2.   Powered by

Badges  |  Report an Issue  |  Terms of Service