SAP BW Largest tables - questions

[Former Member]

Hi,

We are running SAP BW 7.3 on IBM i and DB2 as database.

Recently out data load jobs are slow as compared to earlier. So I am trying to investigate reason behind the slow. When I check the largest tables in SAP BW ( note : 706478 ),  below tables result for count rows are,

1. select count(*) from R3P37DATA."RSBMLOGPAR";  3338632
2. select count(*) from R3P37DATA."RSUICDONE";  1135809       
3. select count(*) from R3P37DATA."RSBMLOGPAR_DTP";  18095417
4. select count(*) from R3P37DATA."RSBMNODES";  10941758  
5. select count(*) from R3P37DATA."RSBMONMESS";  3732044 
6. select count(*) from R3P37DATA."RSBMONMESS_DTP"; 16806561    
7. select count(*) from R3P37DATA."RSBMREQ_DTP";  54431719             
8. select count(*) from R3P37DATA."RSCRTDONE";  34247           
9. select count(*) from R3P37DATA."RSDELDONE";  141167         
10. select count(*) from R3P37DATA."RSHIEDONE";  108976         
11. select count(*) from R3P37DATA."RSLDTDONE";  1472515      
12. select count(*) from R3P37DATA."RSMONFACT";  11696563  
13. select count(*) from R3P37DATA."RSMONICTAB";  3456512   
14. select count(*) from R3P37DATA."RSMONIPTAB";  24846860
15. select count(*) from R3P37DATA."RSMONMESS";  134853315               
16. select count(*) from R3P37DATA."RSMONRQTAB";  970651   
17. select count(*) from R3P37DATA."RSREQDONE";  1389398     
18. select count(*) from R3P37DATA."RSRULEDONE";  4405766   
19. select count(*) from R3P37DATA."RSSELDONE";  1324488       
20. select count(*) from R3P37DATA."RSTCPDONE";  34247           

  select count(*) from R3P37DATA."RSUICDONE"; 1135809

As for as I know the data from RSMONI* and RS*DONE tables can be be deleted. That will give significant performance improvement.
But what about the other tables data ? Is that can be deleted ? please advice. Thanks in advance.

Regards,
Raja Subramaniyan

[biteamwcs]

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.

[Sriram2009]

Hi Raja

1.  In BW you can define retention policy for PSA & Change log table data deletion .for this refer the SCN link

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/1058b68f-96c4-2d10-fbb1-de8757ca6...

2. With help of BI consultant you can do the cube level compression it will improve your query performance. refer the scn link

3. Finally you have to perform offline reorganization as mention in the SAP Note

84081 - IBM i: Reorganization of database tables (RGZPFM)

Regards

Sriram

[Former Member]

Thanks Sriram.