Re: Informix 2.10 Splitting Data Across File Systems?

You have to use symbolic links in the database directory proper which point to the actual data and index files in the auxilliary directory. e.g. mv /z/info.dbs/sometabl101.dat /u/info.dbs/sometabl101.dat mv /z/info.dbs/sometabl101.idx /u/info.dbs/sometabl101.idx ln -s /u/info.dbs/sometabl101.dat /z/info.dbs/sometabl101.dat ln -s /u/info.dbs/sometabl101.idx /z/info.dbs/sometabl101.idx Note that you could have the index on one file system and the data on another using this technique. Also ensure that the auxilliary directory is as carefully protected as the proper database directory. It probably isn't officially supported by Informix, so maybe I didn't say this. Don't make any mistakes while doing the moves. Backup the database first so you can recover if something goes wrong. Yours, Jonathan Leffler (johnl@informix.com) #include <disclaimer.h> >From: charli@clark.net (Charlene C.) >Subject: Informix 2.10 Splitting Data Across File Systems? >Date: 27 Sep 1994 17:06:00 GMT >X-Informix-List-Id: <news.8928> > >I am trying to split some of my database tables into two separate >directories. > >/z/info.dbs (where it is now) > >to > >/u/info.dbs > >I have tested one table. I put /u/info.dbs in my DBPATH to no avail. >Can this even be done?