Re: Backing up then resizing RAW space

Jack Parker (jparker@hpbs3645.boi.hp.com) wrote: : > : > I have a 1 gig raw partition for my informix 5.x database..and only 600 megs are used... : > I am changing the partitioning scheme on my sun box and am wondering if there is a relatively easy way : > to backup that raw partition and restore it into a 600 meg raw partition that is a different physical slice? there is another way to do it, depending on your time considerations and allowable downtime, but this is also a good cleanup for the dbspace. if you unload all the databases in the dbspace, then drop the dbspace, and then add the dbspace again with the smaller size. then you load your databases back in. that will take care of the size problem. the other advantage is that if your databases are fragmented all over the db- space, then this will load each database physically contiguous within the dbspace, which is usually at least a small performance gain. of course, as i said, it all depends on your time limits. mickm -- _____________________________________________________________________________ Mickey Mestel mickm@netcom.com -on a beach in thailand to a beautiful, stoned, norwegian woman: "..yeah, it's just another foreign country without ice." -----------------------------------------------------------------------------