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)
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
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.