Re: On Dropping chunks

Reorg the tables in this dbspace so that all of the free space is in the last chunk which should not have any TABLESPACE entries in it. Then you can drop the last chunk and add it to the other dbspace. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Mon, Feb 8, 2010 at 11:13 PM, Omar Muñoz <omarmun@yahoo.com> wrote: > Hi there. > > I have the following question. Can I drop a chunk which is not the > initial for dbspace, but it's not the last one either? Because I am in this > situation: the second of three chunks on the same dbspace is empty according > with Server Studio, but with TBLSpace entries on it. When I try to drop it > using Server Studio or onspaces send me a chunk not empty message. Since I > am reorganizing storage in order to reclaim some space for another dbspace > with lack of space, what should I do to reclaim that empty chunk? Should I > drop chunks in order and then I would drop last chunk in dbspace first? Or I > should to clean up entire dbspace and drop everything? > > All this situation is running on IDS 10 FC8 on Solaris 9 > > Thanks in advance > > Omar Muñoz > > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >