Skip to Content
author's profile photo Former Member
0
Former Member

Increase the parallel processing during extraction

Posted on Nov 29, 2007 at 12:39 PM 415 Views

How can we " Increase the parallel processing during extraction " .

We need this as we are facing with the problem of long running hierarchy loads.

Please give inputs on this issue as we are our "Master data loads Process Chains" have been running for more than 6 hours.

Regards,

Venkat.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 12:45 PM
    1

    Hi Venkat,

    You can increase the number of parallel processors by maintaining the following setting.

    Go to SBIW -> General Setting -> Maintain control parameters for data transfer

    In this setting 'Max. proc' field contains maximum no of work processors to be used. Hope this helps.

    Regards,

    Sumit

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 04:16 PM
    1

    In SE11-> Table-> ROIDOCPRMS. This table is to view Maximum number of parallel processes for data transfer.

    Regards,

    Malar

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 29, 2007 at 10:31 PM
    1

    Hi,

    Best practice for data loading

    http://h71028.www7.hp.com/ERC/downloads/4AA1-3428ENW.pdf

    large data handing

    https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/d56bbf90-0201-0010-53aa-923512127968

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member
      Nov 30, 2007 at 02:15 AM

      The HP document that SAP_learner provides a really good BW performance article. They are talking about a Windows environment, but much is applicable to other platforms.

      You don't say what version you are on, with 7.0 the Batch Manager can control a number of parallel options - tran RSBATCH.

      You really need to identify which loads are running long - no point in throwing parallel processing at small loads - could actually be counter productive. Then review the detail in the Load Monitor - is it the extraction that is running poor, the trans/update rules, or the actual load. Or is Change run the culprit.

      You don't say anything about how many master data loads you run concurrently. Rather than trying to using parallel processing, is there any reason you can not run more concurrently. In some of my MD process chains, I load a dozen MD objects concurrently. I think that is a better approach and probably provides you better control over resource consumption, on both the BW and R3 sides..

Before answering

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.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.