Re: rearranging chunks

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. Hope that helps, -- Mark. +----------------------------------------------------------+-----------+ |Mark D. Stock - Informix SA http://www.informix.com |//////// /| |mailto:mdstock@informix.com http://www.informix.com/idn |///// / //| |http://www.iiug.org +-----------------------------------+//// / ///| | Tel: +27 11 807 0313 |If it's slow, the users complain. |/// / ////| | Fax: +27 11 807 2594 |If it's fast, the users keep quiet.|// / /////| |Cell: +27 83 250 2325 |Therefore, "No news: travels fast"!|/ ////////| +----------------------+-----------------------------------+-----------+