SAPSR3DB LOBSEGMENT MG_STG space is drastically increasing in XI/PI Production

[former_member303666]

Hi All,

As we noticed In SAP PI System PSAPSR3DB Table space is drastically increasing and irrespective of adding 250 GB space additionally still table growth is occupied 86% as shown below.

Please help us the way to reduce the PSAPSR3DB LOBSEGMENT Space.

Regards,

Kesava.

[Former Member]

Hello Kesava!

As you can see, the DB table which corresponds to that LOB segment is BC_MSG. This is the main table for storing messages processed in AE.

1. Check whether main housekeeping jobs (deletion and archiving) are scheduled and executed correctly
2. Execute the following SQL query to SELECT COUNT(*), STATUS FROM SAPSR3DB.BC_MSG GROUP BY STATUS; to have an understanding about amount of messages with different status currently persisting in your DB.
3. Check the retention periods you have set for:

• Async messages persistance: xiadapter.outbound.persistDuration.default and xiadapter.inbound.persistDuration.default
• Sync message persistance: messaging.log.retainTime

Change the values if they are too high. After that the deletion job has to be executed one more time to remove expired messages.
In extreme cases, after that DB reorganization might be reuquired.

Best regards,
Vadym