Re: Dropping a chunk

June Tong wrote: > > Mark D. Stock wrote: > > > Darin Tracy wrote: > > > > > > You will not be able to drop this chunk. This chunk is obviously not the > > > first chunk of a dbspace. It is a secondary chunk within a dbspace. > > > The tblspace tblspace had to extend into this chunk and because of this > > > you will now not be able to drop this chunk. > > > > > > Darin > > > > > > June Tong wrote: > > > > > > > Well, it could be a bug, as some people have suggested (I don't know of such a > > > > bug, but then I wouldn't anymore), but are you sure the tblspace tblspace is > > > > empty? Since you have a tblspace tblspace extent in this chunk, it is possible > > > > that a tblspace page is located in this chunk, even though the table which it > > > > references is *not*, and therefore you would be unable to drop the chunk. In > > > > fact, even if the tblspace tblspace *is* empty, I'm not sure you can drop the > > > > chunk, as long as the extent is there. > > > > No, come on people. June should know better, but I guess she's been away > > tooo long. :-) > > > > Of course you can drop a chunk with a tablespace tablespace in it. Even > > when an extent is empty, it is not removed. If you've ever worked with > > Baan long enough, you come to expect EVERY chunk to contain a tablespace > > tablespace. ;-) > > Well, I certainly have been away a long time... When I left Informix, I don't think > you could drop a chunk out of a dbspace that wasn't empty; I believe that functionality > was added to the first release that came out after I left. So I certainly don't know > whether there is a restriction on dropping chunks if empty tblspace tblspace extents > reside in the otherwise empty chunk. > > But in this case, I am simply pointing out that just because the chunk is empty, we > don't know for sure that the tblspace tblspace extent in this chunk is empty. We only > saw the oncheck -pe listing for this one chunk; other chunks in the dbspace may still > contain tables and this tblspace tblspace extent can hold tblspace pages for tables > which are in this dbspace but located in other chunks of the dbspace. In this case, > you certainly could not drop the chunk. Mark, I'm surprised at you. Well having re-read your 1st post, you said it just as clearly, so I guess I didn't read it fully. Sorry. :-) I was just pointing out that just because a chunk contains a tablespace tablespace, it doesn't mean you can't drop it, notwithstanding your very valid point of course. ;-) Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+