How to adjust a target table during replication

Hi,

this blog post describe the steps to adjust the target table during the replication.

Some manuel steps are required.

DMIS 2011 SP7:

There are two options. The recommended approach is the execution of the program.

A.) Program with docu:

1.) Stop master job

2.) SE38 -> Execute programm and read docu to understand the settings: IUUC_REPL_ADJUST_TARGET_TABLE

3.) Restart master job

B.)Step-by-Step approach:

1.) Stop the master job for the configuration (via LTR or LTRC)

2.) Enter LTRS and add the new field and a rule if relevant. Save the settings.

3.) Execute Expert Function „Reset Status of Tables and Synonyms“ for the table.

4.) Delete the synonym table

a)   For 1:1 replication:

           – goto LTRC -> Tab “Table Overview” and copy the Logging Table      name

           – Replace the the first 0 of your logging table with S, e.g. /1CADMC/00001243 will become /1CADMC/S0001243

           – Enter SE11 and input the value (/1CADMC/S0001243) as database table and delete it.

b) for 1:N configurations

          – goto table IUUC_TAB_ID and filter on your mt id, table name, system_type = R and Ident_type = S

          – get the ident id

          – enter SE11 and inpit /1LT/*<ident> ; e.g. /1LT/*4587

          – search via F4 help and delete it

5.) Enter LTRC and navigate to tab Expert Functions and execute “Reset Replication      Object Definition”.

6.) Adjust the table on HANA with the new field (SQL statement alter table)

7.) Restart the master job for the configuration.

DMIS 2011 SP05:

1.) Stop the master job for the configuration (via LTR or LTRC)

2.) Enter IUUC_REPL_CONTENT and add the new field and a rule if relevant. Save the settings      and execute “Reset Migration Objects”.

3.) Enter SE16 and access table IUUC_TABLES.

     – Find your table and open the record

     – Clear the field ‘LCL TAB FOR RCV’, that signals the system that there is no target table           information and it will be created again. 

4.) Delete the synonym table -> goto LTRC -> Tab “Table Overview” and copy the Logging Table      name

5.) Replace the the first 0 of your logging table with S, e.g. /1CADMC/00001243 will      become /1CADMC/S0001243

6.) Enter SE11 and input the value as database table and delete it.

7.) Enter LTRC and navigate to tab Expert Functions and execute “Reset Replication      Object Definition”.

8.) Adjust the table on HANA with the new field (SQL statement alter table)

10.) Restart the master job for the configuration.

Best Regards,

Tobias