We plan to use the BXM utilities for our initial load (approx 25 mil records). I am testing it for a a sample of 1.3 mil records. After Weight generations, threshold adjustments, I am now executing the mpxlink utility. The mpxdata and mpxcomp completed in no time. However, the mpxlink is running for more than 24hrs now. This is surprising given that mpxcomp completed in just abt an hour's time.
1. I dont see any system resources as bottleneck (have monitored the CPU and memory mgmt and they seem pretty ok).
2.From the logs, I see that the bxmtask of the mpxlink is the culprit. Not sure what it is doing. So far it says that it has processed more than 30mil records. This step started abt 22 hrs ago. I do know that we are expecting a lot of tasks (this is as per design).
3. Is it normal (such long running mpxlink task). If for 1.3 mil source records it takes this long, for 25 mil, would it take weeks to complete (assuming the sample is the right representation of the entire dataset).
Can someone kindly help me please?