BDLS performance - how to speed up BDLS run?

[Former Member]

Hi all,

Although my database is not huge (1.5Tb), BDLS run takes a lot of time - 26 hours

I found very nice blog - /people/hari.peruri/blog/2006/11/01/execute-conversion-of-logical-system-names-bdls-in-short-time-and-in-parallel--intermediate, but since I have Basis 6.40 - it is not suitable for me.

I tried anyway - got inconsistency, I had to implement note 962674

I guess my only workaround is to use the old program RBDLS2LS ..

Any ideas how else I can speed up bdls run?

Many thanks in advance,

Best regards, Elena

[Former Member · Accepted solution]

Hi Elena

What possibly can be done in such a case could either be a reorganisation of the tables that are accessed at the database while running the transaction BDLS or customizing the source code of the program RBDLSMAP (used while calling BDLS transaction) such that the no. of accesses to some not so important tables get reduced.

for e.g. say after a refresh ,if we Consider taking out some table such as the infamous PA2* tables (if using HR)

and send this in the background, it will go faster because the TEST phase is ignored. you might save about 2 hours just with that.

Regards

Chen

Edited by: Chetan Seth on Feb 19, 2009 4:36 PM

Edited by: Chetan Seth on Feb 19, 2009 4:37 PM

[Former Member]

Hi,

check out following link.

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

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

Manoj

Edited by: Manoj Chintawar on Feb 20, 2009 4:56 PM

[Former Member]

Don't know if you have tried it but have you updated the table statistics recently (at the DB level)?

Just wondering,

J. Haynes

[Former Member]

Hi Joe,

yes, statistics is fresh

Best regards, Elena

[Former Member]

speed it up. follow the advice given here:

http://www.sapfans.com/forums/viewtopic.php?f=12&t=324759