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

Up the LOCK in $ONCONFIG

However if LOCKS is already large then maybe you need to review the
application logic

Michel _newbie wrote:
>
> 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
[cutting]

--
Paul Watson #
Oninit Ltd # Growing old is mandatory
Tel: +44 1436 672201 # Growing up is optional
Fax: +44 1436 678693 #
Mob: +44 7818 003457 #
www.oninit.com #

On Wed, 19 Nov 2003 14:37:49 +0100, "Michel _newbie"
<martin.michel8@wanadooo.fr> wrote:

>Sorry, it's difficult for me to write in english.

Your English is much better than my French . . .8-)

>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 ?
>

Well, it depends....

The LOCKS parameter in your ONCONFIG file may be set too low.
Depending on the setting, you might want to raise it and restart
Informix.

The other issue may be your application. If you're deleting all the
rows of a million row table, you would probably want to lock the
table, for example.

On Wed, 19 Nov 2003 14:37:49 +0100, "Michel _newbie"
<martin.michel8@wanadooo.fr> wrote:

>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
You have to check LOCKS in $ONCONFIG.
But, you have the problem with checkpoint duration, too. Reason for that can be
some others parameters in $ONCONFIG and your application logic.
If in your application you have:
large deletes or updates - try to lock table or split operations to
smaller transactions
selecting into temporary tables - use SELECT ... INTO TEMP t1 WITH NO
LOG
creating temporary tables - use CREATE TEMP TABLE t1 (....) WITH NO LOG

Nebojsa
------------------------------------
Remove spam block (DELETE_) to reply