Scott,

> > Looks like you are short of some resources.
>
> Ivan,
>
> I think you are right. It appears the Firebird installation does not
> include /opt/interbase/tmp
>
> What I gather from this line:
> #TMP_DIRECTORY 20000 "/opt/interbase/tmp"
> in the isc_config file, the directory is needed.

Actually, since the line starts with '#', this means that the line is
commented out -- so it has no effect.

> Anyway, I created the tmp directory and sweep runs fine now. (in case
> anyone else runs into this problem)

To be honest, I find it very difficult to beleive that this solved the
problem, the sweep and the temporary/sorting directory have nothing to
do with each other -- there *has* to be another explanation.


Sean