Re: ovlock=56

ogolde@impsat1.com.ar (Oscar Goldes) wrote: >Hello, >running onstat on Informix Online 7.2 I noticed the value >ovlock=56 >after two days up. >Is this value acceptable? Or should it be 0? It is best to prevent lock overflow from occurring during normal processing. >The value of LOCKS is 60000 >What happens when a process needs a lock and there are no more available? I suggest bumping locks up to at least 200000. It takes a little more memory but not much. If you keep getting lock overflow (ovlock > 0) and still have available memory, then make it larger. If a there are no more locks available you will get a lock overflow and something will usually get rolled back. If you are doing a large update or insert to a table, I would lock the table first. >I have also found >lockwaits=245 >Does this refer to the number of times a process had to wait for a locked >resource, or the number of times it had to wait for an available lock? I believe this indicates the number of times a process has had to wait for a locked table or a locked row. If there are no available locks you will get a lock overflow. >Thanks in advance. >-- Oscar Goldes >-- Orden Argentina SA