Quote:
Originally Posted by Marcus_A
If the base table is compressed, then all indexes will be compressed by default.
|
Yes, that will be the case when you define the table in v9.7.
In my case I will be building a new server (win2008/db2v97) and restore the backup image (win2003/db2v95). Then the new database will be ready for use but the indexes will stil be uncompressed (I can see that when I punch the DDL with db2look). So I am working on "post restore" scripts to activate the 9.7 features.
But maybe my conclusions were wrong. I thought that all "SYSIBM.SQLxxx" indexes gave errors in the alter statement. It can be that I saw a MDC-index. That one cannot be compressed.