Re: LOCKS

Sahrul Hidayat wrote: > > Dear all, > > I have a question about LOCKS. > > If we configure LOCKS, let say 1.000.000, Online allocates about 40 MB of > resident shared memory for LOCKS. So, When locks active i.e 6 users (i.e > result of onstat -k), the allocated of shared memory still 40 MB, even the > limit of locks doesn't reach the maximum ..?? or the allocation will be > smaller than 40 MB. I'm not too sure what you are asking, but if you are asking why the lock table never alters size, then it is because the LOCKS parameter defines the size of the lock table created in SHM. This table does not change size dynamically. You have allowed for 1,000,000 locks, so that is all you can create. Hope that helps, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+