DART 2.5 huge performance issue

[Former Member]

Friends,

We are working on DART 2.5 version of the retention tool. We have been running the jobs in back ground. However the jobs are running for days just for one fiscal period selected, where the number of entries in BKPF table shows 30,000+. The job log shows the index table records inserted to TXW_INDEX and it hangs up there.

Any advice, how we can improve? We implemented all OSS notes relavant to perforamance still the same issue? Do we need to do any server level settings, we could have missed something?

regards

Nalin.

[Former Member]

Hi,

To avoid the use of the temporary index table TXW_INDEX, set the maximum index memory allocation (extract configuration) to a value larger than the required temporary index memory. The temporary sort space is only used if the temporary index memory is below the limit set in the extract configuration

Please refer to following links.

Full detail in the following link.

[http://help.sap.com/SAPHELP_ERP2005/helpdata/EN/b1/c9eba4864811d3817500c04fadb9d6/content.htm]

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/sapnotes/index2.htm?numm=142644]

Make sure database statistics is updated regularly.

Hope this helps.

Manoj Chintawar