Skip to Content

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

Oct 04, 2017 at 10:26 AM


avatar image

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.



lobsegment-size.jpg (115.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadym Diachenko
Oct 10, 2017 at 10:36 AM

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,

10 |10000 characters needed characters left characters exceeded