Re: !!! URGENT !!!Not enough space for cursor

Paul Grenda wrote: > > Hi everyone hope you can help. > > We have a production system that has worked for years but has suddenly > ground to a halt with SQL error 229 and ISAM error 131 which finderr > says is trying to create a file in /tmp or the directory pointed to be > DBTEMP. It says that this directory has insufficient contiguous space. > > We look at /tmp and its empty ie plenty of space. All of our > directories look to have plenty of space. > > The actual instruction where the failure orrurs is where we try to > create a cursor and thats where it crashes. I assume you are using IDS which does not use /tmp or DBTEMP for temporary sort-work files. It either creates them in the root dbspace, the list of dbspaces specified in te environment variable DBSPACETEMP if it is set, or in the list of filesystems in the environment variable PSORT_DBTEMP with PSORT_DBTEMP taking highest priority and rootdbs lowest. Look in these places. Keep in mind that the engine will clean up the tempfiles before reporting the error so you may have to watch carefully to discover what is filling up if you cannot figure it out logically. Art S. Kagel