Parallel load in BW uses all work processes in the system

[Former Member]

Hi All,

When I run a parallel load it ends up grabbing all the work processes in the system.

The load uses all available dialog work processes in the system literally hosing up the system and making it unresponsive. How can I ensure that the parallel load uses only a certain number of work processes.

Thanks

Karen

[Former Member · Accepted solution]

Hi Karen,

The number of workprocess (Dialog/Background) could be reduced also by selecting the loading options in InfoPackage.

In InfoPackage Processing tab, there are various loading options,

PSA & Then into data target (Package by Package) - This option uses only one process at a time. One data package is lifted from the Source System by a background process to PSA, and then the same process lifts it from PSA to datatarget.

PSA & data target in parallel (Package by Package) - This option uses two process at a time. One data package is lifted from the Source System by a background process to PSA, and then another process lifts it from PSA to datatarget. The first process same time, gets busy in lifting another package from Source System to PSA.

The first option is good, but takes more time to load data than the second one, so there is a tradeoff.

Also it is good if you use another process in process chain to activate the ODS instead of setting it up on automatic activation.

Please let me know if you need any more help.

Regards,

Pankaj

[Former Member · Accepted solution]

Hi Pankaj

Thanks for explaining this I use option 2 (PSA And data target in parallel) I load from a ODS to a cube.

Thanks to Srini I have set the RSCUSTA2 to 3 but despite it when I start a parallel load from a ODS to a cube it ends up grabbing all available work processes. I am not sure how I can prevent it from grabbing all available dialog work processes.

Thanks

Karen

[Former Member · Accepted solution]

Hi,

There is no way to restrict the number of processes the parallel loads use. You have to either reduce the number of parallel processes or get the BASIS team to increase the processes in BI :).

Regards,

Pankaj

[Former Member · Accepted solution]

Karen,

To load PSA and ODS in parallel system needed 2 processes.

One process to activate data

One process to create change log.

Check at SM50 / 51, what all processes are related to any particular loading.

Srini

[Former Member · Accepted solution]

Hi Karen,

Forgot to mention, to reduce the number of processes please use the option1.

Regards,

Pankaj

[Former Member · Accepted solution]

Hi Karen,

The maximum number of parallel processes for the data transfer is defined by MAXPROCS field of ROIDOCPRMS table in source system. To correct it either run SBIW->General Settings->Maintain Control Parameters for Data Transfer or edit the table field directly.

Regards,

Alexander

[Former Member]

Hi,

Wht type of parallel load it is? Is it bkg or dialog...?

In ur case y can't u increasse ur work processes....contact basis reg the same....

--

rgds,

[Former Member]

Sure I know to ask for more work processes with Basis - but that is not what I want to do.

Karen

[Former Member]

Karen,

You can reduce no. parallel process for loading into ODS. TCode: RSCUSTA2.

Try to calculate & define no of parallel processes and design process chain parallel or sequential based on no of availability of dialogue and background processes at Peak & Off Peak times.

Check: [SAP BW Data Load Performance Analysis and Tuning|https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3a699d90-0201-0010-bc99-d5c0e3a2c87b]

Srini

[Former Member]

Hi,

If u run the laod in BI system thru infopackage which the data is from R/3..then goto IP scheduler..in the scheduler menu u have the option of data defaults data transfer....if u got there u'll get the no of dialog processes...to adjust this also u need to be authorized....or basis can do this...

And also If u run a load thru DTP which is nothing but the load in BI system...goto respective DTP and double click and in menu options->GOTO->settings for batch manager-->there also u can adjust ur parallel processes and save.....

For ODS activation steps u can adjust processes using RSODSO_SETTINGS.

For any bkgrd job u can adjust the processes at the time u define a variant itself...

--

rgds,