Skip to Content
author's profile photo
Former Member

Sequential read of DD03L table is taking forever during SP install

Hello SDN

I'm applying some SP to my vanilla ECC install with Max DB.

Whenever I apply another set of SP or even SPAM update it inevitable hits a sequential read of table DD03L. And it takes forever to go throught it. It is a 1.5 Gb table.

I updated statistics for the DB in DB50 and applied notes 791984, 1015068 and 1022755 as described in note 822379.

I am running the latest kernel, dw set, tp and r3trans files

I still need to apply the whole Stack 7 and 8 for the whole ECC 6.0 and I'm afraid the table will keep growing.

Has anyone ran into the same issue?

Any suggestions how to make this process faster?

Thanks

MR

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on Sep 27, 2007 at 09:00 PM

    Hey,

    The table DD03L is quite large,

    however the upgrade should not take forever.

    I think you should create a DB trace,

    and find the problematic SQL statements,

    When you have those long running statements,

    you might be able to improve their performance (for example, create an index).

    Add comment
    10|10000 characters needed characters exceeded