Re: Data space reclaim
ALTER FRAGMENT ON <tablename> INIT IN <dbspace or fragmentation scheme>;
This can even be done where dbspace is the same dbspace in which the table
already resides and whether the table is fragmented or not.
The other alternatives are:
- UNLOAD, DROP, CREATE, LOAD using using your favorite unload/load method
(dbaccess UNLOAD/LOAD, sqlcmd's sqlunload/sqlreload, my ul utility, whatever.
- Create a new table with the proper extent sizing, copy the data to the new
table, drop the original, rename the new, recreate indexes and constraints.
Art S. Kagel
----- Original Message -----
From: Terrence Mu.... <terrence@wagerworks.com>
At: 2/25 18:59
> It is my knowledge that in IDS - extents that have been added to a table are
not
>
> removed/released when data is deleted. That being the case, how can you
> re-claim the
> space after you've deleted hundreds of thousands of records? Our production
> system can
> not utilize an "alter index to cluster" - Are there any other options?
>
>
>
>
>
>
>
> Terrence Mullins
> Sr Database Administrator
> WagerWorks.com