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

Solman 7.1: How to reduce Database size

Hi

We installed a solution manager 7.1 SP3 for training purposes, about 3 months ago. Since then the database (MaxDB) is constantly growing, it is now at about 130GB (and rising) which we feel is too much.

I already adopted the BI Housekeeping settings which reduced DB-size by about 0,1% after the BI_HK job ran.

I already deactivated Monitoring features wihtin Solman for the connected systems.

I know that 130GB is not very much and that you normally don't reduce database size, but as it's a test system I thought there might be data that's not that critical. Also, I fear that the databse will go on growing wildly if we don't do womething against that.

Are there any other means (reports / tasks / jobs / hacks) to reduce the database size? Anything else I could deactivate (e.g. extensive logging) or activate (data aggregation, archiving) and how / where?

BR

Kanan

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Posted on Feb 02, 2012 at 02:18 PM

    hi,

    Please check if archiving is turned on in the database. You can turn off if this is a demo system.

    Check SAP note 16513

    You can find more information about this topic is available is in the

    MaxDB documentation (Note 767598) in the glossary, under the keyword

    "administration".

    Regards,

    Naveen.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 03, 2012 at 12:25 AM

    Hello Kanan,

    I have installed a Solution Manager 7.1 SP03 system, and I installed using Oracle not max DB.

    Right now the system is pretty pristine. The Database allocation is 146GB and of that allocate space I have used about 100GB

    My data base size is 146, I do not have a shortage of disk space, and the DB will autoextend should I fill it up.

    So my question would be of the 136GB what percentage is used? When you say it is growing, is it extending, or is it just

    using more of the allocated space?

    I am just now looking at a colleagues Solman 7.1 SP03 system. They have 176GB allocated to the database, but they have 104GB used. Their system has had a fair bit of use, but it is not a production system either, so it doesn't have a real world load on it.

    So typically reducing the size of the database, would entail unload the database to a flat file, resizing the database, and then reloading the database. Typically this si a DBA function.

    So I am not sure at what point a MaxDB databse would extend if you mean the physical size of the database is getting bigger. Still 136GB wouldn't be considered an unreasonable allocation as my system has 146Gb allocsated to the DB and my Colleague has

    176 GB allocated. ButI only used 100GB and they have used many scenarios and has maybe 20 users and only has used 4 GB more than me. So what is the size of the used space verus the allocation?

    You can remove various service sessions using report RDSMOPREDUCEDATA, but on a training system, I am not sure how much space that would free up. You can run a DB02 to see the allocation versus what is used, if you are not sure if 136Gb is the allocation or what space has been used. !f 136GB is the allocation, its actually low, and I suspect it is, since MaxDB tends to have a smaller foot print than Oracle. But if it is the space used and not the total allocation, then it seems very high for a training system..

    Hope this helps some.

    Regards,

    Paul

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 04, 2012 at 03:09 AM

    Kanan,

    You need to do a database reorg.

    Keeping in mind until that is done all deleting does in a data base is MARKED for deletion.

    So no space is reclaimed unitl the reorg is done and the records marked for deletion are actually deleted.

    Regards,

    Paul

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 04, 2012 at 11:07 PM

    My suggestion would be generic but really helps from an overall database size reduction in future:

    1. Try to switch the EWA reports store to a file server. Look for sap help on this.

    2. Think about a external document management system for all project documents.

    Check Note 546685 - Archiving in Solution Manager (operation)

    Srikar

    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.