Data space reclaim

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

1. Save table schema -- I use myschema. 2. Unload data -- through SQL unload, onunload, or HPL. 3. Drop table. 4. Make alterations to first / next extent as needed. 5. Create table 6. Reload data. 7. Create indices and other table objects. 8. Update statistics for table. > -----Original Message----- > From: Terrence Mu.... [mailto:terrence@wagerworks.com] > Sent: Tuesday, February 25, 2003 4:38 PM > To: ids@iiug.org > Subject: Data space reclaim [499] > > > 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 > "CONFIDENTIALITY NOTICE: This message originates from WHSmith USA Travel Retail. This email message and all attachments may contain legally privileged and confidential information intended solely for the use of the addressee. If you are not the intended recipient, you should immediately stop reading this message and delete it from the system. Any unauthorized reading, distribution, copying, or other use of this message or its attachments is strictly prohibited. All personal messages express solely the sender's views and not those of WHSmith USA Travel Retail. This message may not be copied or distributed without this disclaimer."