Skip to Content

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

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)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    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,

    Add comment
    10|10000 characters needed characters exceeded