Skip to Content
avatar image
Former Member

BDLS performance - how to speed up BDLS run?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Feb 19, 2009 at 03:36 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 20, 2009 at 04:01 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Feb 04, 2009 at 10:28 PM

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

    Just wondering,

    J. Haynes

    Add comment
    10|10000 characters needed characters exceeded