Impact on XI production

[Former Member]

What will be the effect on XI PRD ,if we delete enteries from the following tables:

SXMSPEMAS

SXMSPFRAWH

Please reply ASAP as iam trying to run a program to delete the table data,so before running it in prd want to be sure that nothning goes wrong.

Regards

Pooja

[Former Member · Accepted solution]

Hi ! Pooja

SXMSPFRAWH

ABAP tables such as SXMSPFRAWH, that keeps the details of process details.

SXMSPFRAWH - runtime performance table for only sucessful messages

you will not be able to see the process details in this table that reflects the sucessfull messaage .

SXMSPEMAS

SXMSPEMAS:--->> (Integration Engine: Enhanced Message Queue (Master)) -

---

>>>The table provides the namespaces, the business systems and message interfaces involved in the interface.

so i think u can't delete this table .

Thanks

Abhishek

[Former Member · Accepted solution]

Hi,

Actually our database is having 27 lakhs messages

and we have to clear it

so can you please suggest which tables we can clear so that it will not effect fronend integration repository and directory objects of xi.

Also i have decided to delete the following tables:

SXMSPERROR, sxmspvers

sxmsclur, sxmsclup, SXMSPMAST,SXMSPHIST.

WIll IT be safe to delete the following tables so that it doesnt effect fronend integration repository and directory objects of xi.

Thanks& Regards

Pooja

[Former Member · Accepted solution]

Hi ! Pooja

Just refer this Pdf this contains which table cantains what kind of configuration data ,

u can delete accordingly

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/909760cb-0ec8-2a10-4a96-ee8417ac...

Thanks

Abhishek

[Former Member]

Hi Pooja,

Deleting entries from these table For Ex: SXMSPEMAS means you can no longer see the messages in SXMB_MONI.

I don't know how far this is acceptable for you.

Once you delete the entries here means you are deleting the Monitoring Logs.

If these tables are really effecting your system performance try to find an alternate solution like reorganizing tables I exactly don't know if that helps you also.

Regards,

[Former Member]

Hi,

Before you delete, why do you want to delete these entries?

Regards,