Curious -
Two questions -
1) How many of your ifmx engines are at 500 transactions per second or
greater?

Good day.
Product Name and Version: IBM Informix Dynamic Server Version
10.00.TC7
Operating System and Version: Windows

I created a new sblob space and created a table with a clob column and specified that it use the new sblob space. But it still puts everything in the default sblob space.
create table newtable{
id serial8,
notes clob

Has anyone heard of a Data Warehousing product called GoldenGate for
Real-Time data Warehousing?
I have a potential IDS customer who uses it for an Oracle-based data
warehouse: one of their criteria is whether the chosen database integrates

is there anybody who installed an SDS instance on IDS 11.xx. Maybe you
can tell me where I can RTFM? Is theI have there anything I have to
take into consideration when creating my raw devices?
TIA

Version: IDS 10
I am trying to write a script that will find out those threads or
sessions that are stuck at particular step for more than x mts. It
could be stuck to acquire a lock on a resouce, or waiting for buffer

timestamp is a datetime year to second field.  I need to specify a
time like 6/7/2007 7:42:34am.  How can I accomplish this?
The closest I've been able to get is
select * from calls where timestamp > date("06/07/2007")

Is anyone aware of any documentation, beyond the release notes, on just
exactly what the ALICE mode for BTSCANNERS is/does?  I know it stands
for Adaptive Linear Index Cleaning Engine, or something similar, but not
much beyond that.  Is there any good documentation out there?

I'm new to managing a group using IDS, and am familiar with other RDMS
platforms, but just not up to speed yet on this particular one.
We have a two-fold problem getting data out for use in a reporting/
data warehouse from our OLTP environment.  The issue is that we do not

Hi Informixers,
I'm just implementing our new database server running IDS 10.00.UC6 under
Linux (SLES 10 SP1). On our old system, we used NIS for user administration,
which worked just fine without any special configuration for Informix. The NIS

Is there any potential (security)risk to loading data with dbload?
example :
unchecked delimited text input -> dbload command file
command file simply

I have Zend Core for IBM installed on a Red Hat Enterprise 5.
I’m trying to connect to an IDS 10 on another server. I’ve been trying for 2
days now, and nothing works… anyone have experience with the same setup and
got it to work?

Version IDS 10:
Why is it that in sysptnhdr NPTOTAL is much higher for indexes as
compared to NPUSED. What does it really mean ?
- Is it because of Fill Factor

can informix call/invoke an application - or a java application - and
have it fire it off?
Thanks,
Tom

Hi i get this error:
Unspecified System Error =  -21005. (State:S1000, Native Code: 520D)
on this query:
SELECT  ADJ_COD, ADJ_SOL_COD, ADJ_PRY_COD, ADJ_FAS_COD, ADJ_ENT_COD,