Skip to Content
0
Former Member
Apr 12, 2013 at 09:50 AM

BWA ROLLUP TAKING WAY TOO LONG NOW

145 Views

Hi Friends,

I have two questions that I need help in which will help me determine why (all of a sudden) my roll up process started taking long time to load data into BWA. Previously it use to take 10 mins to roll up 500,000 records but now it is taking 2:30 hours to do the same things.

  1. While roll up data, systems does read, update and delete on RSDDTREXNEWSID table (which has about 300,000 records). Should I buffer this table to speed up the process?
  2. What should be the values for Batch and NUMPROC under RSDDTREXADMIN table? How much max can we go?

Any input will be greatly appreciated!!!!

Thanks

Raj