Does these parameters help in logical log recovery. I was wondering if
increasing ON_RECVRY_THREADS help in HDR on secondary server.

Version: IDS 10
I am having some difficulties understanding few things such as:
1. I know what indexes to fragment but it's creating data skew, which
then makes it difficult to compute the size of dbspace. So I thought

I'm trying to do some basic stuff in a C UDR.  Following the docs,
mi_get_database_info takes a MI_CONNECTION* and a MI_DATABASE_INFO*.
However, the following causes Informix to give me "7520: Argument (2)
is NULL", which means a NULL was sent and Informix didn't expect it:

Informix Ver 9.40.FC4
HP-UX 11.11
We have a 350Gb database running baan. The customer has added a number
of new baan companies placed in new dbspaces for testing purposes.

If I specify an IP address in my connection string, after the
connection is made setnet32 has been changed to use that hostname
instead of the default.
Is this is what's intended?

I need to deploy an application to the field at my company that uses a
database on a new server.  I would like to be able to add the new
server and host's information to setnet during the install without
having to manually update each PC.

I've a customer who's looking to extend his use of IDS, but wants to do a
short eval of IDS Enterprise.  The IDS trial at
http://www14.software.ibm.com/webapp/download/search.jsp?go=y&rs=ifxids
looks ideal but lacks info.

All:
I'm seeing bazillions of these errors on some tables when I run oncheck -cD:
WARNING: data page 0xe495 in tablespace 0x4f00002 appears to be
         more or less full than is indicated in the bitmap.

I have one problem with informix database recently.My client operation
system is Windows2003,server operation system is UNIX.The version of
Informix is 09.40.0000 FC8.I try to connect server's informix database
with WINSQL.But I have one problem that the connection interrupt

AIX 5.3 IDS 9.40.FC5
How can this be re-written to eliminate the subquery?
I can't seem to get MAX to work with the outer join on ()
 select x0.setid ,x0.cust_id ,x0.name1 ,x0.roleuser ,

Could somebody tell me their experiences about HDR. I am reading about
HDR to see where we can improve. We ran our tests and the performance
was less than .5 of what we generally get. Do things like log file
size make difference ? Would increasing memory help ? We have huge

Version: IDS 10
How to configure Informix to run HDR threads on dedicated link to
secondary server ? As I understand we'll have IP address for this new
Interface Card, but how do we tell informix to send/receive logs over

I'm absolutely new to Informix and ODBC. I need to access a few
informix tables (idx+dat) that a customer gave me.
I tried to use ODBC driver (IBM CSDK) in WinXP but I don't know how to
configure it (server name, port number, ecc) in control panel. I need

I have a favor to ask of this group.  I really hate asking this but I
need some help.
I'm up for a promotion and one of the things that I'm being pressured to
come up with is a bunch of recommendations from the Informix Customers.

Is there any command in Informix that is equivalent to "SET ROWCOUNT"
of Sybase/MS Sql Server ?
Basically I am trying to update a column in a huge table (50 million
rows) without a WHERE clause (need to set a flag in all the rows).