Skip to Content
avatar image
Former Member

Impact on XI production

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Apr 16, 2008 at 06:46 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 16, 2008 at 06:52 AM

    Hi,

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

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 16, 2008 at 07:50 AM

    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,

    Add comment
    10|10000 characters needed characters exceeded