Setting Parallel Processing of BW Processes

BW background management enables you to process the BW load and administration processes in parallel. You can configure the maximum number of work processes for BW processes. In parallel processing, additional work processes for processing the BW processes are split off from the main work process. The parallel processes are usually executed in the background, even if the main process is executed in dialog. BW background management is instrumental in attaining a performance-optimized processing of the BW processes. In addition to the degree of parallelization, you can specify the servers on which the processes are to run and with which priority (job class). BW background management thus supports an efficient distribution of the work processes in order to reduce the system load when processing the BW processes. Another advantage is that logs are created for monitoring the BW processes. The settings for parallel processing are stored in tables RSBATCHPARALLEL and RSBATCHSERVER.

BW background management supports most of the load and administration processes in BW. For more information, see:Process Types Supported by BW Background Management

There is one initial setting for parallel processing for each BW process type supported by BW background management. In BW background management, these initial settings are displayed for a process type as <BW Process> Without Process Chain Variant, for example Data Transfer Process Without Process Chain Variant. In the default setting, three parallel background work processes are set for the BW process types, and processing is divided among all the servers of the system. The default is 1 (serial processing) only when updating data from the PSA into an InfoProvider with PSAPROCESS.

You can change the initial setting for a process type in the BI background management. The initial setting for a BW process type is valid for a BW process of this type as long as this process has not maintained its own settings for parallelization. You can change the settings for parallelization for a BW process in the relevant maintenance dialog of the process in the Data Warehousing Workbench or in the relevant variant maintenance of the process chain maintenance. This overrides the initial setting of the process type for exactly this process. Only when the settings for parallel processing for a BW process are saved in the (variant) maintenance of the process can you display these settings in the BW background management and change them there in the central mass maintenance. The initial setting for a BW process type also appears here only if it has been changed or if settings in the (variant) maintenance of the process were saved for a process of this type.

You thus have the following options for setting parallel processing of BW processes:

• Change initial setting for a BW process type

  Here you change the setting for a process type and thus for all processes of this type for which you did not make your own settings.

• Set parallel processing for a specific BW process in the (variant) maintenance of the process

  Here you set parallel processing for a specific BW process if the setting differs from the setting for the process type.

• Set parallel processing for a BW process in the mass maintenance of BW background management

  Here you can make the settings in a table overview for all the BW processes for which parallel processing settings were already saved in the (variant) maintenance of the process.

Make sure that there are sufficient background processes (type BTC) available to process the BW processes in the system in parallel. More background work processes (approximately 50% more) are needed than without BW background management.

More information:Activating Background Processing

Change initial setting for a BW process type

1. In the Data Warehousing Workbench choose Administration → Current Settings → Batch Manager or transaction RSBATCH.

   The screen BW Background Management, Logs and Tools appears.

2. On the tab page Background and Parallel Processes in the group frame Settings for Parallel Processing, select a process type by choosing Select Process.
3. Choose Parameter Settings.

   The Settings for Parallel Processing dialog box appears.

4. Under Number of Processes, define the maximum number of work processes that should be used to process the BW process.

   If you enter 1, the BW process is processed serially.

   If you enter a number greater than 1, the BW process is processed in parallel.

   Note

   Note that a degree of parallelization (number of processes) greater than or equal to 2 means that further work processes are split off from the main process, which also monitors the work processes and distributes the work packages.

5. In the Parallel Processing group frame, make the relevant settings for parallel processing in the background:
   1. Enter a job class for defining the job priority.

      The job priority defines how the jobs are distributed among the available background work processes.

      Note

      You can define whether, and how many, background work processes for jobs of class A (high priority) should be reserved. In this case the reserved work processes are kept for class A jobs (high priority). Class B jobs (medium priority) obtain the other free work processes before class C jobs (low priority). If you do not reserve any work processes for class A jobs, first the class A jobs get the free work processes, then class B jobs, and finally class C jobs.

      When defining the job class, consider in particular the effect of class A jobs on the use of background work processes.

      More information:

      Assigning a Priority to Class A Jobs

      Rules for Work Process Distribution

   2. To distribute the processing of the BW processes optimally to your system resources, define the server(s) on which the work processes should be executed under Server/Host/Group on Which Additional Processes Should Run.

      More information:Define Load Distribution for BW Processes in Background.

6. In the group frame Parallel Processing, you can define whether parallel processing should take place in dialog work processes or in background work processes for the processes ODSACTIVAT, ODSSID and ODSREQUDEL for the DataStore object.

   If you select Dialog, you can define the load distribution of an RFC server group as Server Group for Parallel Dialog Processing.

   You can create RFC server groups in transaction RZ12. More information:Defining RFC Groups for Parallel Processing Jobs

7. To write the settings to a transport request, choose Transport. The entries in tables RSBATCHPARALLEL and RSBATCHSERVER (for hosts and server groups) are written on a transport request of the Change and Transport System.
8. Save your entries.

Set parallel processing for a specific BW process in the (variant) maintenance of the process

To overwrite the initial setting of the process type for a specific BW process:

1. Call the function for setting the parallel processes.

   You can call the function in the process variant maintenance of a process chain or in the process maintenance. The function call varies for the different BW processes. For example, in the data transfer process you call the function with Goto →   Background Manager Settings.

   The Settings for Parallel Processing dialog box appears.

2. Proceed as described above in steps 4 - 8.

Once you have saved the settings, this BW process is displayed in BW background management.

Set parallel processing for a BW process in the mass maintenance of BW background management

1. In the Data Warehousing Workbench choose Administration → Current Settings → Batch Manager or transaction RSBATCH.

   The screen BW Background Management, Logs and Tools appears.

2. On the tab page Background and Parallel Processes, in the group frame Settings for Parallel Processing, choose Mass Maintenance of All Settings for Parallel Processing.

   The Maintain Parallel Processing Settings screen appears, in which all BW processes and their settings are displayed in a table, as well as the initial settings for the process types. This user interface gives you a good overview of multiple BW processes and simplifies the maintenance for multiple BW processes.

   Note

   With Process Type Selection you can improve the clarity by restricting the display of the table to a selected process type.

3. In the corresponding columns, make the settings described above in steps 4 - 8 concerning the number of parallel work processes, the work process type, the servers to be used, and possibly the job priority. Save your entries.

The BW processes are processed according to your settings. If there is no work process free on the assigned servers for a BW process with parallel processing, it is normally processed serially.