Drop insert in receiver system with multiple clients

[former_member640444]

Hello,

does TDMS handle drop-insert technology in a multiple client receiver system automatically?

What can be the impact for the other clients when they are working while data deletion in the

receiver client?

Regards Karlheinz

[amit_sharma36]

Hello Karlheinz,

There is an activity "Automatic assignment of data deletion technique", it will check and assign it. you can check in logs of this activity.

In case drop_insert is not assigned (I think you want to assign this), you can use next optional activity to set it at package level.

Drop_insert will be useful if data in client to be deleted is very huge as compared to other clients of receiver system. it will drop table and insert data of other clients back in other clients which is very less.

During this time, no body should use system.

regards,
Amit Sharma

[former_member640444]

Hello Amit,

ok, but does TDMS not assign "drop-insert" when there are other clients in the receiver system? I want to guarantee that there is no impact on the other clients in this system.

regards,

Karlheinz

[amit_sharma36]

Hello Karlheinz,

yes, drop insert is only assigned if system is having multiple clients and other clients are having larger % of data volume as compared to client to be deleted .

if data volume is less or equal, it is possible.

regards,

Amit Sharma

[former_member640444]

Hi Amit,

I don't want to have "drop-insert" in a receiver system with multiple clients. Because I cannot guarantee that in the other clients data is in use by some users.

Therefore I want not to use drop-insert.

And I want to know what is the default behaviour of TDMS in such a case.

Regards,

Karlheinz

[amit_sharma36]

Hello Karlheinz,

Good, question is straight and clear now.

please refer to steps mentioned in oss note 1433553 to make sure that TDMS should not consider drop_insert in TDMS migration.

Regards,

Amit Sharma

Solution

You have the possibility to set a Global Parameter for setting the deletion
scenario to overall array delete. In the following a description of the
proceeding.

Check if the global parameter GLOBAL_NO_DROP_INSERT exists
and that it is set to 'X' in the receiver system.

• Call the Migration Server Overview(tcode cnv_mbt_tdms).

• Expand the tree until you get your package.

• Mark the package number so that it is highlighted.

• In the menu click on Goto->Global Parameter.

When you have correctly positioned your cursor on a package number you

will see in the application toolbar buttons named with the exection targets,

system name and client number. You can also see if a connection to the listed

system is working (checkmark) or not (lightning).

Click on the button

'RECEIVER' to get the global parameters from the receiver system. This is where

the Global Parameter has to be set.

The global parameter entries will be

delivered empty and for the parameter you want to use you have to set the value.

An initial global parameter has no value in the column 'Client'.

• Mark the row with the global parameter
  'GLOBAL_NO_DROP_INSERT'.

• Press button copy text (third button).

• In the menu bar click on the drop-down box of the insert button and choose
  the item 'Insert in new row' in the selection list (forth button from
  left).

• In column 'Client' enter the client where you want to use the overall
  scenario array-delete. If you enter the value 'ALL' then the setting is valid
  for all clients in the system.

• In the column 'Parameter Value (from)' enter the value 'X'.

• Save your settings.

If the parameter already exist you have to check whether the correct
client is set. If the column 'Client' includes the deletion client or the value
'ALL' then no further settings are required. Otherwise you have to copy the
Global Parameter as previously described and change the value in the column
'Client' with your deletion client. Take care that the value in column
'Parameter Value (from)' is 'X'.

From now on the generation of deletion
programs will use this information to create the deletion programs with deletion
scenario ARRAY-DELETE.

[amit_sharma36]

if this solution is helping you, mark it as correct answer. it will help others too.

[former_member640444]

I have to check this next week.