Deploying BLU Acceleration

DB2 with BLU Acceleration deployment made easy,
summary of a blog post by Whei-Jen Chen

December, 2014 update:  BLU Acceleration technology in the DB2 for Linux, UNIX and Windows product is now available on the Windows and zLinux platforms.  Read the details.

Deploying DB2 with BLU Acceleration is simple. With only handful of commands, you can turn on analytics mode, create a new or auto-configure an existing database to make best use of your hardware for analytics, and then load the data.

Here is a summary of these steps.  You can find more details of this process and an example here.

  1. Install DB2 10.5 on either AIX on POWER® or Linux on x86 64-bit.
    The BLU Acceleration feature comes with the following DB2 editions:
    For production environments: Advanced Enterprise Server Edition (AESE) or Advanced Workgroup Server Edition (AWSE)
    For non-production environments: Developer Edition (DE)
  2. Enable one DB2 registry variable DB2_WORKLOAD,  which is set to  ANALYTICS. It automatically configures relevant configuration parameters to optimize existing hardware capacity and performance of analytic workloads. 
  3. Create the database. In a typical scenario for analytical workloads, a DB2 instance would hold a single database. Autoconfigure does not use all the memory on the system by default.  If DB2 with BLU Acceleration is the only software running on the server, specify how much memory to use.
  4. Create the table and load the data and start querying this data!

If you already have existing table and object creation DDL statements from an existing data warehouse, you can reuse them without having to make changes to the table creation statements. Both column and row organization tables can coexist in the same database and even in the same table space.