Re: Upgrade of locks

Posted in 2000

Vinod Bhansali — Wed, 31 May 2000 21:08:34 GMT — source: Informix-list mailing list archive (1991-1998)

Informix doesnot escalate(promote) locks. Vinod Bhansali >From: Henry Benoit <Benoit.Henry@Galvalange.lu> >To: informix-list@iiug.org >Subject: Upgrade of locks >Date: Wed, 31 May 2000 12:00:04 +0200 > > >Hello, > > >I've got a question about upgrade of locks. >Can informix upgrade a lock and promote at a higher level. > >For example : I have a table with 200,000 records and i do >an update for the entire table. The lock mode is row. >Can Informix detect that the process is locking about 100,000 rows >and react and say "ok guy, you already locked 100,000 record, > I'll give you a lock on the entire table, so I can release 99,999 locks >!" > >Thanks in advance > >Ben > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com