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.
First, you should stop the session from attempting to create locks. Find
out what the query was doing to cause a lot of locks to be used. If a
major update/delete/insert then consider exclusively locking the table
before running the query. If you have multiple updating sessions, you
might want to consider increasing the $INFORMIXDIR/etc/$ONCONFIG LOCKS
parameter (there is a limit -- check the release notes
$INFORMIXDIR/release/*/*). Would have to have more info to give you more
info....
"Azeemuddin,
Basheer" To: informix-list@iiug.org
<bahmed@KNRQ.com> cc:
Sent by: Subject: Lock table overflow - user id 283, session id 20458
owner-informix-lis
t@iiug.org
01/22/2004 12:24
PM
What should I do to get rid of this problem
Thanks
Basheer
sending to informix-list
sending to informix-list
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.