Re: Informix 2.10 Splitting Data Across File Systems?

->Subject: Informix 2.10 Splitting Data Across File Systems? ->Date: 27 Sep 1994 17:06:00 GMT ->From: charli@clark.net (Charlene C.) ->Reply-To: charli@clark.net (Charlene C.) ->Organization: Clark Internet Services, Inc., Ellicott City, MD USA -> ->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? -> ->Thanks for all help. ->Charlene ->charli@clark.net Yes, it can be done, but you are changing the wrong info. You need to change the "dirpath" column in the "systables" table. This presumes, of course, that we are talking about a Standard Engine database. The steps involved are: 1. Assure some quiet time, alone with your database. Taking a backup first is also a good idea. 2. Select tabname, dirpath from systables for the tables you want to move. 3. For table "mytab", which happens to have tabid=123, a. copy the "mytab__123.dat" and "mytab__123.idx" files to their new locations, b. update the dirpath column to include the absolute path to the files, such as "/u/info.dbs/mytab123". Note that dirpath does not include the .dat or .idx extensions. 4. Repeat step 3 for each table that you want to move. Regards, Alan ___________________________ ______________________| R. Alan Popiel |__________________________ \\ Internet: | Martin Marietta, SLS | / \\ alan@den.mmc.com | P.O. Box 179, M/S 3810 | Std disclaimers apply. / )Voice: | Denver, CO 80201-0179 USA | ( / 303-977-9998 |___________________________| (But you knew that!) \\ /________________________) (____________________________\\