One Comment on “Which type of compression is NOT provided as part of the DB2 Storage Optimization Feature?”

1. chowkwanyuk says:

   July 20, 2018 at 8:50 pm

   This feature includes data row compression and other compression types to help maximize the use of existing storage.

   Data row compression uses a table-level compression dictionary to compress data by row. Compressing data at the row level is advantageous because it allows repeating patterns that span multiple column values within a row to be replaced with shorter symbol strings, allowing for improved performance. In I/O-bound systems, it will not only reduce storage requirements but may improve overall performance.

   Index compression utilizes multiple algorithms to reduce the storage requirements for indexes and reduces the total storage footprint of your DB2® database.

   Temp compression will automatically compress the amount of space used for temp tables. This automated compression will help to both improve performance of business intelligence workloads using large temp tables as well as reducing the total storage needed by DB2 database systems.

   This feature is available as an option for DB2 Enterprise Server Edition only and can only be acquired if the underlying DB2 data server is licensed with the Processor Value Unit charge metric.

   https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/com.ibm.db2.luw.licensing.doc/doc/c0058537.html

   
   
   
   0

   
   
   
   0