Re: sysdistrib table locks

Posted in 2004

Christopher — 19 Jan 2004 10:02:18 -0800 — source: Usenet: comp.databases.informix

Julio Cesar asked: > 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. 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. Sincerely, Christopher Coleman Database Analyst Pharmacy Division Mediware Information Systems, Inc. tel: 913/307-1073