Re: memory allocation failed - error 406

Maria Wilson wrote: > > I am trying to load a large (around a gig) msaccess database into an > informix db on a Solaris 2.5 machine with Informix 9.x engine on it. I > am getting this error (406) after several hours of loading. The sql is > not doing anything other than loading data - no sorting or anything > else. > > I do - although - only have 128Mb of memory on the Solaris machine. > What could be my problem? It might be that you do not have enough memory, or kernel parameters do not allow enough for shared memory, or the ONCONFIG parameter SHMTOTAL is limiting your additional segments. Run onstat -g seg to see how much free memory you have in the existing segments and how many class V segments you have (ideally you should have only one if SHMVIRTSIZE is sized correctly. If there are more than one VIRTUAL segment or the primary segment is nearly full you may have a memory leak in your applications causing the engine to allocate corresponding comm structures. Look for cursors that are being redeclared without having been CLOSEd or FREEd. The same with PREPAREd statements. Look for statements being redeclared without having been FREEd. Closing cursors and freeing statements and cursors releases resources that the engine has allocated for these. Art S. Kagel