informix locks' control
locks specifies the initial size of the lock table.the lock table holds an entry for each lock that a session uses. if the number of locks that sessions allocate exceeds the values of LOCKS,the database server increases the size of the lock table. for finding the bug of the applications,we want to limit the locks'dynamic increase. can control the locks'dynamic increase by the informix inner parameters or other way? please! thanks!
Actually, Sun, the automatically expanding locks table was not implemented until IDS v 7.30 (or maybe even later, I don't remember). The version the OP has is 7.13 which had a fixed lock table. Art Art S. Kagel Oninit (www.oninit.com) IIUG Board of Directors (art@iiug.org) Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Oninit, the IIUG, nor any other organization with which I am associated either explicitly or implicitly. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Sat, Sep 26, 2009 at 10:18 PM, SUN FANG <sunfang620@gmail.com> wrote: > locks specifies the initial size of the lock table.the lock table holds an > entry for each lock that a session uses. > if the number of locks that sessions allocate exceeds the values of > LOCKS,the > database server increases the size of the lock table. > > for finding the bug of the applications,we want to limit the locks'dynamic > increase. > can control the locks'dynamic increase by the informix inner parameters or > other way? > please! thanks! > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --0023545bd6580c2b1404749027e4
On Sat, Sep 26, 2009 at 19:18, SUN FANG <sunfang620@gmail.com> wrote: > locks specifies the initial size of the lock table.the lock table holds an > entry for each lock that a session uses. > if the number of locks that sessions allocate exceeds the values of > LOCKS,the > database server increases the size of the lock table. > > for finding the bug of the applications,we want to limit the locks' dynamic > increase. > can control the locks' dynamic increase by the informix inner parameters or > other way? > I don't think there is any ONCONFIG parameter that turns off the dynamic increase in the lock table. (Dynamic logs - yes; dynamic locks - not that I can see.) -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even. Mike Ditka <http://www.brainyquote.com/quotes/authors/m/mike_ditka.html>; - "If God had wanted man to play soccer, he wouldn't have given us arms." --00c09f9b070a6e13f80474961f33