Technical Articles

The Technical Articles section provides a wide variety of detailed technical content covering a wide area of material which has been written by our technical team members.


IDS 11+ sysadmin:alertcleanup function bug fix


This article describes a bug in a function provided with IBM Informix Dynamic Server (IDS) which could result in disk space being filled. We have reported this to IBM who have assigned defect number (APAR) IT09329. Meanwhile, you can fix your system using code provided below.

Little known IDS commands: onsecurity


Continuing the series of seldom used commands lurking in the bin directory of your Informix installation directory, today we’re looking at onsecurity.

It is very important to keep your database server and associated files secure; as well as keeping your data safe, later versions of IDS will refuse to start should the base ownership and permissions be too insecure. If your installation has been moved or copied, or other files or directories been added over time, IDS may not be running in the most secure environment.

Automatic management of range interval tables


If for instance you wish to keep just a week’s worth of transactions, in order to save disk space perhaps, then it is quite straightforward to use a range interval fragmented table, and whenever you wish you can almost instantly purge any unwanted data by using the DROP or DETACH clause in the ALTER FRAGMENT statement. In any release prior to v12.10 this would have to done manually, as it were (albeit via a cron job perhaps), but now it can be managed entirely by the instance with the ‘rolling window’ functionality, as described in this article.

Little known IDS commands: onclean


In this series of articles we are exploring some of the lesser known, but still useful, commands hidden away in your Informix bin directory. The article explores the onclean utility.

MS-SQL DB2 Linked Server



Microsoft SQL Server is a popular choice for consolidation of report data from multiple database products, as its Linked Server feature - which is included in the base product - makes it possible to access tables in heterogeneous databases within T-SQL via OLE DB.

However, there are some settings required to make this work seamlessly, which are described in this article as they are not that obvious.