Skip to Content
0
Former Member
Jun 15, 2011 at 06:06 AM

Compression for tables and indexes

576 Views

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?

Regards

Olaf