Skip to Content
author's profile photo Former Member
Former Member

database size grow quickly

hi,

we are facing a problem with the datebase size wich are growing so fast (>150 Mo) compared to the installation and the volume of data we have.

we have ~ 15 infocube/ODS: 3 are configured with the full update method, 12 are delta updated.

have you any idea that can help us solve this problem?

Thank you.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2007 at 11:37 AM

    Hi,

    Are you uploading through PSA?

    Delete all PSA:

    Of full loads after 3 days or one week.

    Of delta's after 30 to 90 days.

    Udo

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      Thank you for your anser Udo, yes we are uploading through PSA, but i think there same automatic cleaning of the PSA, because db02 show me that there is also regularly decrease of the size of the PSA tables !

  • author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2007 at 12:41 PM

    If you are sure about PSA (is the first reason of uncontrolled grow).

    Check how many request you have in the infocube and the average record per request. Probably you need the Compression of the InfoCube.

    Records that had been uploaded with the same key may be contained in an InfoCube several times but with a different request ID. This differentiation is necessary to be able to delete single requests out of an InfoCube after they have been uploaded.

    http://help.sap.com/saphelp_nw04/helpdata/en/ca/aa6437e7a4080ee10000009b38f842/frameset.htm

    Chack also the aggregates, but compression reduce also aggregates.

    Reagrds,

    Sergio

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.