January 23 2014

Informix – Compress data rows in a table

Tagged Under : , , ,

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

January 12 2014

Ubuntu – How to install InstanceBird in Linux (x86)

Tagged Under : , ,

I can’t find any official repository to install InstanceBird with “apg-get install” in ubuntu. There is a manual way to install InstanceBird 1.4 (32-bit) in x86 base Linux like Ubuntu, Debian, Centos, Fedora and etc .. Please download the pre-compiled binary as below:

To install:

$ cd /tmp
$ wget -c www.instantbird.com/downloads/1.4/instantbird-1.4.en-US.linux-i686.tar.bz2
$ sudo mv instantbird /opt/instantbird
$ sudo chmod -R 755 /opt/instantbird
$ sudo chown -R : /opt/instantbird
$ wget -c http://dl.dropbox.com/u/964512/misc/instantbird.desktop
$ sudo mv instantbird.desktop /usr/share/applications/instantbird.desktop

Then, launch instancebird 🙂

$ /opt/instantbird/instantbird &

To uninstall or remove InstanceBird, just remove the whole dir of instancebird:

$ sudo rm -rf /opt/instantbird
$ sudo rm /usr/share/applications/instantbird.desktop