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