Lock mechanism of Informix

Hi My name is Pedro Carvalho and I am a member of a software house in Portugal. I would like to know someone on the net who works with Informix to discuss the lock mechanism of this DBMS. The Informix DBMS is the only DBMS I know (I also work with Oracle, Ingres and RDB) that locks three contiguous records when we try to update a single record. The situation I have is this : - I choose row level locking - There are several users accessing the database at the same time - In particular, there are two people accessing two records for update , let's say, record 1 and record 2 with contiguous keys. What is expected to happen is that these 2 people could do the update operation at the same time, but what really happens is that one of them has to wait until the other completes her work because Informix locks three records (the record who is being updated and the two contiguous records). I spoke with the company which represents Informix Corporation in Portugal but they didn't solve my problem. I would like to know if this is a common situation to other programmers and if not what can I do to solve this problem. Thanks in Advance Pedro Carvalho Novabase Lisbon, Portugal +-------------------------------------+-----------------------------+ | | | | Carlos M.M. de Carvalho | Address: | | Systems Administration Department | Av. Rovisco Pais-22-R/C | | | 1000 LISBOA | | __ | PORTUGAL | | /. \\__ | | | \\__/. \\ novabase | Phone: (351-1)-8475657 | | /. \\__/ sistemas de informacao | Fax: (351-1)-8478553 | | \\__/ e bases de dados SA | E-Mail: cmc@novabase.pt | | | AppleLink: PORTNOVABASE | +-------------------------------------+-----------------------------+ | | ALL I NEED IS A MAC | +-------------------------------------+-----------------------------+