 Deep Compression
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.
|
