I am working with a client using IDS 10 over HP with ~4TB of data. In
prep for their peak season, we've been "gutting" both the hardware
(moving to Veritas Clustering and related items) and the engine layout
over the last year. Early testing looks great with regards to

Does anyone know which table in sysmaster or some other easy way to get the number of seconds an instance has been up ?
The onstat commands give you the answer in number of days plus hours etc...
I'd like to find a table where that data exists, and then I can do a datetime function ...

I would like to be able to default all database to create with logging
enabled (unbuffered).
We have a number of historical scripts with "CREATE DATABASE bob IN
data01;" in them, and we now need these to be logged when created.

IDS10 on AIX 5.3.
Sorry if this has been asked before, but I still don't have a satisfactory answer.
We are trying to determine exactly how much percentage of our system cpu, that Informix is using through time.
This is proving to be a difficult task, because sar doesn't provide ...

Has anyone experience with running Informix on vmware or other
virtualization solutions ?
What pitfalls are there to be aware of when running your database on a
virtualized infrastructure ?

Please help me or my boss will kill me :(
What do we have:
HP-UX 11.11 (PA-RISC)
Informix IDS 9.3 FC6 with ~4TB database

sorry i am a new babie in INFORMIX sql
can i ask you guys help me to convert this?
select MyLocationStatus as If([state= "V", "valid", If([state= "I", "Invalid",
If([state not in ("V","I", ""NULL"))) from location;

I want to know
- How to measure/estimate the Network Bandwidth for a HDR pair
 over a WAN ?
- What will happen to the performance of the Primary server if

Has anyone experimented with DBTEMP spaces in a Solaris tmpfs filesystem
and has this helped boost performance for sorts/merges ?

I need to see what disk informix uses and how is it memory usage..
df -k dont list because are Raw devices, so how can i see it?
tks

When using dbaccess from the command line to run a query, is there any
way to tell it to omit column headers?
Also, is there any way to only return data and trim out blank lines?

Plan to buy a book on informix sql programming
so that i can learn not just the synatx, but the cursor, store procedure....
etc
any suggestion.

Try the following:
create table test(id serial, dd INTERVAL DAY(9) TO DAY);
insert into test values(0, INTERVAL(99) DAY TO DAY);
insert into test values(0, INTERVAL(100) DAY TO DAY); -- this one

http://money.cnn.com/news/newsfeeds/articles/marketwire/0378885.htm
To cut to the chase....
IBM is now an investor in to Postgress.
If Informix is the bastard step child what do you make of this?

We have all heard the stories and rumors about on LUW aka 'distributed' in IBM parlance, where IDS is outselling DB2.
We have all heard and read statements that IBM's SWG IM executive management is standing behind IDS.
We have all heard that IBM is positioning IDS as their ...