Best practices to compress Db2 column-organized tables

Best Practices to Compress Db2® Column-Organized Tables describes the recommended practices to achieve the best possible compression for BLU tables. It will start with flow charts that highlight the steps to look at the current compression ratio, determine the effectiveness of the column dictionaries, and build more effective dictionaries, followed by detailed descriptions of those steps. It will end with instructions to best maintain the BLU tables to keep a good compression ratio. Terminology used in BLU compression will be defined in each section.

Authors: Ron Liu, Bob Lyle, and Christina Lee