To delete history data MIServer

[Former Member]

to delete history data in MIServer

in one scenario , where there is large amount of data downloaded, which takes very long time,

but the data has been downloaded into MIServer, how do i clean the data ?

[Former Member · Accepted solution]

Hi,

Use transaction MEREP_PURGE to delete obsole data such as logs, runtime history data (inbox,outbox) in merep_mon.

It is used to delete all unwanted history data for a particular Mobile ID.

Enter the transaction merep_purge and provide the details accordingly..MobileID,Date ranges etc

Cheers,

Karthick

[Former Member · Accepted solution]

when i use merep_purge , but my table still showing merep_207 showing the same no of records

[Former Member · Accepted solution]

Hi,

Merep_purge has nothing to do with the data in middleware (table MEREP_207).

The no. of records in merep_207 is very much specific to the syncbo, when we replicate the syncbo all the records in backend for that syncbo would be replicated to middleware and seen in MEREP_207.

When we use purge tool, we can delete all runtime history data for a particular (all devices) device (merep_mon--> Inbound worklist, out bound work list, logs etc).

Sp it would delete data in merep_207 table.

Hope this is helpful.

Cheers,

Karthick

[Former Member]

Hi yzme,

There is a purge tool in the MI middleware server. Its transaction code is

MEREP_PURGE.

using this tool You can delete obsolete, historical runtime data about Smart Synchronization from the system. You can control the over all data volume in the system.Is this what you require?

to know abou the tool, check this <a href="https://www.sdn.sap.comhttp://www.sdn.sap.comhttp://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/909d75c3-0801-0010-5f92-920a78c53daa">url</a>

Thanks

Veerabhadram

[Former Member]

Hi,

Merep_purge is the transaction used in middleware to delete obsolete, historical runtime data about Smart Synchronization from the system.

Kindly refer this link about Purge tool

http://help.sap.com/saphelp_nw2004s/helpdata/en/56/f81b0c995f50448a2a45a5dcfc2d17/content.htm

Hope this helps

Best Regards,

Lakshmi