Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Dirk Moolman — — source: Informix-list mailing list archive (1991-1998)
Hi, I'm not to familiar with Online 5, but you can try the following 2
commands
tbstat -k (this will give you all the locks)
Within the above statement there is an "owner" column. You can take the
value in this column and do an
tbstat -u | grep <owner-id>
to get the owner of the lock
This might show you who is using the most locks and you can then find out
what that person is doing.
I hope this helps
Regards
Dirk
Soporte Tecnico de Informix <infx.sup@gotec.com> wrote in article
<6jpoc6$i0b$1@news.xmission.com>...
>
> Hi folks:
>
> I have Informix Online 5.03, configured with 14000 locks in the
> shared memory. Althougth the applications in 4GL is now report the error
> ISAM: no more locks (134) or the sql: Could not do an indexed read to get
> the next row (246). The error is each day more and more frecuently, and
the
> problem is too poor, when i start the informix online and the error ocurr
> near inmediatily at startup!!! What happens? How i identify the
process
> what cause the problem?
>
> Thanks in avance!
>
> PD: Excuse the bad english! :-)
> Informix Costa Rica
> Soporte T=E9cnico
> Sistemas Integrales de Computaci=F3n
>
>
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.