Re: Running out of locks

Posted in 2003

ART KAGEL, BLOOMBERG/ 65E 55TH — Wed, 05 Mar 2003 16:09:55 — source: IIUG Forums & Mailing Lists

Does the table have six or more indexes? The number of locks help per row is one plus the number of indexes and (17k * 6) > 100k! Art S. Kagel ----- Original Message ----- From: Rob Phillips <RPhillips@ce-a.com> At: 3/ 5 10:57 > Last night while running an update for ~17k rows Informix reported to me > that I was out of locks. At the time I was the only user in the database, > the table had row level locking on and the max # of locks was set at 50000. > I increased the locks to one hundred thousand and still got the same error. > How can an update of 17k rows use more than 100,000 locks?

↪ replying to ART KAGEL, BLOOMBERG/ 65E 55TH

Phillips, Rob — Wed, 05 Mar 2003 16:44:32 — source: IIUG Forums & Mailing Lists

Thanks guys that was it. Believe it or not the table has 13 indexes (whew) some of those need to be removed. -----Original Message----- From: ART KAGEL, .... [mailto:KAGEL@bloomberg.net] Sent: Wednesday, March 05, 2003 11:10 AM To: ids@iiug.org Subject: Re: Running out of locks [597] Does the table have six or more indexes? The number of locks help per row is one plus the number of indexes and (17k * 6) > 100k! Art S. Kagel ----- Original Message ----- From: Rob Phillips <RPhillips@ce-a.com> At: 3/ 5 10:57 > Last night while running an update for ~17k rows Informix reported to me > that I was out of locks. At the time I was the only user in the database, > the table had row level locking on and the max # of locks was set at 50000. > I increased the locks to one hundred thousand and still got the same error. > How can an update of 17k rows use more than 100,000 locks?