DB Dummy|Sharing Experience on Oracle & Informix Databases …

Home|rss|OUR STRENGTH

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
…

Posted by helloworld in Database General, Informix Database
No Comments Read more
Search :
  • Recent Posts

    • Intercepting your record with triggles
    • How to check from Informix server if connections came from shared memory
    • Informix Archecker – point in time restore/recover table (Scenario 2)
    • Undefined subroutine &main::read_file called at crspatch.pm line 86. while running ./rootcrs.pl
    • HAIP is up on some nodes but not on all RAC nodes
  • Sponsors

  • Categories

    • Database General
    • Informix Database
    • Operating System
    • Oracle Database
    • Raspberry Pi
    • Ubuntu
    • UNIX / Linux
    • Utilities
  • Archives

    • October 2014
    • September 2014
    • August 2014
    • July 2014
    • June 2014
    • February 2014
    • January 2014
    • December 2013
    • October 2013
    • September 2013
    • June 2013
    • February 2013
    • November 2011
    • October 2011
    • March 2011
    • January 2011
    • September 2010
    • August 2010
    • July 2010
    • June 2010
    • May 2010
  • Meta

    • Log in
© All Rights Reserved. DB Dummy