Compression will reduce the storage requirements for your data server and often will improve performance. These Best Practices explain how to best use data row compression and table compression in the context of a larger storage strategy.
The objective of this document is to communicate best practices for the use of DB2's Deep Compression solution. Compression allows you to use less data pages to store table data. The benefits you can realize from using these best practices include the following features:
- Your data consumes less storage
- Your data consumes storage at a slower rate
- Your database performance improves, depending on your environment
Also mentioned in this document is how deep compression (or data row compression or table compression) fits within the context of a larger storage strategy, which includes value compression and backup compression. This discussion includes best practices for implementing data row compression including the use of the automatic dictionary creation (ADC) feature in DB2 Version 9.5.
IBM customers using the deep compression feature and these best practices have
experienced reductions in the size of their databases of up to 50 percent and greater along
with improvements in application response time as high as 30 percent.
- Executive Summary
- Overview of Compression
- Building the compression dictionary
- Choosing candidate tables for compression
- Estimating compression ratios
- Compression using table reorganization
- Mitigate the use of table reorganization
- Monitor compression effectiveness
- Reclaiming table space allocated space
- Separate large tables into their own table space
- Many tables in a table space
-
Additional types of compression
- NULL or value compression
- Backup compression
- Best practices
- Conclusion
- Further reading
- Notices
"
Deep Compression
"
(June 2008)
Compression will reduce the storage requirements for your data server
and often will improve performance. These Best Practices explain how to
best use data row compression and table compression in the context of a
larger storage strategy. (pdf; 523KB; 25 pages)
Also available in the following translated versions:
Comment, edit, or add your own insights to the Deep Compression best practices
on the IBM Database Wiki
Check out all the other Best Practices papers and see how you can improve your experience with DB2 for Linux, UNIX, and Windows.
| 
