I like to make a Diaster Recovery system,
and just wondering  which system I should choose:Informix HDR or
storage remote mirroring .
storage company told me that remote mirrroring can copy primary

Have few questions about long transactions. I have to alter table to
modify 2 columns to increase the width of those columns. This table
has around 50M rows. Will it get long transaction ? I already ran it
once but, it appears that there was a long transaction in between,

I am trying to find out if anybody has any experiences of using onbar in an
"emergency" situation.  Especially with an "imported" restore or a "rename
files" situation.
I would be interested in knowing what operating system, what versions of

Version: IDS 10
We have need to encrypt few columns of the database. One of the
options I looked at was encryption functions provided by informix.
But, when I asked some of the consultant they told us that Informix

I have a question regarding LTAPEDEV being set to /dev/null and
performance, and will not have a chance to test until tomorrow.
During a mass load process, will having LTAPEDEV set to /dev/null
increase performance significantly over having LTAPEDEV go to a disk

Folks:
I'd like to log some data about the current client session, and there
doesn't seem to be any direct way to do this using Informix-provided native
functions or variables (for example, something equivalent to HOST_NAME,

I'm having a tough time with my SQL statement when I try to join two
table.  One table has a field named doc_no and is numeric while the
other table has a field named record_key and is text.  When i write
"doc_no = record_key" and run the report, I get an error message about

Recently, we added logical logs because we were performing alters/
updates to big tables. But even after that we got long transaction.
When I look at onstat -l  it shows at least 216 logical logs having
flag U-- and A--. A-- I think means have never been used by informix.

does it work?

Running 10.00.UC3 -> 10.00.UC3 replication, both on RedHat EL 4
I set up a one-way replicate to transfer data and it works beautifully
(Go Informix)
but I forgot to set the frequency option in the replicate.

Does anyone know where I can get CSDK 2.90 TC6, as refererred to here:
http://publib.boulder.ibm.com/infocenter/idshelp/v10/index.jsp?topic=/com.ibm.do
cnotes.doc/uc6/infodbcdoc.html ?
The latest 2.90 for Windows I can find at www.informix.com is 2.90TC4.

Jonathan is of course correct, but I just wanted to make one slight adjustment.
For whatevere reasons, the powers that be decided that a PID would be marked with a W.
Thus the latest PID available for 10.00.FC6 is W5.
Product would be branded 10.00.FC6W5.

Is there a way to tell informix to use in-place algorithm for alter
table modify column. I have to modify column of table that has 50 M
rows. These columns are of type varchar. I think by default informix
is using slow algorithm

I'm using Informix 10.00.FC6 on HP/UX 11.11. Informix is installed,
configured, and one instance running. However, I'm having a problem
with onmonitor when I go to, say, change the tape drive. If I make a
change, and hit esc, I get this at the bottom of onmonitor:

I intend to use, record level manual locking on ISAM files.
my code will be somewhat like below
======================================================
fd_emp = isopen ("employee",ISINOUT+ISMANULOCK);