OS = HPUX11
IDS = 9.21.FC4
The nightly backup (onbar -b -L 0) on one of our supported systems is taking
in excess of 3 hours to complete. This is due to the user having archived

Hi Informix Gurus,
I posted a simple question to oracle newsgroup but that place is very silent.
May be you can help me . Here is my question about oracle:
Hi Gurus,

We are currently running 7.31.UC3XE on an AIX 4.3.3 server.  One of
our goals is to be able to identify all connections/sql statements and
log them to a file for security monitoring.  I know that I can capture
a snapshot of this information from the sysmaster tables however this

here is my question. if you have a table called related_to
and it has these fields:
id
active

I've an application that stores a lot of data in my database-tables
(Informix DS 9.30). As there are some problems with the performance, I
analyze, among other things, the parameter seqscans (given by onstat -p) and
which tables causes them (script: "select tabname, seqscan, nrows ...

When inserting data into a table w_standard using  Informix Dynamic
Server 9.30.FC2 running on a Sun E3000 with Solaris 8 OS, the database
returns the following errors
    XIX000:-271:Could not insert new row into the table.

My server is running on a HPUX ver. 11, use KIO and have over 100
concurrent users. Normally it works well, but there are punctual
moments in that which  the system goes very loaded. I see the
processes oninit that consume many CPU. But I am not capable of

I want to get the no of days between 2 datetime fields.
Both fields are  of type DATETIME YEAR TO SECOND.
The following query executes and gives correct result in SQL editor,
but it gives an error from SPL as follows

I need to change my Primary Chunks to Mirrors and vice versa, to get my
primary chunks on faster disks. I can always archive, change device links
and restore. Is there an easier way? Thanks.

You mean the system forgets what it was doing and has to be reminded? I'm
impressed. I thought it was only humans that suffered Altzeimers.

We have a Dev server and Prod server. I am fetching big chunk of data
into a large temp table (say temp1). To process them I am fetching
them into another temp table (say temp2). The execution of code in Dev
server finishes in 2 hours. But the same execution takes invariably a

I've been trying to debug a problem with a constantly running
application that is
experiencing a performance degradation over time.  Today I set up a
script to

Greetings,
Apologies if this has been answered before.
Does Informix-SQL have functions such as Perl's 'split'.
We have a field which contains data delimited by "-" (dashes); the data

Does ontape rewind the Tape BEFORE archiving?
Is it possible to "ontape" to a Tape already written with "No rewind" option?

I want to add the modification date and time to some tables. To make it
easier I tried something like "... COLNAME datetime year to second DEFAULT
CURRENT year to second".
I tried to update and insert by using the DEFAULT keyword explicitely as it