we have recently deployed a .NET Service application to a client, which
connects to an Informix database at polling intervals of 5 seconds
During the course of integration testing the client is consistently
getting the following memory allocation error:

I'm experiencing Informix behaviour that feels weird to me.
Sometimes, let's say once a week on average, read cache rate drops suddenly.
Most of the time read cache rate is very high, around 99.7 percent. And all
of the sudden it drops to somewhere around 50%.

A colleague set up replication (across a WAN) years ago
using Informix IDS 7.3.1, and complained about the performance.
Since then they've upgraded to IDS 9.3.1, but are reluctant
to try replication again.

Actually this is a esqlc problem and may be because we are trying to use
gcc instead of cc_r
I receive
gcc: '-b' must come at the start of the command line

Hi, I need to know good practices about Informix maintenance (backup,
statistics, integrity,...), I´ll be gracefull if you can help me.
Thanks, sorry my english

if you are interested :
http://www.ibm.com/servers/eserver/zseries/library/techpapers/pdf/gm130667.pdf
(There's a part where they tested raw devices vs. file system files as
well.

he guys.
The ISA archive for AIX (1.50UC1) does not come with the JRE. For some
reason the installation does not see the installed version 1.41 as
valid.

? What is the status of some of the suggestions that were made at the
2004 IBM Tech Conference (Birds of Feather) such as:
    1.  Create a catalog table to hold "explain" information.
        Whenever an "explain" command is executed, the access

As it's a slow news day I'll ask about migrations.
I'm testing migrating from 7.31 to 9.40, the upgrade works fines and takes
around 5 mins to convert everything. The migration plan says to run onchecks
(-cc, -cD, -cI, -cc, -ce) before and after. As these take quite some time to

We have informix database in tru64 unix  that has shared memory and tcp
connection(onipcshm, onsoctcp) .
10 connection through shm takes 20 seconds.
10 connection through tcp takes less than 5 seconds.

Greetings All,
I'm currently in the process of migrating to a new box.  Physical mem is 16
gig on the server.  I'm able to bring the instance online using "BUFFERS
4096000" with "SHMVIRTSIZE 2048000".  However, I would like to add another

Is this list very quiet, or is it just me ?
Dirk Moolman
Database and Unix Administrator
MxO Information Systems (HealthCorp)

I would like to know how to migrate a informix databas to Mysql.
I wish to know if someone knows any way to do this.
I don't want to use a commercial solution.
Thanx.

Hi Informixers,
is it possible for a Visual Basic application connecting to IDS
via OLEDB to somehow get its own session id for the active connection?
If so, how do I do this?

I am trying to insert rows into two joined tables using
dbinfo('sqlca.sqlerrd1') in a loop.
Here is the SQL I'm using:
CREATE PROCEDURE insert_offers