Serge,
thank you for the quick answer - the compression really did take place after
the reorg, I just failed to run the runstats :-)
So, after refreshing the stats the compression values indeed look very good
for the table:

AVGROWSIZE AVGCOMPRESSEDROWSIZE PCTPAGESSAVED AVGROWCOMPRESSIONRATIO
PCTROWSCOMPRESSED
---------- -------------------- ------------- ------------------------ ------------------------
173 173 71 +3,53826E+000
+1,00000E+002

Regards,
Damir



"Serge Rielau" <srielau@ca.ibm.com> wrote in message
news:62tcchF258nhsU1@mid.individual.net...
> Damir,
>
> I don't think you have an issue here.
> What you got was a warning, not an error. It looks like you got
> compressions for 2006-2008.
> Note that in DB2 9.5 the remaining partitions will automatically be
> compressed once sufficient data becomes available.
>
> Cheers
> Serge
> --
> Serge Rielau
> DB2 Solutions Development
> IBM Toronto Lab