Oninit cdi / Archive
Talk to an expert →

Drop chunk in tempdbs

Posted in 2013

Summary

Pushpa Kumara, on IDS 11.50, wanted to drop one in-use chunk from a temp dbspace while online. Art Kagel suggested dropping and recreating the whole dbspace with fewer or smaller chunks. Asked for an easier way, he said that if the chunk is in use because the tblspace tblspace was extended into it, dropping and rebuilding the dbspace is the only way.

Auto-generated by Claude from the posts below — may be imperfect; read the full thread.

Topics: Storage & Space Management

PUSHPA KUMARA — — source: IIUG Forums & Mailing Lists

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

↪ replying to PUSHPA KUMARA
Art Kagel — — source: IIUG Forums & Mailing Lists

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

↪ replying to Art Kagel
PUSHPA KUMARA — — source: IIUG Forums & Mailing Lists

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

↪ replying to PUSHPA KUMARA
Art Kagel — — source: IIUG Forums & Mailing Lists

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

Related threads

Glossary