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

What Informix Server are you running ? Could you please try to check the free space using df command ? I'd check the free space and free inodes on filesystem on what /tmp is installed: df -v df -i Check on what filesystem the /tmp directory is. If you are running Dynamic Server check if you have set the DBSPACETEMP parameter in ONCONFIG or as an environtment variable. Hope some of these will help, Octav 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. > >My question is what am I missing? > >If noone can suggest a solution can someone advise where I can get help >from. I need it urgently as this is critical production system. > >Regards, > >Paul -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 36 59 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo-moldova.com