Runtime Parameters of DataStore Objects 

...

To improve performance when processing data in the DataStore object, you can make a number of settings for each DataStore object in the runtime parameters or maintain general default values for DataStore objects. You navigate to runtime parameter maintenance either in Customizing by choosing SAP Customizing Implementation Guide → SAP NetWeaver → Business Intelligence → Performance Settings → Maintain Runtime Parameters of DataStore Objects or in the Administration area of the Data Warehousing Workbench by choosing Current Settings → DataStore Objects.

You can define the following:

Parameters for activation:

●      The minimum number of data records for each data package when the data in the DataStore object is activated. In this way, you define the size of the data packages that are activated.

●      The maximum wait time in seconds when data in the DataStore object is activated. This is the time that the main process (batch process) waits for the split process before it determines that it has failed.

Parameters for SID generation:

●      Minimum number of data records for each data package when SIDs are generated in the DataStore object.

●      Maximum wait time in seconds when SIDs are generated in the DataStore object.

Parameters for rollback:

●      Maximum wait time in seconds for rollback in the DataStore object.

Process parameters:

●      Type of processing: serial, parallel (batch), parallel (dialog)

●      Maximum number of parallel processes

●      Server group to be used for parallel processing of data in DataStore objects. You have to create the server groups first using the following path: SAP Easy Access  → Tools  →   Administration  →  Network  →  RFC Destination, RFC  →  RFC Groups. If you do not specify anything here, processing runs on the server on which the batch activation process was started. If a server in the server group is not active, processing is terminated.

More information: Performance Optimization for DataStore Objects.