Re: db space

>I am running some isql statements that are sorting a large group of >records. I get the following 2 errors: > > 564: Cannot sort rows.> > 28: No space left on device. > >We are new to Informix so I don't know if we have any temp db space set up. >How should we set some up? > >We are running Informix 7.14 on a RS/6000 You can try setting DBTEMP=/path1:/path2:/path3... where path1 to n are absolute pathnames where you have some disk space. Otherwise, you might just want to up the space available in /tmp If DBSPACETEMP is supported (check in $INFORMIXDIR/etc/onconfig if you have one), you can stick the names of some dbspaces in there (at least four is recommended) -- they shouldn't really be used for anything else, you should create new ones. Remember, things are generally fragmented in a round robin fashion in temp dbspaces, so you generally are limited by the size of the smallest dbspace you allocate. HTH. ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com