Re: Moving Chunks/ Patching Pseudo Tables ?

Posted in 1998

Sigrid Ehrenreich — Mon, 14 Sep 1998 09:33:14 +0200 — source: Informix-list mailing list archive (1991-1998)

> 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