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 .
Procedure
To convert row-organized tables to column organization:
- 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.
- Open the Object List by clicking Tables in
the Administration Explorer.
- In the Object List, select one or more tables that you
want to convert to column organization.
- Right-click the selected tables and then click Convert
to Column Organization to open the Convert to
Column Organization task assistant.
- Follow the instructions in the Convert to Column
Organization task assistant to convert row-organized tables
to column organization.