Tables of the XI growing very quickly

[Former Member]

Hii Experts,

XI 3.0 SP 14.

Some of the tables of the XI growing very quickly and causing severe performance problems. I performed all archiving / deletion using tables like SXMSPMAST, SXMSCLUR / SXMSCLUP,SXMSPHIST, SXMSPFRAWH and SXMSPFRAWD ,SWFRXI*

After cleaned up by XML message archiving / deletion using the above tables, Database is still constantly growing.Within 2-3 weeks after 'go live', database has grown to 40GB. what can be reason? How to restict this growth?Please suggest me some ideas to resolve the above issue?

Thanks in advance,

John.

[Former Member]

John,

First make an analysis of the number of messages in your system:

TXN SXMB_ADMIN > Persistence Layer analysis

Then see what retention period you need and set this (for deletetion):

TXN SXMB_ADMIN > Integration Engine Configuration > Parameter

DELETION.PERSIST_DURATION.ASYNC

DELETION.PERSIST_DURATION.SYNC

Then run the delete jobs

TXN SXMB_ADMIN > Delete jobs

More information in note 872388.

Do not forget to clean BPM data (table SWWWIHEAD) and Adapter engine data (table XI_AF_MSG), but the ABAP tables (SXMSPMAST (header) and tables SXMSPEMAS, SXMSPVERS, SXMSCLUP, SXMSCLUR, SXMSPERRO) are the "biggest".

[stefan_grube]

You did not mention the archiving/deletion of the messages in the adapter framework. You should perform the jobs in the adapter framework as well.

Could you figure out, which tables have huge sizes?

Regards

Stefan

[Former Member]

You could use DB02 to find out the big tables.

Then search OSS for archive method.

Please give points if it's helpful.

[Former Member]

Hii Stefan,

Can You be more specific.

what is the the archiving/deletion of the messages in the adapter framework? How to perform the jobs in adapter framework?

How to find out which tables have huge sizes in DB02 tx.

Please let me know,

Thanks & Regards,

John.

[bhavesh_kantilal]

John,

Maybe the tracing level has been increadsed .

Check this,

SXMB_ADM --> Integration ENgine COnfiguration --> Edit --> Change Specific COnfiguration Data --> Make trace level to 1 .

/people/michal.krawczyk2/blog/2005/05/10/xi-i-cannot-see-some-of-my-messages-in-the-sxmbmoni

Regards,

Bhavesh

[MichalKrawczyk]

also check if you don't log synchronous messages

the same link

Regards,

michal

[Former Member]

Hii Bhavesh,

I have not set Tracing level in Integration Engine Configuration. So that is not the reason. Any other suggestion is appreciated.

Regards,

John.