Skip to Content
avatar image
Former Member

ROOSPRMS vs ROIDOCPRMS

Hi,

For a data load from an ODS to Info cube in BW 3.5 systems I want to use more system resources to achieve better performance.

My question is that I can maintain the control parameters either in SBIW/ROIDOCPRMS at a global level or in ROOSPRMS for individual datasources.

Which one will supercede or they are totally different settings altogether??

What other parameter considerations can help?

Please help.

Regards,

Ranjeet

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jun 01, 2009 at 06:47 AM

    Hi,

    Size of DataPackages: Influencing Factors

    - Specific to application datasource, the contents and structure of records in the extracted datasets.

    - Package size: impacts frequency of COMMITs in DB .

    - SAP OSS note 417307: Extractor Packet Size Collective Note for SAP Applications

    - Consider both the source system and the BW system (RSADMINC).

    - Package size specified in table ROIDOCPRMS and/or InfoPackages

    Check this documents:

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

    2. [Performance Tuning For SAP BW|https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/10fb4502-111c-2a10-3080-df0e41d44bb3]

    Examples can be found in SAP note 409641 (Examples of packet size

    dependency on ROIDOCPRMS).

    Additional check this links (regarding ROIDOCPRMS):

    Regards

    Andreas

    Add comment
    10|10000 characters needed characters exceeded