sysdistrib table locks

sysdistrib table locks

Post by Julio Cesa » Tue, 20 Jan 2004 20:02:13

Is it normal to have a lot of lock tables on sysdistrib?
By now, I have 46 table locks on this table and I'm having a lot of
performance issues.


Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ( ).
Version: 6.0.561 / Virus Database: 353 - Release Date: 13/1/2004

sending to informix-list

sysdistrib table locks

Post by christophe » Wed, 21 Jan 2004 03:02:18

Julio Cesar asked:

Yes, it is normal. The optimizer has to lock the table when scanning
the distributions for queries. Update statistics medium or high can
also grab locks.

After upgrading to 7.31.UD4, some of our customers did see an abnormal
number of locks on sysdistrib until they dropped them (UPDATE
STATISTICS LOW DROP DISTRIBUTIONS) and recreated them. We could not
reproduce this, and I never was able to accurately diagnose the
problem, though.


Christopher Coleman

Database Analyst
Pharmacy Division
Mediware Information Systems, Inc.
tel: 913/307-1073