
Chapter 3. Adaptive compression 45
3.3.3 Converting existing tables to use adaptive compression
Existing tables that are either uncompressed or compressed with classic
compression remain that way after upgrading to DB2 10. However, existing tables
can be converted to use adaptive compression with the following statement:
ALTER TABLE … COMPRESS YES ADAPTIVE
The DBAs at Great Toque Outdoors have decided to first convert the
TOQUE.PRODUCT_FORECAST table to adaptive compression, so they issue
the ALTER TABLE statement shown in Example 3-4.
Example 3-4 Altering a table to use adaptive compression
ALTER TABLE TOQUE.PRODUCT_FORECAST COMPRESS YES ADAPTIVE; ...