IIAS: Best Practices to Compress Db2 Column-Organized Tables

 View Only

IIAS: Best Practices to Compress Db2 Column-Organized Tables 

Wed September 29, 2021 05:22 PM

This document 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.
#IntegratedAnalyticsSystem

Statistics

0 Favorited
33 Views
1 Files
0 Shares
20 Downloads
Attachment(s)
pdf file
CompressionBestPractices_Db2_iias_2021.pdf   548 KB   1 version
Uploaded - Wed September 29, 2021