Re: dbspace question

Detlef Liem wrote: > > Currently my dbspace is spread over 5 different chunks on > several small and slow hard-disks. After replacing these > disks with a larger and faster one, is it a good idea to > merge the small chunks into one large chunk ? > If yes, is there an easy way to do that ? > > Detlef Liem If you now have a single large, fast disk then from the point of view of performance you might as well move all your data to it. In which case a single chunk is easier to administer. But, from the point of view of resilience, and particularly recovery, you might want to leave your log dbspace on a separate device. To make the one chunk, onunload your database(s), remove any symbolic links to the chunks, drop the chunks/dbspaces, re-establish links to the new device and onload. Neil Truby Chase Manhattan Bank Bournemouth,UK