Compression for tables and indexes
With version 9.7 its possible to compress both data and indexes.We´ll like to do this during an OTM via db6conv where the normal table compression was also possible in former versions.
Now the quesition is, are the indexes also im compression mode if we activate this for the table or should we use both commands
db2 "alter table compress yes"
before starting OTM?
Is there any command to compress all indexes for one table in one command. Can I use any automtic function to compress the most indexes?
Joachim Müller replied
short answer. Yes...
Here are some links for compression with OTM:
Attached there you will find a PDF document.
New in Version 9.7 of IBM DB2 for Linux, UNIX, and Windows [original link is broken]
Here you will find a document, "Enabling DB2 LUW Version 9.7u2019s Index Compression in an SAP environment"