Skip to Content

planetIDS (via FeedRinse)

Syndicate content
Discover Informix - The data server with the most flexible cluster and replication technology on the market and the lowest TCO
Updated: 1 hour 33 min ago

Customize Saving SQLTRACE Data - Long running SQL's

Thu, 2017-07-20 23:15

?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.

read more

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

Mon, 2017-06-26 14:16

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?

read more

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

Sun, 2017-06-25 16:12

A new site dedicated to Informix Community was created. (original version can be seen here:

English version

read more

When do my stored procedure execution plans get updated?

Fri, 2017-06-23 19:02

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.

read more

Informix Newsletter Q2 (Juni) 2017

Fri, 2017-06-09 13:50

(german content)

Neue Ausgabe des IBM/Informix Newsletters

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

Inhaltsverzeichnis der Ausgabe:

read more

A new era for Informix begins now!

Wed, 2017-05-03 19:52
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.

read more