Re: Unable to create an Index!

Robert Hosler wrote: > > I am running Informix-Online 7.11.UC1 on Digital UNIX 4.0 and I get two > errors whenever I try to create an index. Errors -212 and -116 > > Please send replies to rhosler@ptt-telekom.com or bendarek@sundial.net Error -212 just says that the index could not be created. Error -116 tells you why, finderr -116 says the error text is: ISAM error: cannot allocate memory. The index create required additional vitual memory for sort-work space and could not allocate it. There might be several reasons amoung these: You have SHMTOTAL set too low in your ONCONFIG file and the engine could not allocate an additional virtual segment because of this. Run onstat -g seg and compare the total sizes of all of the class V segments to the SHMTOTAL value if SHMTOTAL is larger than this total plus SHMADD then this is not the problem. If it is not then increase SHMTOTAL to allow at least one more virtual segment or just set it to zero meaning no limit. If the problem is not SHMTOTAL look to see if you are out of memory and/or swap on the system (or might have been at the time). If there was plenty of memory check the kernel parameters to make sure that the kernel will allow as large a shared memory allocation per process as you will need. Art S. Kagel