RE: Number of the lock requests

Posted in 2000

Carlos Kobashikawa C. — Tue, 21 Nov 2000 11:44:58 -0500 — source: Informix-list mailing list archive (1991-1998)

You have indexes in your tables. For each record deleted, online places locks for the table and every index, Lock the table in exclusive mode, if you can. Otherwise, split your transaction. > -----Mensaje original----- > De: Rozsnyai, Andor (MED) [SMTP:Andor.Rozsnyai@med.ge.com] > Enviado el: Martes 21 de Noviembre de 2000 05:14 AM > Para: informix-list@iiug.org > Asunto: Number of the lock requests > > Hi, > > We have some joined tables in a simple line structure. > If I want to delete everything I have a message that no enough locks. > My problem is that I have 25000 items in all tables and 40000 locks. > > Could anyone explain me the relationship between the lock request and the > number of the records. > > Thank you, > > Andor Rozsnyai