Re: rearranging chunks

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