North of Huntington Beach in L.A.
Informix Database Administrator $80K - $100K   Will Relocate
Business and Data Modeling, Informix and MS SQL Server Stored
Procedures, Logical and Physical Design 2 - 4 years

I know that there's been talk of using SSDs, but there's an offshoot of ssds on PCI-e cards.
Was wondering if anyone has been playing with  IDS 10, or 11 using SSDs on the primary, then doing replication to a server with SAS drives and some more space.
I'm assuming that the OLTP db ...

IDS 10.0 for example, any O/S.
I've never understood why we have to an onmode -c block/onmode -c unblock
when taking a clone of Informix's data disks for back-up purposes.  To my
simple mind if Informix can fast recover from the original disks it should

 I have following function in my Informix database:
CREATE PROCEDURE climbertops(c varchar(128))
 RETURNING row
 DEFINE result row(mountain varchar(128),climber varchar(128),year

On May 26, 3:04 pm, loc <c320...@gmail.com> wrote:

  I want to know if replacing former NUMCPUVPS, AFF_SPROCS, and so on for VPCLASS in IDS 10 brings any advantage in terms of better performance or avoiding malfunction. Admin guide just says "you should" (p. 6-13) and warns against using both notations at once.
  Thanks in ...

While we're all high-fiving at how well IDS did in the VendorRate
assessment, has anyone looked at the last two vendors on page 4? :o)

   I catched a SP whichs take 10 seconds in perform. I checked that SQL on it was correctly written, used indexes, and so on (anyway, it's not a complex one, it uses a primary key and only returns one record), but I realized that central SQL takes almost all the time to execute. ...

All:
With the recent post "End of an era"
http://groups.google.com/group/comp.databases.informix/browse_thread/thread/9a83
7ede581746bd/0f7e2a1caa7f6024?show_docid=0f7e2a1caa7f6024
I'd like to hear your thought about the Informix certification program

http://obotheclown.blogspot.com/2009/07/informix-roundup-26-july-2009.html
The "slightly overdue" edition.

With Mark Townsend gone... (Don't know why he didn't just subscribe to the IIUG mailing list) I guess I can say this without someone complaining that I'm promoting Oracle on an Informix site. :-)
With the last two quarters, we can say good bye to an era of the IBM Informix pundits ...

All:
I have researched how to configure the dbaccess environment and have
not found anything on this topic. My goal is to configure the
dbaccess  environment to accept the "Backspace" as designed instead of

I'm working on a 4GL program to enter AP vendors into a database and
I'm wondering how the vendor numbers should be assigned.  Should they
be assigned sequentially or should they be assigned so that when
selecting the data and ordering by vendor number the vendor name would

our php developers claim they need DRDA support to connect to IDS 11.50.
Development platform is the Zend framework. The databases classes would use
pdo_ibm instead of pdo_informix.
- Is this information correct? Do we need pdo_ibm and DRDA support if we

  We have just migrated an instance from 9.40 FC6 to IDS 10 FC8 on an Solaris9 - sparc server.
  Prior to this, we had a lot of problems with long checkpoints which finally could solve. But suddenly, after migrations, long checkpoints got back. Nothing changed, neither data, ...