Performance impact of Content based message search in IE

[Former Member]

Hello Experts,

I am working on implementing Content based message search in IE in PI 7.0 and PI 7.1 landscape.

All the configurations are done and its working fine in Development scenario.

I need help in identifying , how this actually works on technical level as in how the messages are getting searched based on the filter criteria, if there is any table getting created in background and values are getting stored etc.

And also how could this impact the overall performance after implementing it in Production system.

Thanks in advance!

Warm Regards,

Lisin

[Former Member · Accepted solution]

Hi Lisin

Not sure about 7.0/1 but for 7.4 these are the tables.(most probably tables should be same)

When you configure a filter for UDMS search on ABAP stack(Tcod: sxms_lms_conf)

Entries will be created in the following backed ABAP tables. (you can go to se16 and check the entries).

SXMS_LMS_EXTR

SXMS_EXT_FIL

SXMS_NSPREFIX

Data will be stored in this table

SXMSPDATA

When you configure a UDMS filter in RWB(java stack), entries will be created in the following backend tables

XI_AF_LMS_EXTRACTR

XI_AF_LMS_FILTER

Data will be stored in the table (only the message id, direction, key field,value and position)

XI_AF_LMS_DATA

We have UDMS configured in our production system, and i never saw any performance issue.

Regards

Osman

[droutray · Accepted solution]

Very helpful information. Thank you.

[Former Member]

Hi Osman,

Thanks for the details.

For IE it works same for 7.0

Could you please answer some of other queries as well :

• How much data could be stored in the table SXMSPDATA , how archiving and deletion works for that table.
• And when we search the message, would it search only in the data which is present in the system i..e excluding archived/deleted data.

Thanks in advance!

Regards,

Lisin

[Former Member]

Hi Lisin

Not sure about how the archiving and deletion works for these tables.

about second query. According to below sap help link, yes search can be done on archived messages also.

Advanced Message Search - Advanced Adapter Engine - SAP Library

Regards

Osman