December 2009

Merry Christmas and a Happy New Year !

Dear Informix Community,

I wish you and your families Merry Christmas and All The Best for the new decade.

sysadmin task: dbspace full alert

Another sysadmin task to alert if dbspace(s) fill up. The thresholds are configurable (yellow/red logic) and there's an option of exclusion list (although a bit awkwardly coded, all suggestions for improvement welcome).


{ dbspace full alarm }

delete from ph_threshold where task_name = "Dbspace full alarm";
insert into ph_threshold values (0, "DBSPACE_PCT_FULL_RED", "Dbspace full alarm", 90, "NUMERIC", "Dbspace percentage full alarm - red");

Newsletter Dezember 2009

(german content)

Neue Ausgabe des IBM/Informix Newsletters

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

Inhaltsverzeichnis der Ausgabe Dezember 2009:

  • Aktuelles
  • TechTipp: Environments - Profile
  • TechTipp: Environments - ENVCHECK
  • TechTipp: Environments - ENVIGNORE
  • TechTipp: SMI - Sysmaster Interface - sysfeatures
  • TechTipp: Die Funktion 'format_units'

IBM Informix is Vendor of the Year 2009

I won't call it a Wake-Up Call this time as the IBM Press Department has proved to be in hibernation regarding Informix related issues throughout the year. So we don't want to disturb them in their well-deserved quietness :-)

However there is excellent news: IBM Informix has achieved the Vendor of the Year 2009 award by VendorRate:

Informix, the IBM database product family, repeated as
Vendor of the Year for 2009. Since their initial appearance in

ODBC Connectivity Error from Informix DB to Dotnet

Hi Spokey,

We have an issue while making an ODBC from IDS to Dotnet

IDS11.5 Installed in SLES10.2 BOX and Dotnet 2005 in windows

We are using the Client CSDK3.5

we are getting the error when connecting to Dotnet from windows machine

ERROR [HY000] [Informix .NET provider][Informix]System error occurred in network function.

When we try the ODBC the same error

[Informix][Informix ODBC Driver][Informix]System error occurred in network function

some of the connection setting we are using in windows

Servename - live
hostname - 192.168.1.196

IIUG Conference 2010 - Registration is now open

From the IIUG Conference Planning Committee:

Join us on April 25th - 28th, 2010, for the largest gathering of Informix 
users, developers and all around enthusiasts. This is the best opportunity 
on earth for Informix training, presentations and insights with access to 
consultants, experts and IBM Informix management and executives. It is 
organized by Informix users for Informix users so the costs are low and 
the benefits are great.

Brand New IBM Redbook: Data Warehousing with IDS

IBM has published a brand new Redbook about Data Warehousing with Informix Dynamic Server:

Deutsche Informix User Group goes Web 2.0

(german content)

Die Deutsche IUG möchte sich in 2010 noch stärker für die Belange ihrer zahlreichen Informix-Mitglieder gegenüber IBM einsetzen und darüber hinaus mit interessanten Stammtischen und Workshops ihren Mitgliedern einen echten Mehrwert liefern.

Presentations from Informix UK Event

InformixCity now offers the presentations from the UK Informix Community Event 2009 in the download area of their website.

The presentations include valuable technical information as well as an update on the IBM Informix strategy:

Konkan Railway uses IDS to improve operations and reduce energy costs

The Konkan Railway chose IBM's Informix Dynamic Server to improve its 
services and cut down on redundant manual procedures so as to improve 
operating efficiency.

"With the Railway Application Package system running on IBM software, Konkan 
Railway has significantly improved its ability to analyse, maintain and 
present data, helping to reduce the likelihood of passenger delays and 
cultivating better decision-making. Additionally, by automating the 
light-switching at stations with train arrival-departures, the system