Re: Disk reorganisation

From: mgimbert8769@my-deja.com > >In article <8fpupm$mq1$1@news.xmission.com>, > vinod bhansali <vinodvb_2000@yahoo.com> wrote: > > > > We are planning for disk/data reorganisation. We are > > using 7.24 UC4 on HPUX 10.20. Can you please let me > > know the what all to consider and what should be the > > steps. > > > > I am planning for following things : > > To place tables joined frequently on different disks > > with diff controllers Good. > > Redefine extent size and next extent size Yep. Might as well just put all your existing data into one extent, if possible. > > Balancing Chunk IO Yep. > > Equally utilising space in each dbspace. Why? You might have a whole load of really big but idle tables in one dbspace, which might be full, and just one (relatively small) table in its own dbspace, it's just a function of load. > > Are there any other things to be considered. > >Put the biggest tables isolated in separated dbspaces The biggest tables are not necessarily the most heavily used. The most heavily used tables should be placed on separate spindles if possible. rootdbs, llogdbs and plogdbs should all have their own spindles if possible. You should have at least 3 temp dbspaces, and they should all have their own spindles. ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com