Re: Locks - how many is too many?

Kevin Ignasiak (ez242@cleveland.Freenet.Edu) wrote: : In a weeks time our Informix Online 5.03 system will generate about : 1.2 trillion lock requests! This is with maybe 10 users on the system. : A 'tbstat -p' shows no ovlocks, only 4 lokwaits, and just 1 deadlks. So : the lock request don't appear to be causing any problems, but the few users : are concerned about the response time they are receiving on their NCR 3600. : Could 1.2 trillion locks over a five day period cause a significant : system degradation? : Thanks in advance, : Kevin Ignasiak : (937) 229-3871 : ignasiak@opus.oca.udayton.edu : -- : Kevin Ignasiak As long as you're not getting deadlocks and many lock waits, I wouldn't worry about it..it's just the database doing its job. It might be telling you, though, that you are either doing too much row locking or have too restrictive an isolation level....but it doesn't seem to be hurting anything. Joe -- --------------------------------------------------------------------------- Joe Lumbley(jlumbley@netcom.com) ---------------------------------------------------------------------------