locks and lockreqs

Posted in 1999

klball@my-deja.com — Tue, 13 Jul 1999 16:10:48 GMT — source: Informix-list mailing list archive (1991-1998)

Running 7.2 with 250 users. Very I/O intensive application. Locks are currently at 400,000, any thoughts?. Also when running onstat what does the lockreqs number represent? It is a very large number. Thanks Sent via Deja.com http://www.deja.com/ Share what you know. Learn what you don't.

↪ replying to klball@my-deja.com

Carlson@WHSmith — Tue, 13 Jul 1999 13:04:38 -0400 — source: Informix-list mailing list archive (1991-1998)

Are you running out of locks? (ovlock > 0) Our systems have LOCKS set at 300000 due to locking requirements of the Lawson software that we run. I'd say, if it's not causing any problems, don't worry about it. Lockreqs have to do with the way that Informix handles locks. I also noticed the increase when we migrated from 5.x to 7.x. I'd watch lokwaits, though. John Carlson Informix DBA WHSmith USA klball@my-deja.com wrote: > > Running 7.2 with 250 users. Very I/O intensive application. Locks are > currently at 400,000, any thoughts?. Also when running onstat what does > the lockreqs number represent? It is a very large number. > > Thanks > > Sent via Deja.com http://www.deja.com/ > Share what you know. Learn what you don't.

Glossary

onstat