RE: [HELP] - Lock table overflow

Hi, There is two whay to deal whith this : 1 - You can increase the number of locks in $ONCONFIG (LOCKS Number), this is the best in OLTP mode. OR : 2 - If the operation is to be done in BATCH mode you can LOCK th table in EXCLUSIVE MODE. LOCK TABLE table-name IN EXCLUSIVE MODE -----Message d'origine----- De : Michel _newbie [mailto:martin.michel8@wanadooo.fr] Envoy' : mercredi 19 novembre 2003 13:38 ' : informix-list@iiug.org Objet : [HELP] - Lock table overflow Sorry, it's difficult for me to write in english. I have some problems, this is a part of the file "/opt/informix/online.log" : 13:20:28 Lock table overflow - user id 0, session id 6985 13:20:29 Lock table overflow - user id 0, session id 6986 13:21:20 Lock table overflow - user id 0, session id 7018 13:21:21 Lock table overflow - user id 0, session id 7019 13:21:22 Lock table overflow - user id 0, session id 7020 13:21:23 Lock table overflow - user id 1002, session id 6889 13:21:23 Lock table overflow - user id 0, session id 7021 13:21:30 Checkpoint Completed: duration was 107 seconds. 13:28:58 Checkpoint Completed: duration was 128 seconds. 13:34:02 Checkpoint Completed: duration was 3 seconds. 13:39:11 Checkpoint Completed: duration was 9 seconds. 13:44:19 Checkpoint Completed: duration was 8 seconds. 13:49:23 Checkpoint Completed: duration was 4 seconds. 13:54:26 Checkpoint Completed: duration was 3 seconds. 13:59:30 Checkpoint Completed: duration was 4 seconds. 14:04:33 Checkpoint Completed: duration was 3 seconds. 14:05:04 Logical Log 12365 - Backup Started 14:05:05 Logical Log 12365 Complete. 14:05:07 Logical Log 12365 - Backup Completed 14:09:36 Checkpoint Completed: duration was 3 seconds. 14:14:39 Checkpoint Completed: duration was 2 seconds. 14:19:41 Checkpoint Completed: duration was 3 seconds. 14:24:44 Checkpoint Completed: duration was 3 seconds. 14:31:22 Checkpoint Completed: duration was 167 seconds. 14:32:06 Lock table overflow - user id 100, session id 10139 14:32:06 Lock table overflow - user id 100, session id 10139 14:32:07 Lock table overflow - user id 1002, session id 10336 14:32:07 Lock table overflow - user id 1002, session id 10336 14:32:07 Lock table overflow - user id 1002, session id 10336 14:32:08 Lock table overflow - user id 1002, session id 10336 14:32:08 Lock table overflow - user id 1002, session id 10336 14:32:08 Lock table overflow - user id 1002, session id 10336 14:32:08 Lock table overflow - user id 1002, session id 10336 14:32:09 Lock table overflow - user id 1002, session id 10336 Can you help me ? I must modify sometnig in /opt/informix/etc/onconfig.ids_thing ? Thanks Michel sending to informix-list