dattark 01000011FV18 Posts
Re: reclaiming space2014-04-23T18:29:57ZThis is the accepted answer. This is the accepted answer.
I assume you are looking to reclaim disk space used by the tablespace backed by a single container (device or file).
AFAIK, in DB2 LUW , there is no way to reorg a tablespace such that the disk space used is reduced. Try the db2dart command and look at it's recommendations.
The only option that I know of is export data from table, drop and recreate tablespace and tables, and import back in the data. Good luck, when you do this, have good backups, and watch for "nil" (not null) errors in db2diag.log when reimporting data.
If you have a DMS tablespace that has multiple containers, you can monkey with options like rebalancing, dropping a file etc, but have not tried that route.
gdevelek 060000M5DD4 Posts
Re: reclaiming space2014-04-24T08:52:43ZThis is the accepted answer. This is the accepted answer.
- dattark 01000011FV
Thanks for answering, I had lost hope.
Let me clarify: I don't need to get diskspace back, it's not necessary. What I need is to be able to REUSE the space that was released when I set those BLOBs to null. When I say "reuse" I mean by inserting new rows.
If this happens I'll be happy.