Re: rearranging chunks

In article <35DD96CD.7197@bloomberg.net>, kagel@bloomberg.net (Art S. Kagel) wrote: > Mark D. Stock wrote: > > > > Zdravko Balorda wrote: > > > > > > Hi, > > > > > > is there a way to rearrange disk partitions and > > > chunks once dbspaces are initialized and data > > > loaded? I am not quite happy with what i did. > > > I want to, say, copy a chunk to another one so > > > that the first one could be dropped. > > > > > > Or is this chunk layout frozen, once you created > > > it. > > > > Well giza clue. Up to version 5.x the answer is pretty much "yes". You > > can only drop an entire dbspace and only if it is empty. > > > > In versions later than 5.x you can drop individual chunks, but again, > > only if they are empty. So you will have to move the databases and > > tables manually using something like onunload and onload, then drop > > the > > chunks and re-assign them. > > > > If the tables are fragmented, then you can use ALTER FRAGMENT to move > > the data around. > > Actually you can use ALTE FRAGMENT even on unfragmented tables with the > INIT clause. > > Art S. Kagel > Yes but only if you spell ALTER correctly. i(Sorry Art, English sense of humour) Paul Watson # I don't suffer from WF Software Ltd. # stress, I'm just Tel. (+44) 1436 674729 # a carrier Fax. (+44) 1436 678693 #