Informix 10
Solaris 10
We have recently started using HDR, and are planning a test.  The test
will be to simulate a failure of the primary by doing an onmode -k.

how do I know which index is used on a table when the program execute?
I want to do a clean up of unused indexes and tables.
Thanks.
(informix 7.31)

I think Informix SQL  doesn't have CTE feature.
Is there any  work-around for it ?
Thanks
Murty

Does anyone know if it is possible to disable the automatic statistics
collection portion of the create index in ids 11.1?
I don't see anything in the docs but I'm hoping for an undocumented onconfig
or env variable.

Anyone have any experience with using the Compellent Sans with IDS?
The database engine is running on a RH 2.6.9-42.0.8.ELhugemem.  We
have not seen great performance and don't know if it our setup or if
there is any special configuration that we should set up.

Hello Y'all,
IDS 10.00.UC5 - Red Hat EL 3
I'm looking at my onstat -g iov output and see that the micellaneous vp is doing work, I'm not used to seeing this.
IBM Informix Dynamic Server Version 10.00.UC5     -- On-Line (Prim) -- Up 1 days 06:51:31 -- 1125252 Kbytes

Hi everyone. We have the following:
IDS 10.00.FC5
Linux Red Hat Kernel 2.6.9-42 on an x86_64
Tape Params:

Is there a way to tell what session is using the tmp dbspaces ?
Thanks,
floyd

We had a system that used STORED PROCEDURES(Launched via an ODBC
connection) to execute 4GL programs that generate TXT files (data
delimited with "|") that were loaded then into another program.
We have migrated to the new INFORMIX 11.50 and when we try to run the

Has someone had any experience with Informix monitoring tool NimBUS ? Thank
you for sharing it.
Olmedo Monteverde

In my work I have Informix 10 + HDR and some tables with more than 40 millonres records.
These tables have more than 50 extents by recreating what I need to resize the extents and reduce the number of extents.
Recalling that I have Informix + HDR my question is as follows...  ...

I have problem with replacing non-printable 'new line' sign (^J) to
null. Actually, I don't know if Informix provides function like
Oracle's ord() or ascii() which would be helpful.
My task is to unload rows from sql query into file with default

IDS 9.40.FC5 on Solaris 9.  We migrated from a db server with 8 cpus to
one with 4 dual core cpus - 4-SMP Core CPUs 1.35 GHz.  Is this actually
the equivalent of having 8 processors?   I'm tuning as if they are the
same and performance is not bad but occassionally cpu is maxed out.

how do I know which index is used on a table when the program execute?
I want to do a clean up of unused indexes and tables.
Thanks.
(informix 7.31)

Am using version 10.00.UC7X1 and have a few *basic* questions on the
usage of the logical log file.
The database has a logging mode of unbuffered logging with a page size
is 2048 bytes (as returned by onstat -b). I have 3 log files with each