Re: lock table overflow

Bill, what is onstat -p showing for ovlocks? I can't see why this would suddenly start happening after a Windows Service Pack upgrade. But - you never know ... ----- Original Message ----- From: "Bill Hamilton" <bham@finsco.com> To: "informix-list iiug" <informix-list@iiug.org> Sent: Tuesday, August 19, 2003 11:47 PM Subject: lock table overflow > GlacierThe Informix log keeps getting messages about lock table overflows > everytime time a > checkpoint is done. For example: > > 17:20:41 Lock table overflow - user id 6, session id 1363 > 17:22:18 Checkpoint Completed: duration was 0 seconds. > 17:22:18 Checkpoint loguniq 1155, logpos 0xd11018> > This started right after service pack 3 was applied to Windows 2000. > (IDS is still 7.31) > > There are 20000 locks and I can never find more than a few hundred in use > at one time. > > I guess I need to know if I should increase the number of locks or is it > something else. > > sending to informix-list sending to informix-list