October 2009

sysadmin task to monitor database growth

Motivated by Markus Holzbauer's sysadmin tasks I took database size script (for IDS >= v10) previously posted here by Eric in his "SMI Query Series" and wrote a simple sensor script, here it is:

Informix on Ubuntu

Here is some additional information about Informix@Ubuntu that I received from Andreas Breitfeld and Alexander Koerner from IBM Munich regarding the Informix Ubuntu packages:

The packages have been build for Ubuntu 8.04 LTS (Long Term Support) and are availabe on the Canoncial Partner repository. The installation could be performed from the command line or through the Synaptic GUI interface.

Command Line:
Activate the Canoncial repository by uncommenting the following to lines in /etc/apt/sources.list:

  • deb http://archive.canonical.com/ubuntu hardy partner

Nachlese zum 52. Informix-User-Group Workshop in HH

(german content)

Am Mittwoch, den 28.10.2009 fand der 52. Workshop der deutschen Informix User Group statt.

IDS Packages for Ubuntu Linux


About 8 months ago I switched from Suse Linux to Ubuntu on my notebook and wasn't able to find official IBM Informix packages for that platform.

Good news to all Ubuntu fans ! IBM has now officially released several Informix packages including Informix Dynamic Server (Developer Edition), Open Admin Tool, Client Software Developer Kit, PHP Data Objects.

You can find those packages here:

Webcast - MACH11 best practices around HDR/RSS


  • Date: Thursday, Nov the 18th
  • Time: 1.5 hour, 8:30 AM Pacific, 10:30 AM Central, 11:30 AM Eastern, 4:30 PM London, 5:30 PM Paris
  • Title: MACH11 best practices around HDR/RSS
  • Speaker: Madhuri, Madison Pruet (IBM)

You can register for the webcast here...

Jerry Keesee, Director of the Informix Lab will introduce the call 
and Madison Pruet, Informix STSM will be our technical speaker.

** WARNING ** A level 0 archive of Root DBSpace will need to be done.

Hi Spokey ,

While Creating the DBSPACES throuth the onspaces command iam getting the warning messages

** WARNING ** A level 0 archive of Root DBSpace will need to be done.

why this warning message appears and what we have to do for this ? If we are ignoring this warning messages is any issues will arise in future ?

onspaces -c -d testdbs -k 2kbytes -p /home/test/dbspace/chunk/testdbs -o 0kbytes -s 50000000kbytes

Verifying physical disk space, please wait...

Space successfully added.
** WARNING ** A level 0 archive of Root DBSpace will need to be done.

Thanks

IBM Database Magazine - New Issue

A new issue of the IBM Database Magazine has been released.

There are two Informix related articles included. One from IIUG president Stuart Litel and the other one from Informix veteran Lester Knutsen:

Newsletter Oktober 2009

(german content)

Neue Ausgabe des IBM/Informix Newsletters

Im Newsletter-Archiv befindet sich die neueste Ausgabe (10/2009) des INFORMIX-Newsletters.

Inhaltsverzeichnis der Ausgabe Oktober 2009:

  • Aktuelles
  • In eigener Sache: INFORMIX Newsletter feiert 3
  • Hinweis: Informix on Campus
  • TechTipp: IBM Optim - Enterprise Data Management
  • TechTipp: IBM Optim Datenanonymisierung am Beispiel INFORMIX
  • TechTipp: IBM Data Studio 2

Another bunch of new Informix blogs

A special thanks goes to Markus Holzbauer from IBM Munich who alerted me about two other new Informix related blogs:

They are now both listed on the right side of The Informix Zone as well as on the Informix URL Compilation page.

New Informix Blog: Informix DBA

A new blog is born !

Just discovered a new blog dedicated to Informix. The blog is called Informix DBA and it is owned by IIUG Board of Directors member Andrew Ford.

I've added the blog to the right side of The Informix Zone, so that all updates are immediately visible to the Informix community. Here is the direct URL of the blog: