on 09-11-2014 5:50 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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.
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'.
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.
User | Count |
---|---|
91 | |
10 | |
10 | |
9 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.