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. This is a common misconception. Mark, you can use ALTER FRAGMENT to move tables whether they are fragmented or not, assumming 7.xx+ of course. I just moved 20 tables today to free up space in an overused dbspace on our developement machine this AM none were fragmented. The real rub for Zdravko will be if he has databases declared in a dbspace he will not be able to move the system catalog tables and competely free all chunks. Art S. Kagel