Can't drop dbspace

Hi all I created a dbspace to do some reorg work - I used it to ALTER FRAGMENT some tables into it, then back out again, so it's now empty, but onspaces won't let me drop it - I get the error "cannot drop first chunk". It's the one and only chunk. What could be causing this? Cheers Jon.

Jon Myatt wrote: > > Hi all > > I created a dbspace to do some reorg work - I used it > to ALTER FRAGMENT some tables into it, then back out again, > so it's now empty, but onspaces won't let me drop it - I get > the error "cannot drop first chunk". It's the one and only > chunk. What could be causing this? What do onstat -d and oncheck -pe show? Art S. Kagel

Jon Myatt wrote: > > Hi all > > I created a dbspace to do some reorg work - I used it > to ALTER FRAGMENT some tables into it, then back out again, > so it's now empty, but onspaces won't let me drop it - I get > the error "cannot drop first chunk". It's the one and only > chunk. What could be causing this? > > Cheers > > Jon. I've seen this error...it should probably read, "cannot drop last remaining chunk". When you only have one chunk left making up the dbspace, the command to drop it is: onspaces -d [dbspacename] ....no pathname to the chunk or offset specified. You are actually dropping the dbspace. Bug warning: In version 7.24.UC5, and maybe other versions, if the dbspace your dropping resides in extended reserve pages, the drop command will free up the disk space used by the dbspace in question. onstat -d will not show the dbspace after dropping it.But the reference to the dbspace in the extended reserve pages remains. This can cause numerous problems.... Martin Birecki mbirecki@us.dhl.com

> What do onstat -d and oncheck -pe show? Here's the (relevant bits of) onstat -d: Informix Dynamic Server Version 7.30.UC3 -- On-Line -- Up 12:25:02 -- 839136 Kbytes Dbspaces address number flags fchunk nchunks flags owner name 6041d9c8 44 1 126 1 N informix jontemp Chunks address chk/dbs offset size free bpages flags pathname 6040f3d8 126 44 1 204799 204746 PO- /dev/informix/prd6/jontemp 126 active, 2047 maximum And here's oncheck -pe for the dbspace: (note the 53 used) DBspace Usage Report: jontemp Owner: informix Created: 01/19/99 Chunk: 126 /dev/informix/prd6/jontemp Size Used Free 204799 53 204746 Disk usage for Chunk 126 Start Length ------------------------------------------- --------- --------- OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 TBLSPACE TBLSPACE 3 50 FREE 53 204746 Jon.

> I've seen this error...it should probably read, > "cannot drop last remaining chunk". When you only > have one chunk left making up the dbspace, the > command to drop it is: > > onspaces -d [dbspacename] Ahhh! Right - I'll try this. > Bug warning: In version 7.24.UC5, and maybe other > versions, if the dbspace your dropping resides in > extended reserve pages, the drop command will > free up the disk space used by the dbspace in question. > onstat -d will not show the dbspace after dropping it.> But the reference to the dbspace in the extended > reserve pages remains. This can cause numerous problems.... Eek. I've seen something very similar to this before. And yes, it caused me immense problems! Thanks, Jon.