Skip to Content

This document is in continuation to section 2.1 of Performance Improvement of Data Selection and Data Transfer Activities in SAP TDMS 4.0


Objective:

Basic object of this document is to explain steps to enable parallelization of data selection of any migration object in TDMS 4.0 on top of DMIS SP09 and above.

Introduction:

By default, the Data Selection activity runs a single work process to select data of a migration object in sender system.

By enabling the parallelization of data selection, you can schedule multiple work processes for access plan calculation, that is, to select the data of a migration object according to:

  • The number of records in the application table for flat migration objects. (A flat migration object only contains one table.)
  • The number of records in the TDMS header table for header migration objects.

Steps to Enable Parallelization:

  1. Make an entry for a migration object in the table CNVMBTPRECALCOBJ using the view V_CNVMBTPRECALC.
  2. Specify the following values:
  •      Name of the header table if it is a structured or header migration object. This field must be left blank if it is a flat migration object.
  •      Delimiter value — maximum number of records that a single process should handle
  •      Name of the migration object

In case “Generation of Runtime Objects” activity is already executed in your package. You need to perform following additional steps too after performing among mentioned steps:

  1. In case data selection job is running for given object, you need to cancel this job from sender system via tcode sm37.
  2. You need to force redefine migration object using troubleshooter available against  “Start Data Transfer” activity. it will regenerate objects as per above mentioned configuration setting.


NOTE: There is no need to set P_SEL for any fill header program.

Example:

The number of records in the TDMS header table CNVTDMS_05_BKPF is 10 million. (You can find this information in the logs of the corresponding TDMS header activity.)

You want to schedule 5 batch jobs for the data selection of the migration object X_BKPF. In this case, delimiter value should be 2 million and header table name should be CNVTDMS_05_BKPF.

Points to be Noted:

  1. A significant load is placed on the database server of the sender system when multiple processes run for selection on the same table. Thus, number of jobs configured for parallelization of a given migration object should be maximum 20.
  2. Migration object configured for parallelization of selection should NOT have more than 2 tables to achieve better performance results.
  3. Parallelization should NOT be configured for migration object dealing with pool tables.
To report this post you need to login first.

2 Comments

You must be Logged on to comment or reply to a post.

  1. neeha reddi

    Hi Amit,

     

    Thanks for sharing your knowledge in the form of a quick blog.  BTW, as its been 2 years since you wrote this, can I ask few things – if you or Devendra is still working on TDMS.

     

    1. What is the latest version / component of TDMS?  ( for installation )
    2. Is it a part of Solman 7.2 or a diff license? please throw some light on the installation/ activation process
    3. Is there a new version that caters to both the old ECC and the Future S4HANA?
    4. Anyone worked on S4HANA data migration/extraction? if so- can you share any step by step process document
    5. Can someone share any process document with screenshots/ step by step, or any video recording- showing the migration/extraction process of data from ECC, CRM, HCM, BW/BI, SRM, SCM etc., like systems and that also shows some scrambling/masking techniques?

    Appreciate your help in advance for sharing your knowledge.

     

    Neeha.

    (0) 

Leave a Reply