Large D010TAB, REPOLOAD, REPOSRC

[gerhard_rmer]

Hi there,

I found out that the following tables are very large in our BW system:

D010TAB

REPOLOAD

REPOSRC

I also found the SAP note 706474 mentioning those tables. However the SAP note stated there 1582301 contains a program which is working only for MaxDB. We hare an oracle DB.

Therefore my questions is, whether someone can tell me if there is a similar program for oracle DB.

Had someone the same problem and solved it?

Best regards,

Gerhard Römer

[RafkeMagic]

hey Gerhard,

search on "BW Housekeeping" and you'll find ways of reducing (certain) large tables in BW systems... not sure those 3 tables can be reduced though. And I'm not behind a BW system right now to double-check :-S

Cheers,

Raf

[gerhard_rmer]

Hi Raf,

thank you for your hint with "BW Housekeeping".

However, eventhough I executed the ABAP report SAP_DROP_TMPTABLES in order to delete temporary tables and generated reports, we still have a lot of generated reports in table REPOSRC.

So, this report unfortunately doesn't help in my case.

Is there another report which deletes generated reports, which are not needed anymore, from tables REPOSRC, REPOLOAD and D010TAB.

Regards,

Gerhard

[RafkeMagic]

well by "not sure those 3 tables can be reduced though" I kind of meant "chances are big those tables cannot be reduced"

I've archived/cleaned up a fair share of tables in BW systems in the past few years, and those were never part of that operation

[gerhard_rmer]

As I stated above, there is an SAP Note (1582301) saying that you can delete temporary reports from this tables. However, this note is only for MaxDB. My assumption is that there should be something similar for oracle DB which I haven't found yet.

[RamanKorrapati]

Hi,

Not sure whethers its belongs to basis or bw. but if you check with your basis consultant. he may helps You. or check at basis forum. you may get asap help.

http://scn.sap.com/community/netweaver-administrator

Thanks

[gerhard_rmer]

Hi,

this is a BW topic since these tables are only in our BW system that large. I guess that some temporary BW reports are not deleted properly. Just like mentioned in SAP note 1582301. But since this note is only for MaxDB, I am not sure whether I am right.

Thanks.