Increase the number of datapackages from PSA to DSO

[Former Member]

HI,

This is a 7.x dataflow...We loaded 26 million records from ECC to BI in 3.5 hrs...Now when trying to load from PSA to DSO, it is really slow becuase only one datapackage is triggered or processed at a time. How can increase the number of datapackages when loading from PSA to DSO...Appreciate your inputs ASAP.

Thanks,

Ann

[sven_mader2]

you can't change the number in BW dataflow.

=> the number/the size of datapackages come from the source system.

=> it will be set in your infopackage (Scheduler -> DataS. Default Data Transfer).

>it is really slow becuase only one datapackage is

check your extractor. He must generate several datapackages.

check the routines in your bw dataload (no SELECT SINGLE, for example).

Sven

[Former Member]

It is one to one mapping all the way from the PSA to the ODS. I tried controlling RSBATCH in DTP, it did not work....

So will it work via infopackage setting? What is the recommended setting to be able to trigger 3 datapackages at a time?

Thanks,

Ann

[sven_mader2]

it's depent on the structure size.

But I think, when you have 26Mio. data you have a generic datasource and don't generate datapackages.

=> see the example from SAP: the function module RSAX_BIW_GET_DATA_SIMPLE.

1. in line 101: open a DB-cursor to read the data

2. in line 108: fetch the data with the parameter PACKAGE SIZE.

=> so, the function module started x times (through the datasource-framework) until the exeption NO_MORE_DATA (line 116) will be executed.

Sven

[Former Member]

This extract is not generic and is based on standard datasource 0FI_GL_4. Any thoughts?

[mr_v]

the number/the size of datapackages come from the source system for infopackage loads. For DTP loads u can always change.

Since this load is from PSA to DSO, u must increase data package size, under 'Extraction' tab of corresponding DTP.

In RSBATCH tcode, select 'Mass maintenance of all settings for parallel processing' for DTP_LOAD enter 3,6 etc. This number should be less than no.of BGDs in SM50.

With the above settings, when u execute DTP, 3 or 6 packages would execute in parallel.

[Former Member]

If it's a one to one mapping and doesn't have complex routines then you can increase the DTP data packet size to 200,000

OR DTP - Menu GOTO - Settings for Batch Manager - Enter number of processing to 3 and execute load