Skip to Content
0

Refresh database size (BW)

Oct 18, 2016 at 03:26 PM

96

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Ashish Lakdawala Nov 01, 2016 at 07:36 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Harish Karra Oct 25, 2016 at 02:02 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Reagan Benjamin
Nov 01, 2016 at 09:59 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded