Select the three actions on this page in order.
This step is to provide an example of how to estimate compressed table size.
CALL ADMIN_CMD
('RUNSTATS ON TABLE CUSTOMER_ADDRESS_WITHOUT_COMPRESSION')
SELECT CAST(CAST(NPAGES AS DOUBLE)/256
AS DECIMAL(5,3))
FROM SYSIBM.SYSTABLES
WHERE CREATOR=?SCHEMA?
AND NAME='CUSTOMER_ADDRESS_WITHOUT_COMPRESSION'
SELECT TABNAME AS NAME,
PAGES_SAVED_PERCENT AS SAVINGS
FROM TABLE
(ADMIN_GET_TAB_COMPRESS_INFO
('?SCHEMA?',
CUSTOMER_ADDRESS_WITHOUT_COMPRESSION,
'ESTIMATE'))
The third step plots the current table size and the estimate table size (in MB) on a bar graph.