Dropping a chunk ✗ Answered: red (solid confidence) — After the asker confirms the drop fails with 'chunk not empty' despite the tblspace showing as a phantom, David Williams only names it a 'known bug in certain versions' with no version specifics, workaround, or fix; the other repliers punt to Informix Tech Support.

Advisory only.

I want to drop the chunk featured below, but it has a phantom tblspace in it. Does anyone have a foolproof method of eliminating the recalcitrant tblspace, with recourse to informix Tech Support? thanks Neil Chunk: 18 /opt/informix/dbspaces4/catsdbs_2 Size Used Free 51200 53 51147 Disk usage for Chunk 18 Start Length ------------------------------------------- --------- --------- OTHER RESERVED Pages 0 2 CHUNK FREE LIST PAGE 2 1 FREE 3 36645 TBLSPACE TBLSPACE 36648 50 FREE 36698 14502

Neil Truby wrote: > > I want to drop the chunk featured below, but it has a phantom tblspace in > it. Does anyone have a foolproof method of eliminating the recalcitrant > tblspace, with recourse to informix Tech Support? > > thanks > Neil > > Chunk: 18 /opt/informix/dbspaces4/catsdbs_2 Size Used > Free > 51200 53 51147 > > Disk usage for Chunk 18 Start Length > ------------------------------------------- --------- --------- > OTHER RESERVED Pages 0 2 > CHUNK FREE LIST PAGE 2 1 > FREE 3 36645 > TBLSPACE TBLSPACE 36648 50 > FREE 36698 14502 As far as I know, the chunk should drop with no problems. Is the drop giving you an error?? -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */

>As far as I know, the chunk should drop with no problems. Is the drop >giving you an error?? Yes, chunk not empty. Carlson@WHSmith wrote in message <3870D479.A7227C6E@bellsouth.net>... >Neil Truby wrote: >> >> I want to drop the chunk featured below, but it has a phantom tblspace in >> it. Does anyone have a foolproof method of eliminating the recalcitrant >> tblspace, with recourse to informix Tech Support? >> >> thanks >> Neil >> >> Chunk: 18 /opt/informix/dbspaces4/catsdbs_2 Size Used >> Free >> 51200 53 51147 >> >> Disk usage for Chunk 18 Start Length >> ------------------------------------------- --------- --------- >> OTHER RESERVED Pages 0 2 >> CHUNK FREE LIST PAGE 2 1 >> FREE 3 36645 >> TBLSPACE TBLSPACE 36648 50 >> FREE 36698 14502 > >As far as I know, the chunk should drop with no problems. Is the drop >giving you an error?? >-- >John Carlson >Informix DBA >WHSmith USA > >#include std_disclaimer.h /* These are my opinions, not my company's >opinion */

Neil Truby wrote: > > >As far as I know, the chunk should drop with no problems. Is the drop > >giving you an error?? > > Yes, chunk not empty. > Hmmmm, I don't get this one . . . looks like one for Tech Support. -- John Carlson Informix DBA WHSmith USA #include std_disclaimer.h /* These are my opinions, not my company's opinion */

In article <84qu0e$d0u$1@taliesin2.netcom.net.uk>, Neil Truby <ntruby@netcomuk.co.uk> writes >>As far as I know, the chunk should drop with no problems. Is the drop >>giving you an error?? > >Yes, chunk not empty. > Known Bug in certain versions. >Carlson@WHSmith wrote in message <3870D479.A7227C6E@bellsouth.net>... >>Neil Truby wrote: >>> >>> I want to drop the chunk featured below, but it has a phantom tblspace in >>> it. Does anyone have a foolproof method of eliminating the recalcitrant >>> tblspace, with recourse to informix Tech Support? >>> >>> thanks >>> Neil >>> >>> Chunk: 18 /opt/informix/dbspaces4/catsdbs_2 Size >Used >>> Free >>> 51200 53 >51147 >>> >>> Disk usage for Chunk 18 Start Length >>> ------------------------------------------- --------- --------- >>> OTHER RESERVED Pages 0 2 >>> CHUNK FREE LIST PAGE 2 1 >>> FREE 3 36645 >>> TBLSPACE TBLSPACE 36648 50 >>> FREE 36698 14502 >> >>As far as I know, the chunk should drop with no problems. Is the drop >>giving you an error?? >>-- >>John Carlson >>Informix DBA >>WHSmith USA >> >>#include std_disclaimer.h /* These are my opinions, not my company's >>opinion */ > > -- David Williams