Re: No way to drop a chunk ??

sicota@country.teuto.de wrote: >Hi there ! >I recently came across some situations where I needed to drop a chunk. The only >way to do that seems to be to drop the dbspace in which the chunk resides. >But that can mean to unload the tables in it dropping everything, creating all and >loading it all again. At all a very long process just to get rid of a chunk. >Is there any other way to do that or just a way to do it in some cases ? > See ya > Udo >************************************************************* >*Udo Mueller >*database- and system administrator >*Internet: sicota@country.teuto.de >*Homepage: http://www.geocities.com/SiliconValley/2098/ Once you upgrade to 6.x or higher you will then be able to drop a chunk if it is unused. But at 5.x and lower the only way to drop a chunk is unload the tables drop the tables and dbspace and recreate the dbspace and table, then reload the tables. -- Tolly Brumbelow, Informix DBA email:tolly.brumbelow@bridge.bellsouth.com