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/
Hi Udo!
If you are on version 5.xx, there is no way to drop a chunk, you
have to drop the whole dbspace.
In version > 6 you can drop empty chunk using
onspaces -d spacename -p pathname -o offset.
Mirek
--
=================================
Miroslav Lorenc
Database Administrator
Software Applications and Systems Internet: Miroslav.Lorenc@sasprg.cz
Tiskarska 10/257
108 28 Prague 10 Tel: +42 2 705134
Czech Republic Fax: +42 2 705128