I do not want to open a flame session on this subject, so I will
not respond to any follow up email. - That is my disclaimer!!!!
The Manuals are incorrect on this subject. Informix will
create sort and work files on 7.x engines in a file system directory.
I had a Informix SE spend about a two weeks reviewing this process on a
project,
with input from Informix Tech support. The PSORT_DBTEMP
variable needs to be set to a LARGE file system directory, or
increase "/tmp"'s size, because the engine will create
files when needed some place, you just want to control where
of the two places it will occurs. Nothing you can do about creating
the files, just control where they go.
Wayne E. Martin
Informix Database Administrator
Kmart Corp.
-----Original Message-----
From: yoda@dagobah.org [mailto:yoda@dagobah.org]
Sent: Wednesday, May 24, 2000 2:12 AM
To: informix-list@iiug.org
Subject: Re: SRTxxx: the trouble with Tribbles?
On Tue, 23 May 2000 10:36:27 -0400, Martin, Wayne E. <WMartin@kmart.com>
spouted:
>These files are created by Informix, there are a few others
>also, in the directory in the "PSORT_DBTEMP" environment
>variable. The default is "/tmp" if it is not set.
Thanks guys. According to the Performance Guide, sort files should go
to the dbspaces specified in DBSPACETEMP. Although we have a DBSPACETEMP
defined, the tempdbspace is completely empty, so it looks like something's
gone pearshaped somewhere. I'll apply the trusty sysadmin's 4lb lump
hammer to the side of the machine and see if that fixes it.