Re: rootdbs can be moved to larg

If you really, really want to move the root dbspace from cooked file to raw device, use the following example: Assume that your current root dbspace is /usr/rootchunk & it consists of 20000 2k pages. You want to move it to /dev/rdsk/rootchunk. 1. Create your slice /dev/rdsk/rootchunk using the appropriate o/s commands. Make appropriate ownership and permission changes. 2. Shut down your Informix instance. Make an archive to be safe. 3. Copy the contents of /usr/rootchunk to /dev/rdsk/rootchunk. dd if=/usr/rootchunk of=/dev/rdsk/rootchunk bs=2048 count=20000 4. Remove the file /usr/rootchunk. Replace it with a symbolic link to /dev/rdsk/rootchunk. rm /usr/rootchunk; ln -s /dev/rdsk/rootchunk /usr/rootchunk. 5. Bring the instance back up with the root dbspace still pointing to /usr/rootchunk. You're in business. Mike Ballentine --------------------------( Forwarded letter 1 follows )--------------------- Date: Monday, 30 June 1997 12:21pm From: cosmo@echonyc.com Subject: Re: rootdbs can be moved to larger chunk? Date: Sat, 28 Jun 1997 23:26:32 -0500 Reply-To: cosmo@echonyc.com Organization: Multi-User Computer Systems Sender: informix-list-owner@rmy.emory.edu To: informix-list@rmy.emory.edu X-Informix-List-Id: <news.39831> 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. Thanks. -- * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * Blah Blah Lounge - "Do You Have Something Smart To Say?" Cosmo Lee email: cosmo@echonyc.com Brooklyn, NY * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *