Hello. I was thinking I would like to try Art's dostats tool but we
are a 4gl shop and do not use ESQL and I would have not idea how to
compile the version he has placed out on IIUG. I am running IDS
9.40.FC2 on AIX 5.2 if that matter at all.

is there any way to get the timestamp of the last
archive from any [system] table?
I know about oncheck -pr.
TIA,

I know Informix 5 SE is OLD but it is our platform for the forseeable
future. I have just massively increased the throughput of our SCO server
running this by way of adjucting the NBUF and NHBUF parameters in the
kernel. Are there any Informix specific parameters I can play with to ...

Davorin Kremenjas wrote

I searched old posts for a possible solution to the problem I have but
without success.
The summary is this: is there a possibility to continously restore
transactions commited on one Informix instance to another?

I have a question regarding IDS 9.4.
Using our current 7.31 we have 2 gig chunks for the db. Now we plan to move
to
9.4. How can we migrate the system from 2 gig to 8 gig chunks, convert and

I am running Informix 7.31, CSDK 2.81.TC3, (IIS 5.0, IE6) and I am
trying to assign the value of a Recordset field to an array element
with this code...
aRs_PSPA[cnt][3] = oRs2.Fields("spa_desc").Value;

Overview :
-------------
We have an Informix database (SE) installed for storing test cases.
But in the recent times we are experiencing a strange behaviour while

While reorganizing data in the database, we apply individual user
permissions per person, per table to provide database security.  The issue
we have is anytime we drop and re-create the database, we have to apply
all of the grants,  in a recent restore it took 36 hours to apply the

It looks like the native SQL Editor for Informix
has been discontinued.
Can anybody recommend another (possibly native)
SQL Editor for Informix?  Would I have to resort

One more thing (so far!) I noticed that while my cached read improved,
my cached writes is down about 4-5%. Any thoughts on this guys? We do
a lot of datamining and we are constantly loading flat files into our
production database, so any kind of write is always a worry for me!

    I know I am asking a very strnage question, But still need u'r help.
I am working on improving the performance of the 4gl module. When we compile
a 4gl it generates -> .ec -> .c -> .o , Now my question is can I modify the
.c which is generated and compiling the file?  

When attempting a manual commit, I receive a "Driver not capable" error
message.
Is it possible to use manual transactions with Informix v9.4 and ODBC
driver v3.82 ?  I tried the ODBC advanced setup option "Auto commit

Hello all. I read an interesting article on an IBM website about
evaluating the uniqueness of indexed columns. One part that was not
clear to me was how a composite indexes columns should be ordered on
creation and how that effects the uniqueness measurement. For example,

Can this syntax create view with union all work on SE?
THanks
FRancis
sending to informix-list