The difference between Standard Deletion and Array Deletion

[former_member1348845]

Hi all.

We had issue that when we executed Deletion data in Receiver, the transaction log was full.

After getting this issue, we found that the assigned deletion technique in 'CNVMBT09TABLE' to big tables was improper.

We needed to assign not Standard but Array Deletion technique to big tables to solve this problem.

However actually we don't understand the difference of those deletion technique in details.

we read some TDMS documents and references from SAP but there are not enough for us.

(ie chapter 4.3.6.1 'Choosing data deletion technique to delete data from the receiver system' in TDMS Application Guide )

It would be nice if you could tell us what is the array deletion techinique in detail.

Best Regards.

Ko

[rajesh_kumar2]

Hello Ko,

TDMS uses two deletion techniques -

1. Array Delete-  In this approach all the relevant client speific data is selection in poriton size and then uses client dependent deletion to delete the data for a table,

2. Drop Insert Technique - In this approach , full table data is selected accross all clients and stored in local cluster tables in compressed format. In a next step the table is dropped at the DB level and then the data for all other clients are restoed back.

Both the techniques helps in deleting client specific data consistently .

Depending on the data distribution accorss clients and data volume of the tables a suitable deletion technique may be assiged for optimized data deletion.

Hope this hleps your understanding.

Thanks,
Rajesh

[former_member229755]

In addition to this, TDMS also chooses the Technique based on the DB e.g. in case of DB2 Drop Insert technique is not advisable for very large tables as when the table is dropped, the database compression algorithm also gets deleted. To build the Compression Algorithm again, we need to have certain number of minimum rows in the tables.

In your case, please check the status of /rec/client parameter in the Target during Data deletion phase.