Drop chunk in tempdbs

Hi, i have informix ids 11.50 server and it's online now i need to drop one chunk in tempdbs but when i'm try to drop it it's say's it's using onstat -d show it's used some size so is there any way to drop it while server in onlie note:- my tempdbs has more chunks and i have two temp dbs Thanks Pushpa

The quickest way may be to drop the entire tempdbs dbspace then recreate it with fewer or smaller chunks. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Mar 20, 2013 at 4:58 AM, PUSHPA KUMARA <pushpa@cybersoft.lk> wrote: > Hi, > > i have informix ids 11.50 server and it's online now i need to drop one > chunk > in tempdbs but when i'm try to drop it it's say's it's using onstat -d show > it's used some size so is there any way to drop it while server in onlie > > note:- my tempdbs has more chunks and i have two temp dbs > > Thanks > Pushpa > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --e89a8fb1f282fddce104d858a5a0

Hi, Thanks for the reply first. i need to drop only on chunk from one temp dbs so is there any eazy way to do it. Thanks Pushpa

Yes. The easy way is to just drop that chunk, but you cannot do that if the chunk is in use. If the 'in use' was caused by the dbspace's TABLESPACE TABLESPACE being expanded with an extent in that chunk, then the ONLY way is to drop the whole dbspace and rebuild it again without the chunk you wanted to free. It's not only the easy way, it's the ONLY way. Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Mar 20, 2013 at 7:24 AM, PUSHPA KUMARA <pushpa@cybersoft.lk> wrote: > Hi, > > Thanks for the reply first. i need to drop only on chunk from one temp dbs > so is there any eazy way to do it. > > Thanks > Pushpa > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --bcaec54d3f84aafb3404d8599a02