DB statistics take long time to run during change run and roll up
After addin more and more aggregates to the cubes, it becomes tough to estimate when the load would finish, as sometimes the Attribute Change Run takes 10 min to run, sometimes, 2 hours.
There are many ways to deal with it. For example, reduce the percentage of DB statistics calculation, switch off the aggregates…
The following SAP OSS note might help. But need to be careful with the warnings in the same note.
You can deactivate the DB statistics initiated by the BW system by making the following entry in the RSADMIN table. You can use the SAP_RSADMIN_MAINTAIN ABAP report to do this:
-
- Object: DB_STATISTICS
-
- Value: OFF
Note that the RSADMIN table is buffered. You should execute a/$tab RSADMIN (invalidates buffers for RSADMIN) or /$sync(invalidates all table buffers) command afterwards.
0 comments:
Post a Comment