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.

 


Automatic management of range interval tables

Abstract

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

Abstract

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

 

Abstract

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.


How to Setup DB2 10.5 PureScale in VMware

Abstract

This article aims to detail the process to create a 4 node PureScale environment for the purposes of exploring, learning and testing to explore the technology.


MS-SQL Informix Linked Server

Abstract

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 unlike Informix Enterprise Gateway Manager - 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.


Pages