Re: Anybody have experience of online reorg tools ?

From: Eric vd Spoel <EpvdSpoel_at_hccnet.nl>
Date: Sun, 11 May 2003 22:05:52 +0200
Message-ID: <b9majq$p4q$1@news.hccnet.nl>

Neil,
I also manage SAP environments (up to 670 Gb) and I only do rebuild of indexes. This is for performance reasons only. Don't expect a lot of performance improvement by rebuilding tables. SAP over indexes it's tables anyway.
If I know that a lot of space can be reclaimed only then I do a table or complete tablespace rebuild using SAPDBA as the tool for this. Normally I use the export/import option with parallel settings for export and import.

If you need a tool? Maybe look at Quest's Live reorg.

Eric

>

> I appreciate the sentiments, but I'm managing a large number of SAP
> systems that will be generating alot of data that will (hopefully) be
> archived. The exercise is to reclaim disk space (some of the systems
> are growing by at an alarming rate). I appreciate also that this is an
> application issue, but it is unlikely that that will be resolved in
> the short term. Mid to long-term there will be a need to keep these
> datbases down to manageable sizes.
> Regards,
> Neil.
Received on Sun May 11 2003 - 15:05:52 CDT