RE: Moving Chunks/ Patching Pseudo Tables ?

Dave, What do you think about shutting the engine down, moving the chunks and then using soft links to point to the new location. Apart from it making the installation a harder to figure out will it work? Sorry if this has already been suggested. David Ashby -----Original Message----- From: davek@summitdata.com [mailto:davek@summitdata.com] Sent: Tuesday, 15 September 1998 3:14 To: informix-list@iiug.org Subject: Re: Moving Chunks/ Patching Pseudo Tables ? Sigrid Ehrenreich <seh@carus.de> offerred: +> I have an Informix Database on cooked disk space. Now I would like to +> change the path to the chunks (datafiles). Is there any way except +> unload/load the whole data? +Thanks a lot for your help so far. What I am looking for is a way to +change the pathnames of the chunks without having to move the data. I +found a pseudo table named syschktab, that contains the pathnames of the +chunks. Is there any way to manipulate the information in the pseudo +tables? I would like to do something like "update syschktab set +fname=<new path> where chknum=3". Think about this. You want your chunk to be moved to a new path, but you don't want to move any data. How is the data going to get from its current location to the new chunk location? Even if it were doable (and there are some potential ways for accomplishing it, none for the sqeamish ;-)) you still HAVE to move data somehow. FYI, you cannot update any pseudo tables - they are read only. Your safest way bt far is to dbexport the data, recreate your IDS instance and dbimport it back in. Dave ** Dave Kosenko <davek@summitdata.com> ** Director of Training Services (732) 469-4070 ** Summit Data Group (an Informix Authorized Education Center) ** Find my advice useful? Let me teach you everything I know about ** Informix. Sign up for OFFICIAL Informix training at SDG. ** For details, see http://www.summitdata.com/training