In testing the new version of DB6CONV using the "Compress Data" option with an online table move I have had two instances so far where the resulting compression % was very low. For example
- compression check against table EKPO ( 159GB ) estimated 76%
- created a new large tablespace with 16k page size to move / compress EKPO into. (EKPO currently in a regular 16 page tablespace.)
- Moved / compressed EKPO into new table space and obtained a 55% compression
- Ran compression check again and still reporting a 76%
- Created a 2nd large 16k page size tabelspace and moved EKPO into this one (with compress data option checked) and received a 76% compression
Any idea what is causing this?
DB2 9.5 FP 5
ECC 604