RE: SHMTOTAL
Posted in 2006
SHMTOTAL is the upper limit of the total memory size for IDS. If you set SHMTOTAL to 100 MB then resident size (BUFFERS) + virtual size (DS_TOTAL_MEMORY, etc) + message size can not exceed 100 MB. The Admin Guide is trying to tell you to reduce BUFFERS if you want to allow the engine to have more virtual memory or reduce DS_TOTAL_MEMORY if you want the engine to have more buffers. What you probably want to do is increase SHMTOTAL (or set to 0 for unlimited) and increase SHMVIRTSIZE so IDS doesn't need to allocate additional virtual segments. Andrew Ford -----Original Message----- From: informix-list-bounces@iiug.org [mailto:informix-list-bounces@iiug.org] On Behalf Of danielyeap@gmail.com Sent: Wednesday, August 09, 2006 9:31 AM To: informix-list@iiug.org Subject: SHMTOTAL Hi All, I came across this line in the Informix 9.3 Administration Guide: If messages indicate on a regular basis that the database server needs more memory than SHMTOTAL allows, you have not configured the database server correctly. Lowering the value of BUFFERS or DS_TOTAL_MEMORY is one possible solution, and increasing the value of SHMTOTAL is another. I do not understand why I have to lower the BUFFERS or DS_TOTAL_MEMORY if I need more memory. I thought I should be increasing those values so that Informix will have more memory to play with, hence lowering the risk of needing to dynamically assigning more memory segments to Informix. _______________________________________________ Informix-list mailing list Informix-list@iiug.org http://www.iiug.org/mailman/listinfo/informix-list