Increasing the number of LOCKS
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.
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
Besides what Art already mentioned, I would suggest locking the whole table= (s) or make it using smaller transactions. The number of locks you're using= is already huge... -----Original Message----- From: SUSHANT KODE <ksushants@gmail.com> Sent: sexta-feira, 29 de Abril de 2011 8:11 To: ids@iiug.org Subject: Increasing the number of LOCKS [23555] Hi All,=20 We are using Informix Dynamic Server Version 9.40.UC5 on SUSE Linux Enterpr= ise=20 Server 10.=20 While running a monthly processing step we are facing "Lock Table Overflow"= =20 error. the LOCKS defined in the config file is 20,00,000. We are planning t= o=20 double the no. of locks i.e. 40,00,000.=20 Can you please let me know the following:=20 1) Do I have to restart the instance after the parameter is modified in con= fig=20 file inorder to get the value effective?=20 2) The shared memory will increase by what amount. The current shared memor= y=20 is:=20 Segment Summary:=20 id key addr size ovhd class blkused blkfree=20 7274499 1381582850 2b960000 409600000 13144 V 69954 30046=20 7241728 1381582849 44000000 1928728576 273684 R 470865 16=20 Total: - - 2338328576 - - 540819 30062=20 3) Any other suggestion to avoid this problem.=20 Thanks in advance.=20 ***************************************************************************= ****=20 Forum Note: Use "Reply" to post a response in the discussion forum.=20