OS : Sun Solaris 2.7
IDS : 7.31.UD5
Recently my database engine was crashed due to the
index corruption. The engine was back up after

Does someone know an easy mean which permit me to rename a dbspace
contening just a separated index ?
Thanks in advance.
Best Regards

It seems even in Informix 9.4 we can not use order by clause
in a view
create view viewname
as select a,b

I would like to develop a process which can determine if there were temp
tables created during my current database connection.  I am the system
architect for a very large application which establishes a database
connection at user startup, and that connection persists while the user

Great Explanation Art,
What if we add to this scenario KAIO?
Would it be a very serious risk
of getting data corruption or even lost data ?

This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C36D67.E91BD400
Content-Type: text/plain;

Ruediger
Yes, this is something I have tried to achieve, it tends to reduce disk I/O
to the Physical Log and make the I/O more efficient. I'm currently running a
PHYSBUFF of 512 (just so you don't get afraid of big numbers!). The same can

Well, another one ! :)
Yes, once again a little question for the newsgroup !
So i begin my explanation :
with ESQL/C

IDS 9.21 FC4 on HP-UX 11.11
Can anyone explain to me how ALTER FRAGMENT ... INIT IN DBSPACE actually
does its stuff?
I've a 32GByte table which I want to reorgainse, to get all the free space

What happens when you go over the permitted number of users for you user
license?
IDS9.21.HC4
HPUX11.0

After installing an other application on my production box. I receive the
following error when I try to connect to my tcpip server interface :
908 : Attempt to connect to database server <databaseServerName> failed
No record locks available

I always get an error " virtual column must have explicit name"
I wrote a query to execute and store result in another table..I query  does
sum operation on fields with related keys....

Which versions of Redhat Linux are compatible with Redback 4.1.3.2?

I was killing an ontape process and picked up the incorrect process id (
parent id ). I ended up killing an informix process. Now when I try to bring
up informix i get the following error ...
22:13:59  Loading Module <BUILTINNULL>

Hi Bill,
Allocating lot of shared memory segment is normal.
It depends on the load that you are trying to do.
Few questions:-