Re: Moving Chunks/ Patching Pseudo Tables ?
Posted in 1998
In article <35FCC6BA.41C6@carus.de>, seh@carus.de (Sigrid Ehrenreich) wrote: > > 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". > > Yours > Sigrid Ehrenreich > seh@carus.de > I think that's a very brave thing to try - I hope you've got a good safety net. Paul Watson # I don't suffer from WF Software Ltd. # stress, I'm just Tel. (+44) 1436 674729 # a carrier Fax. (+44) 1436 678693 # www.wfsoftware.co.uk