Skip to Content
author's profile photo Former Member
Former Member

Large volume of data Archiving and Deletion of XI Messages

Hi All

Large volume of data Archiving and Deletion of XI Messages.

I got a task for large volume of data for archiving and deletion of XI messages.

Now the problem is how can I archive and delete the XI messages which large volume of data.

Now please suggest me any one how to large volume of data Archiving and Deletion of XI Messages.

On the XI there is no archiving or deletion enabled for messages. There are some huge tables, and this can cause performance issues.

Two big tables on XI are: SXMSCLUP and SXMSCLUR.

The size of these tables are SXMSCLUP = 38 GB and SXMSCLUR = 79 GB.

Thanks&Regards,

Raju.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2011 at 03:42 PM

    Refer this [link|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/18817] [original link is broken] [original link is broken];

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2011 at 08:18 PM

    Hi,

    This is the official documentation: Note 872388 - Troubleshooting Archiving and Deletion in PI

    Also have a look at this thread:

    I had to deal with SXMS* tables larger than 100 GB. Take into account to schedule the archiving/delete jobs when the system has little load. Start scheduling these jobs manually using creation dates for example to avoid long runtimes. Do it at small steps. After you perform the deletion/ archiving you´ll probably need to do a table reorganization (database shrink) to claim the unused database GBs.

    Regards,

    Diego.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.