Skip to Content
0
Former Member
Apr 02, 2014 at 05:34 PM

Deleting entries in SXMS* tables in PI and ECC

994 Views

Hi Experts,

Can you help me understanding the below tables. These tables contains data from Integration Engine(SXMB_MONI). The pipeline informations are stored here. The retention period of messages in PI is 7 days. We have deletion and archival jobs running in PI every 7 days.

SXMSCLUP

SXMSCLUP2

SXMSCLUR

SXMSCLUR2

SXMSPMAST

SXMSPMAST2

SXMSPHIST

SXMSPHIST2

From all these tables, every 8th days entries are deleted and new entries comes in. So i want to understand how it is working.

Is it like when a message is deleted from integration engine, the entry is also deleted from these tables?

Or any back ground activities takes place implicitely?

Please let me know if any other job needs to be run to delete the entries from these tables explicitely.

We have the same tables in ECC also but the deletion and archival jobs are not resetting the entries from the table.

Thanks in Advance,

Regards,