Re: Dropping a chunk
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. June -- june_t@hotmail.com Back from the dead, resuscitated by Godiva chocolates... Please do not send Informix questions to this account. 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. > > 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 */
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. > > June > -- > june_t@hotmail.com > Back from the dead, resuscitated by Godiva chocolates... > > Please do not send Informix questions to this account. > > 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. > > > > 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 */
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. > > June > -- > june_t@hotmail.com > Back from the dead, resuscitated by Godiva chocolates... > > Please do not send Informix questions to this account. > > 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. > > > > 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 */