Re: Debugging "no free disk space" error

Andrew You say that your query has order by, which is probably why it is trying to create a temporary table. Check in your ONCONFIG file if your DBSPACETEMP is set. Most likely it is not, thus it uses the rootdbs for temp space to create the temporary file for the sort. You can also make it use a file system space like /tmp (if it is large enough) by setting PSORT_DBTEMP in your environment. HTH Sujit andrew@pimlott.ne.mediaone.net (Andrew Pimlott) on 02/24/99 05:41:42 PM Please respond to pimlott@abel.math.harvard.edu To: informix-list@iiug.org cc: (bcc: Sujit Pal) Subject: Debugging "no free disk space" error I've inherited an Informix 7.2 database, which I unfortunately do not know how to administer. I'm reading the documentation, but I hope that someone can give me a few pointers on how to track down this problem. (Really, even a one sentence reply with a command to look into would be great.) A somewhat complicated database query is failing with the errors: SQL: -264: Could not write to a temporary file. ISAM: -131: ISAM error: no free disk space The query includes joins, subqueries, and order by. It does not modify any tables, and the database it operates on is not in the rootdbs dbspace. My investigation suggests that the dbspace rootdbs is filling up (as opposed to a disk partition). onstat -d shows that rootdbs has size 10000 and free space 847 (these seem to be 2k blocks). When the query is running, onstat -d shows the free space decreasing to near 0, then the error occurs and the free space jumps back to 847. (df shows no partitions filling.) What I can't figure out is, what exactly is taking up space in rootdbs and (particularly) what is filling up. I suspect that it is a log that's filling, in which case I'd be happiest to lop it off, but I don't know how. The database does not have high reliability requirements (at least right now); much more important is that it not suck developer time as it is doing. Any suggestions on what I can do to forget about the database in the future are greatly appreciated. Last, I'm not exactly sure what set of tools I have on hand. I've seen many references to ON-Monitor in the docs, but I don't have an onmonitor command. As far as I can tell, I do not have any graphical tools, only terminal-based ones. My platform is Solaris 2.5.1. Thanks, Andrew Email Cc's appreciated. -- In general NT is what you get if you could do some portions of Unix all over again, and then managed to get it all terribly wrong. - Maury Markowitz <maury@remove_this.istar.ca>