Days to Process my PSA to DSO
I have 3,793,750 records in my PSA to load to my DSO.
Those records are in 250 packages of 15175. I launched the job yesterday 4/27/2009 at 9:50 am and it has processed 190 packages. It has run for 32 hours already.
There are 12 key fields and 102 data fields.
There were very few user on the system during the load.
There are no resource contentions. There are no system bottlenecks at this point in time.
Job progress ....
The job has been spending most of its time in CPU after reading data into memory. It appears to be running single-threaded on one CPU and maxing it out at around 98%.
So my options would be:
1) break the job into smaller chunks and run then in parallel to "multi-thread". You can't get a single SAP process to run in more than one cpu.
2) to make the job run faster is to reduce the amount of data that it has to work on, if possible.
Any other ideas?