Adopting a hybrid environment

Use the db2convert command to retain some row-organized tables, but replace the rest with column-organized tables.

Before you begin

  • Ensure you implement best practices for column-organized table configuration
  • To minimize the impact of the configuration changes on the row-table applications, set the DEGREE value for the row-table applications to 1 and the column-table applications to ANY. Use the MAXIMUM_DEGREE attribute to achieve this.

About this task

One of the ways to convert row-organized to column-organized tables is the db2convert command. If the database is recoverable, you must backup the database before completing the conversion, as in the replacement method.

Procedure

To replace only some row-organized tables with column-organized tables in a non-recoverable database:

Run the db2convert command on the database schema and tables you would like to be column-organized: 
db2convert -d <name_of_database> -z <schema> –t <table_name>
Where:
  • -z specifies the schema name of one or more tables to convert.
  • –t specifies the unqualified name of the table to convert.