Select the actions on this page in order.
This step compares the different variations of table compression.
CALL ADMIN_CMD
('RUNSTATS ON TABLE CUSTOMER_ADDRESS_WITH_AUTO_COMPRESSION')
SELECT CAST(CAST(NPAGES AS DOUBLE)/256
AS DECIMAL(5,3))
FROM SYSIBM.SYSTABLES
WHERE CREATOR=?SCHEMA?
AND NAME='CUSTOMER_ADDRESS_WITH_AUTO_COMPRESSION'
The second step plots the previous table sizes against the automatically compressed table after it is reorganized.
If you hover your cursor over the bars in the graph you will see the exact sizes of each table. Notice how much space the reorganization step reclaimed from the first few megabytes.
Also notice that it still isn't as low as the table that was reorganized after compression was turned on. That is because a simple reorganization on an automatic table does not rebuild the compression dictionary. To do that you need to use the RESETDICTIONARY command parameter on the REORG command to rebuild everything.
Try going back to the previous step, add RESETDICTIONARY to the REORG command, rerun the command and the return to this step to see the results. You will need to rerun the actions on this page to update your results.
CALL ADMIN_CMD
('REORG TABLE ?SCHEMA?.CUSTOMER_ADDRESS_WITH_AUTO_COMPRESSION
RESETDICTIONARY');