Skip to Content
0
Former Member
Jan 11, 2011 at 07:57 PM

DB6CONV v5.04 not fully compressing tables

35 Views

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