How to empty merep_604, and others after DB copy

[former_member189501]

We did a db copy back from the Web As 640 production MI25/MAM25 environment to

the Web As 640 test MI25/MAM25 environment.

We used a ful offline backup of the MOP system and then restored it back on the test system.

The restore worked fine and the new MOQ is up and running.

The restore was necessary to fix important function groups corrupted by a bad Oss NOte implementation.

After the usual post-actions for the DB copy on the target system, we did some action to clean up the old MI25/MAM25 data.

On the target system we cleaned up the Replica Database and deleted all the Devices presents in SMOMO.

Then we run the merep_purge to clean up the logs tables for MI25.

The MErep_purge terminated successfully but we see there are still more

than 400.000 entryes into the MEREP_604 table and a lot of entries into

the tables MEREP_602 and MEREP_504.

We run teh MEREP_PURGE job more times, changing the variant in ordert

to delete ALL the logs. Every time it ends successuffly but no further

entryes are deleted from these tables.

How we can clean up the MEREP_604, MEREP_504 and MEREP_602 tables ?

We want to clean up all the obsolete data coming from the production environment with the restore,

before to populate again the test Replica Database.

Regards

[Former Member]

Hi Mauro,

If MEREP_PURGE is not working them write a simple report to clear the data from this tables.

That will do the trick for you.

Regards,

Rahul

[former_member189501]

Thanks for your suggestion.

Maybe in your opinion I could use also the more faster "truncate" statement at oracle level to empty these tables (Merep_640, Merep_602, and MErep_504)?

regards

[Former Member]

Hi Mauro,

I would suggest keep it simple and go with the report. You can use the report later.

Regards,

Rahul

If this helps, do not forget my points

[Former Member]

Hi Mauro

I think u used this report <b>Z_CLEANUP</b> to clean up the data . if u have any other option pls let me know

bye

sid