The following table type fields are compared before and after compress of DB2: metric Data type ColumnColumn name schema Data type name Length Scale Nulls limit --------- using PART_NUM sysibm character 15 0 NoCNTRY_CODE sysibm character 3 0 using sysibm character 3 0 using sysibm character 2 0 using sysibm date 4 sysibm date 4 0 NoSRP_PRICE sysibm decimal 19 4 sysibm decimal 19 4 sysibm decimal 19 4 sysibm decimal 19 4 sysibm decimal 19 4 sysibm decimal 19 4 sysibm decimal 19 4 sysibm decimal 19 4 sysibm decimal 19 4 sysibm decimal 19 4 sysibm decimal 19 4 sysibm decimal 19 4 sysibm decimal 19 4 sysibm decimal 19 4 sysibm decimal 19 4 sysibm timestamp 10 6 sysibm character 12 0 noSAP_ODS_ADD_DATE sysibm timestamp 10 6 NoMOD_BY_USER_NAME sysibm character 12 0 NoSAP_ODS_MOD_DATE sysibm timestamp 10 6 No 24 record (s) selected. select. tabschema,. tabname, decimal (B. pagesize *. npages/1024/1024, 20, 5) tablesize from syscat. tables a left join syscat. tablespaces B on. tbspaceid = B. tbspaceid where. TABSCHEMA = 'wwpp2' and. TABNAME = 'cntry _ price' and. type = 't'order by. tbspace C: \ Program Files (x86) \ IBM \ SQLLIB \ BIN> db2 select. tabschema,. tabname, decimal (B. pagesize *. npages/1024/1024, 20, 5) tablesize from syscat. tables a left join syscat. tablespaces B on. tbspaceid = B. tbspaceid where. TABSCHEMA = 'wwpp2' and. TABNAME = 'cntry _ price' and. type = 't'order by. tbspace tabschema tabname tablesize partition--------------------- WWPP2 CNTRY_PRICE 2562.00000 1 record (s) selected. c: \ Program Files (x86) \ IBM \ SQLLIB \ BIN> db2 select. tabschema,. tabname, decimal (B. pagesize *. npages/1024/1024, 20, 5) tablesize from syscat. tables a left join syscat. tablespaces B on. tbspaceid = B. tbspaceid where. TABSCHEMA = 'wwpp2' and. TABNAME = 'cntry _ price' and. type = 't'order by. tbspace tabschema tabname tablesize partition--------------------- WWPP2 CNTRY_PRICE 1964.00000 1 record (s) selected.