Re: Informix Locking Problem

In article <36tmu4$nqa@hk.super.net>, gmwkc@hk.super.net (Mr Cheung Chi Kong Dannis) says: > >I got the problem on informix locking >I am using Informix online 5.01 version. > >When I modify the record, it will lock current modified record and >previous one also. It look abnormal. > >I have change the lock into row lock. > >Is there any suggest on my problem. >In advance, thank you for your help Yes, the problem is identified as the Twin Locking problem for OnLine v.5.x. This is resolved in OnLine v.6.0. If you want a detailed explanation of the problem, I have forwarded the information and Technical Information from Informix to Kerry Sainsbury (he really is insane! - just kidding) for the next version of the Informix FAQ. This is an excellent document and a MUST READ!! Albert E. Whale aewhale@telerama.lm.com ---------------------------------------------------- Sr. Systems/Database Consultant Executive's Monitor, Inc. 1789 S. Braddock Ave, Ste 220 Pittsburgh, PA 15218-1868 (412)243-4600 Fax: (412)243-4830