Enabling BLU Acceleration for a DB2 10.5 virtual application pattern deployment

You can configure DB2® 10.5 in a virtual application pattern deployment to use BLU Acceleration.

About this task

Configuring DB2 for use with BLU Acceleration allows you to use features like in-memory caching and columnar storage. The database tables will be column-organized without needing to specify the ORGANIZE BY COLUMN clause in the create table command. Users can create row-organized tables by specifying theORGANIZE BY ROW clause.

The database must be configured for Unicode with identity collation.

The ANALYTICS setting ensures a number of database configurations are set automatically. For more information, see the following DB2 topic about system environment variables:http://pic.dhe.ibm.com/infocenter/db2luw/v10r5/index.jsp?topic=%2Fcom.ibm.db2.luw.admin.regvars.doc%2Fdoc%2Fr0005658.html

DB2 Enterprise 10.5 with BLU Acceleration cannot be used with a high availability cluster.

Procedure

  1. From the console, deploy the DB2 10.5 standalone database from the Virtual System Instances pane. Make sure that the Database creation option of the DB2 configuration window is set to Do-nothing.
  2. Log in to the virtual machine using SSH.
  3. Issue the following command to set the DB2_WORKLOAD registry variable to ANALYTICS prior to creating the database:

    db2set DB2_WORKLOAD=ANALYTICS

  4. Issue the following command to stop DB2:

    db2stop force

  5. Issue the following command to start DB2:

    db2start

  6. Issue the following command to create a database.

    db2 create database bluDB using codeset UTF-8 territory CA collate using IDENTITY