IDS Forum

Re: Increasing the number of LOCKS

Posted By: Art Kagel
Date: Friday, 29 April 2011, at 6:22 a.m.

In Response To: Increasing the number of LOCKS (SUSHANT KODE)

Yes, you have to restart the instance for LOCKS to take effect. Yes memory
usage MAY increase, but that comes out of the VIRTUAL segment which may have
sufficient free space without taking more memory into the server. However,
during processing, you may have additional SHMADD segments appearing, so you
may want to increase SHMVIRTSIZE to accommodate the increase in the lock
table. Locks in 9.40 are about 48 bytes each.

Art

Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
Blog: http://informix-myview.blogspot.com/

Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. 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 Fri, Apr 29, 2011 at 2:11 AM, SUSHANT KODE <ksushants@gmail.com> wrote:

> Hi All,
> We are using Informix Dynamic Server Version 9.40.UC5 on SUSE Linux
> Enterprise
> Server 10.
>
> While running a monthly processing step we are facing "Lock Table Overflow"
> error. the LOCKS defined in the config file is 20,00,000. We are planning
> to
> double the no. of locks i.e. 40,00,000.
>
> Can you please let me know the following:
> 1) Do I have to restart the instance after the parameter is modified in
> config
> file inorder to get the value effective?
> 2) The shared memory will increase by what amount. The current shared
> memory
> is:
> Segment Summary:
> id key addr size ovhd class blkused blkfree
> 7274499 1381582850 2b960000 409600000 13144 V 69954 30046
> 7241728 1381582849 44000000 1928728576 273684 R 470865 16
> Total: - - 2338328576 - - 540819 30062
> 3) Any other suggestion to avoid this problem.
>
> Thanks in advance.
>
>
>
> *******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>

--20cf307cfbcaa189bd04a20c0c2d

Messages In This Thread

• Increasing the number of LOCKS
  SUSHANT KODE -- Friday, 29 April 2011, at 2:11 a.m.
  • Re: Increasing the number of LOCKS
    Art Kagel -- Friday, 29 April 2011, at 6:22 a.m.
  • RE: Increasing the number of LOCKS
    Fernando Nunes -- Saturday, 30 April 2011, at 4:08 a.m.

IDS Forum is maintained by Administrator with WebBBS 5.12.