cancel
Showing results for 
Search instead for 
Did you mean: 

EDI40 and Reorg

Former Member
0 Kudos

We have EDI40 in ECC50 (R/3) that had grown to about 150 GB. We archived / purged Idocs and now are in process of reclaining the unused space used by EDI40. We are on Oracle 9i moving to 10G. Have anybody performed reorging on a large "Raw" datatype table? We cannot afford downtime more then a few hours. Any insight would be helpful.

Thanks,

Amit

View Entire Topic
Former Member
0 Kudos

Hello Amit,

We have re-organized IDOC tables many times; I have used BMC re-organization tools where you can switch the tables with less down time (online reorgs). At my current environment we are using Quest re-org tool and we have recently switched for EDI40.

If you don't have any re-org tools, you might need down time to do this re-org. To answer your question, you might need quiet time to do re-orgs if you are not using online re-orgs.

Hope this helps.

Thanks,

Hari Peruri

Former Member
0 Kudos

Thank you for your quick response. I have a few follow-up questions. If you can answer them I would really appreciate it...

1. How large are your tables and how active is your system

2. how much overhead is incurred (i.e. mainly disk space, and load on the system)during these reorgs?

3. How much time it takes on an average for such a re-org?

4. Do you have any idea on how much this table was compressed?

Any help / answer would help us determine the right tool set we may have to use.

Thanks,

Amit

Former Member
0 Kudos

Hi Amit,

If you do reorganizations with an external (non-sapdba) tool, make sure you consider sap note 154193. Re-collect statistics with brconnect (not SAPDBA as the note suggests). The key piece of information is that if you do tablespace reorganizations (change table location, i.e., into new tablespace), you need to update the ABAP Dictionary table, dd09l, and re-collect statistics.

Good luck!

Paul