Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Art S. Kagel — — source: Informix-list mailing list archive (1991-1998)
Steve Levis wrote:
>
> Folks,
> I am running a ESQL/C query on a 50MB database and getting
> the following error messages.
>
> # 229: Could not open or create a temporary file.
> # 131: ISAM error: no free disk space
>
> There is over 200MB free in /tmp and more that 1GB in the
> directory where the root chunk is located. All permissions
> in these directories are correct.
>
> Online Dynamic Server, 7.12, on Solaris. I'm wondering if
> anyone can hazard a guess as to the cause of this error.
ODS 7.xx creates temp files in one of several places. For sort-work
files these go into the directories specified in PSORT_DBTEMP if it is
set if not they follow the temp tables. Temp tables are created in one
of the dbspaces specified in DBSPACETEMP if it is set in the environment
or if not the value of DBSPACETEMP set in the ONCONFIG file, if neither
location specifies DBSPACETEMP then temp tables are created in the
root dbspace. The root dbspace will not expand no matter how much free
space there is in the directory in which it was created (assuming that
it was created in filesystem space).
Looks like you need to export DBSPACETEMP at least and specify another
dbspace other than rootdbs. Best to create temp dbspaces for this
purpose.
Art S. Kagel
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.