Discover Informix - The data server with the most flexible cluster and replication technology on the market and the lowest TCO

akagel's picture

New features in Informix 12.10.xC9

I am stoked! HCL has released the first update to Informix Dynamic Server developed under their auspices. There are two significant new features in the .xC9 release, one is an enhancement to how time series and spatial data work together that adds significant performance and utility to that feature and the other is a completely new feature that users have been asking for for years. I will cover them in order:

eherber's picture

Informix Newsletter Q3 2017

(german content)

Neue Ausgabe des IBM/Informix Newsletters

Im Newsletter-Archiv befindet sich die neueste Ausgabe des INFORMIX-Newsletters.

Inhaltsverzeichnis der Ausgabe:

jfilippi's picture

Customize Saving SQLTRACE Data - Long running SQL's

​Here is a way to save SQLTRACE information, but to only save SQL statement that run greater than "X" number of seconds.

This way you can look at your slowest SQL to look at tuning it.

​You will be implementing a task in the SYSADMIN database and creating the table in that database also.

Passwords encrypted over the network: why is this feature not enabled by default?

In 2015 I wrote a blog post about using simple password encryption (SPW) and how – without it – your valuable passwords can be trivially sniffed on your network. If you look through the post it illustrates the vulnerability and shows just how easy it is to set your system up in a more secure way.

SPW only encrypts your password when you connect. Not everyone wants or needs full encryption of all their traffic but what reasons are there not to use SPW?

fnunes's picture

Informix Community (new site) / Comunidade Informix (novo site)

A new site dedicated to Informix Community was created. (original version can be seen here: http://informix-technology.blogspot.com/2017/06/informix-community-new-site-comunidade.html)

English version

When do my stored procedure execution plans get updated?

For the sake of brevity in this article I am going to group procedures, functions and routines together as stored procedures and ignore any differences between them.

What does the SQL command UPDATE STATISTICS FOR PROCEDURE/FUNCTION/ROUTINE does and perhaps, more pertinently, as a DBA do I need to run this regularly to ensure my systems are working efficiently? For those wanting an immediate answer I think it is “never” or “almost never“, the reasons for which I hope to explain clearly in this article.

eherber's picture

Informix Newsletter Q2 (Juni) 2017

(german content)

Neue Ausgabe des IBM/Informix Newsletters

Im Newsletter-Archiv befindet sich die neueste Ausgabe des INFORMIX-Newsletters.

Inhaltsverzeichnis der Ausgabe:

akagel's picture

A new era for Informix begins now!

I returned from last week's International Informix Users Group Conference with some news. What kind of news it is I am not 100% certain.
fnunes's picture

IBM and HCL partnership around Informix / Parceria IBM e HCL em torno do Informix

IBM and HCL entering a strategic partnership to jointly develop and market the IBM Informix family of products  (original version here: http://informix-technology.blogspot.com/2017/04/ibm-and-hcl-partnership-around-informix.html)

English version

Improving remote query performance by tuning FET_BUF_SIZE

I thought I’d write blog post as a nice example of where tuning the client-side variable, FET_BUF_SIZE, really speeded up a remote query.

FET_BUF_SIZE is documented by IBM in the context of a Java application using JDBC here and as a server environment variable here.