Re: message.log: lock table overflow

In article <5kv4v8$ldm@cssun.mathcs.emory.edu>, Sean Birkhead (sean@infosol.ie) writes: >In <5kul2f$92t@news.cis.nctu.edu.tw>, Xiong wrote: >} >} In informix message.log file, I found the following messages : >} >} 20:21:42 lock table overflow - userid ..., sessionid ... >} ... ( Similar lock table overflow messages omitted ) >} 20:28:40 lock table overflow - userid ..., sessionid ... >} >} By running 'onstat -g sql', I found 4 sessions with SQL ERR and >} ISAM ERR as follows >} >} SQL ISAM SQL >} ERR ERR stmt >} -240 -134 DELETE >} -211 -134 ... >} -211 -134 CREATE INDEX >} -243 -134 UPDATE >} >} -134 ISAM error: no more locks. >} -211 Cannot read system catalog catalog-table. >} -240 Could not delete a row. >} -243 Could not position within a table table-name. >} >} >} >} LOCKS of $INFORMIXDIR/etc/$ONCONFIG is set to 350000 >} >} Does the 'lock table overflow' message mean the server need more >}LOCKS? >} Can I solve the problem by increasing LOCKS value ? >} Any response to solve the problem is appreciated ! >} >} >} >}-- >}Fu-Xiong Lin > > >This is probably a Unix kernel parameter being exceeded. >Check all parameters in your Unix kernel to do with >files, processes and inodes. > >You haven't stated your O/S but for example the parameter to be checked >under SCO Unix would be : > >FLCKREC: number of records that can be locked by the system. > >other related parameters worth checking are : > >NINODE: maximum number of open inodes (systemwide). > >NFILE: maximum number of open files (systemwide). > >NOFILES: maximum number of open files per process. > > > It does appear that you have run out of locks. I would look at the other processes (large queries, prehaps) that were running when the overflow condition occurs. Yes, you could increase the number of LOCKS in the configuration; however, the way I read the ODS Adminstrator's Guide, 38-27 is that the number of LOCKS that you can REALLY have is limited by resident shared memory. 44 bytes per lock, remember? So, how much resident shared memory do you have? Can resident shared memory get "paged" out to disk? I don't really know, but the term "resident shared memory" seems like it has to reside in memory. David Weis dweis@louisville-i-market.com Louisville Internet Marketing Service 1210 Garvin Place Louisville, KY 40203 502-637-7316 (Voice) 502-636-1553 (FAX) http://www.louisville-i-market.com thank goodness for bookmarks!!