Converting tables to column organization

Data Studio provides a task assistant that you can use to convert row-organized tables to column organization, which simplifies and speeds up reporting and analytics in DB2® databases. Column-organized tables enable your databases for BLU Acceleration, which is a capability that eliminates the need for indexes, aggregates, or time consuming database tuning to achieve top performance and storage efficiency.

Before you begin

For information about column-organized tables including a list of the known restrictions, see Column-organized tables in the DB2 documentation.

About this task

Column-organized tables are supported by DB2 databases for the AIX® and Linux operating systems, starting with DB2 version 10.5. Not all tables will benefit from column organization, but for workloads that are entirely analytics and OLAP workloads, the recommended approach is to put as many tables into column-organized format as possible.
Tip: You can use the Configure Parameters task assistant to set the DB2 configuration parameter DFT_TABLE_ORG to COLUMN so that all new tables that you create are column-organized by default. Open the Configure Parameters task assistant by right-clicking your database in the Administration Explorer, and then click Set Up and Configure > Configure.

Procedure

To convert row-organized tables to column organization:

  1. Optional: Use the Workload Table Organization Advisor in IBM® InfoSphere® Optim™ Query Workload Tuner to get recommendations and determine which tables you should convert to column organization.
  2. Open the Object List by clicking Tables in the Administration Explorer.
  3. In the Object List, select one or more tables that you want to convert to column organization.
  4. Right-click the selected tables and then click Convert to Column Organization to open the Convert to Column Organization task assistant.
  5. Follow the instructions in the Convert to Column Organization task assistant to convert row-organized tables to column organization.

Feedback