Missing secondary index after TDMS data deletion

[Former Member]

We have done a TDTIM transfer to a single client system. The deletion technique used by TDMS is Drop-insert technique.

During our initial analysis, we found that many of the secondary indices are not re-created by TDMS at database level. For many few tables the secondary indices are re-created at the database level.

• Will TDMS delete and re-create the secondary index for re-created (droped & created) tables during data deletion in receiver system ?

• Why did TDMS re-create secondary indices for few tables and why it didnot re-create secondary indices for few other tables?

Thanks

Praven

[former_member65049]

Indexes are deleted from the receiver only in cases when they were not present at the DB level in the receiver system

prior to TDMS run. This is to avoid any kind of error/exceptions when records are inserted into the table.

You need to create these indexes manually.

In order to do so, you can follow the steps below:

1. Execute transaction DB02.

2. Select the button "missing indexes". A list of 1091 is shown

3. Place the cursor on the line "secondary indexes" and hit F9

4. Now hit "create on DB".

5. A popup will ask if you want to do a mass select. Press "Yes"

6. A further Popup will then ask for background processing. Say "Yes".

Best Regards,

Rupam

[Former Member]

Thanks Rupam.