RE: Rootdb
Posted in 1996
On Friday, June 07, 1996, Mike Segel wrote...
> Devkant N. Kulkarni wrote:
> >
> > I just wanted to point out that currently we are using unix filesystem
> > mirroring not Infomix's chunk to chunk mirroring. Rootdb is a raw
> > space allocated for Informix and is managed by Informix. I am a bit
> > confused as to why I need to do a dbexport. I was under the
> > assumption that, all I need to do is create a level 0 backup of the
> > database (which is about 11.5 gigs), create a Logical Volume in the
> > other VG, bring Informix down, remove the current link, create the
> > link pointing to the new rootdb and then restore...since the new
> > rootdb has no data.
> >
> No, won't work cleanly.
> Your new root partition must have the *same* configuration as
> before. Granted you are doing the striping in LVM, so that
> Informix sees it as a contiguous space. I assmume that it is one
> chunk....
>
> But the size and layout must be the same.
>
> The other reason to unload it, is to take the data out of the
> root db space. You may want to consider creating a separate dbspace
> for your application.
>
> (I know Jack covered all of this but you seemed confused.)
>
> Also, I would think that it would be better for having Informix
> mirror the dbspace. (This is debateable since I have never seen
> a disk crash yet on a mirrored dbspace so I am going from intuition.)
>
> -Mikey
>
Actually, there is a good reason to mirror the dspace. Informix recovery
(I'm talking 5.something)
behaves differently if mirroring is set to yes. It clears the logs (an if
you crashed because they filled
up, that's a good thing)
Lanny