Re: rootdbs can be moved to larger chunk?

Hi Cosmo/Bill, Cosmo Lee wrote: > Bill Glidden wrote: > > In article <33B403D4.68D6@echonyc.com> you wrote: > > : Can a rootdbs be moved to a larger chunk? We have a rootdbs in a 20MB > > : chunk. We'd like to just move it to one of the larger chunks. Is there > > : a way to do this without re-initializing the server??? > > > > no, you can't do this. The only option is to add more chunks to the > > rootdbs. > > Is it not a possibility to add a chunk to the rootdbs, move the existing > tables to the new chunk, then dropping the original chunk? Is there > something that would be in the Reserve pages or elsewhere that might > cause trouble with this later on??? I suppose the rootdbs path in the > ONCONFIG file would have to be changed? > > I ask this because a client originally created their rootdbs in a unix > file rather than on a raw device, and I'd like to move it. Two options: 1. Add more chunks to the original rootdbs dbspace. You will *never* be able to free the primary chunk. It has critical information in it. 2. Create a raw device the same size as the rootdbs, with the correct permissions. With the OnLine server down, dd the contents of the current (cooked) rootdbs chunk to the new raw chunk. Change the rootdbs path in the ONCONFIG file and restart the server. You can make the raw device bigger than the current rootdbs size but the extra space will be wasted. Changing the ROOTSIZE field in ONCONFIG will *not* make ONLINE use the extra space. Chris -- Chris Jenkins (chrisj@informix.com) >>> All statements and opinions are mine and should in no way <<< >>> be construed as representing those of Informix Software <<<