Skip to Content
avatar image
Former Member

Refresh database size (BW)

Hi Experts,

Hope someone could give me a light here. It´s more a question about basis but hope any experienced before. I have a environment which we made a copy (BW 7.1) to a new environment, basically we are using the same settings, Operational system (AIX), Database is DB2 however since we are proposing a new environment we are not bringing or using all the DSOs, Cubes and MP so many of them are or empty or were not brought at all, however we still see that we have a huge database for just 1 year of existence of this new environment and I was wondering, although all the attempts to reduce the size by performing housekeeping and cube compression, the size never gets low. I was wondering if there is any process or routine that the Basis or DBA folks have to execute to have the resizing, I mean, a way to tell to the system that he needs to recalculate the size and adequate the tables, is there anything like that?

by the way, we have BW 7.1 but couple of the objects are still on 3.x

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Nov 01, 2016 at 07:36 PM

    Hello Mate,

    Please go to

    DB02OLD and refresh the statistic by using Refresh > DB Checks & update histories.

    Make sure that you have enough authorization to refresh it.

    Incase of still you face issue then check below note.

    check the Note 1002840 - No data or obsolete data in DB Space Statistic monitor

    Regards,

    Ashish Lakdawala

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 25, 2016 at 02:02 PM

    Hi Rodrigo,

    It needs a detailed analysis as we cannot just comment by looking at the query.

    Best place to start your analysis is EWA. First you need to look at the top tables (in size) and the fastest growing tables so that you can come to know which type of data is causing to rapid DB growth.

    Regards,

    Harish Karra

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 01, 2016 at 09:59 PM

    There are couple of options. Once the housekeeping is done, you can ask the BASIS to do a system refresh using the export / import method. Other than that there is a report called DB6CONV which lets you perform table move online.

    Add comment
    10|10000 characters needed characters exceeded