Data archiving using Tcode SARA

[Former Member]

Hi guys,

I'm facing some issues with SAP tables.These are the tables(SXMSCLUR,SXMSCLUP,SXMSVERS,SXMSPMAST) which grows drastically day by day.Currently the size of these tables --> 4 GB .

Can somebody suggest how to go about with SARA transaction (Arhive administration)?

Looking forward for the reply.Thanks in advance.

Regds,

Shankar.

[Former Member · Accepted solution]

use t-code DB15 to find the archiving objects for these tables.

[Former Member]

Hi Jurgen,

I have checked inside the SARA tcode with the object BC_XMB it doesn't include these two tables SXMSCLUR and SXMSCLUP.When I tried the above option "objects for table" in SARA,it says "no suitable archiving object exits for the table SXMSCLUR and SXMSCLUP.

Thanks for your help.I'll create ticket for the above mentioned issue.

Regards,

Shankar.

[Former Member]

Can anyone give me the exact procedure for data archiving...or the path of the document for the same...

Thanks and regards,

Kuanl PAtel.

[Former Member]

hey see this link

it will be useful for you

https://www.sdn.sap.com/irj/scn/wiki?path=%3fpath=/display/docbuilder/steps%252binvolved%252bin%252b...

[Former Member]

Hi Jurgen,

Please help me how to fix this issue for SXMSCLUR and SXMSCLUP.

Thanks,

Shankar.

[Former Member]

Hello Shankar,

to be honest: I'm really no expert in XI and so I also don't have a XI installation at our site.

But after looking at the documentation mentioned in the post before (help.sap.com) it should be possible via SARA and object BC_XMB.

Regards

Juergen

[Former Member]

Hi Jurgen,

I have doubt, do I need to implement the Note 761713? B'cos my system is currently with SAP WAS 6.40 SP14 and SAP XI3.0 SP 14.

I feel the note is pretty old...

Please advise..

Regds,

Shankar

[Former Member]

Hello Shankar,

no you don't need to implement the note in your environment because the note is just valid for WAS 6.20 and XI 2.0.

Regards

Juergen

[Former Member]

Hi Juergen,

Thanks a lot for your kind help!

Thnx,

Shankar.

[Former Member]

Also look at:

http://help.sap.com/saphelp_nw04s/helpdata/en/f5/d347ddec72274ca2abb0d7682c800b/content.htm

http://help.sap.com/saphelp_nw04s/helpdata/en/05/b1b740f83db533e10000000a155106/content.htm

http://help.sap.com/saphelp_nw04s/helpdata/en/0e/80553b4d53273de10000000a114084/content.htm

[Former Member]

You should setup a reorgjob for deleting XI-Messages which deletes also rows in these tables. Have you already looked at SAP note 761713?

Regards

Juergen