January 23 2014
Informix – Compress data rows in a table
Tagged Under : Informix compress, informix repack, informix shrink, informix uncompress
Given (IDS 11.50),
Database : testdb
table : cust_comp
owner : hello
(1) Before Compression
$ oncheck -pt testdb:hello.cust_comp
…
TBLspace Flags 801 Page Locking
TBLspace use 4 bit bit-maps
…
Number of pages allocated 90209
Number of pages used 87877
Number of data pages 86743
Number of rows 2949120
…