lock table overflow

Posted in 2003

Bill Hamilton — Tue, 19 Aug 2003 17:47:32 -0500 — source: Usenet: comp.databases.informix

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