On 2 Aug 2002, William L. Thomson Jr. wrote:

> On Fri, 2002-08-02 at 17:26, Scott Taylor wrote:
> > On 2 Aug 2002, William L. Thomson Jr. wrote:
> >
> So it must be a sort thing? I may have to make a few more and see. As
> when I do my partitions on my DB server I do not allocate much to /tmp
> as I never see it being used?

It's not huge, I never used to bother with /tmp before I started building
DB servers.

> I believe I have like 100+MB for /tmp, give or take 10-20MB's.

Mine currenty uses, 5 * 17MB files, that's not a lot, but I've seen it
worse.

> So far that has been enough but if I do use sort, and /tmp files are
> needing to be written. Is there a negative outcome of the server trying
> to write/use a file in /tmp and not being able to?

From my expereince, FB/IB dies if it can't write the sort file.

ciao.

Scott.