Re: PLEASE HELP --- Informix SE and Uniface 6 --- PLEASE HELP

Richard Percival wrote: > We have just embarked on a project with a third party supplier which > will implement a system using Uniface 6 (the supplier is providing > this). We want to continue using our existing RDBMS which is > Informix SE 7.24 running on HP/UX10.2 > > The supplier is now saying that Informix SE cannot be used because it > locks at the table level. That is not my understanding of Informix > locking - I thought it supported row level locking. Could someone > confirm this? SE supports row locking, and always has. There may be other reasons why they can't use SE, but the real reason is *not* that SE does not support row-level locking. > Is there a problem with Informix 7 and Uniface 6? Could it be > something to do with the way these two products interact? Dunno. > Or, could it be because the suppliers two 'preferred' databases are > Oracle and SQL server. Could it be that the SQL is slightly different > for those and for whatever reason that means that Informix attempts > table level locks? This could be part of the trouble. One possibility may be that SE does not provide the isolation levels which OnLine does (and Oracle and SQL Server do), and they feel that they have to use table locking to achieve the isolation -- at a severe cost in concurrency, of course. I think you need to get them (your 3rd Party and/or Uniface) to explain in much more detail what the problem is, rather than simply letting them assert that SE is the trouble. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix -- see http://www.perl.com/CPAN #include <disclaimer.h>