Good morning,
we have a SAP Netweaver 04s installation based on MaxDB 7.6.10
In the last month we are experiencing a very strong DB size growth (about 10Gb a day).
XI messaging deletion is working fine, both for the Adapter Framework and the Integration Engine, but there should be something that we're missing.
Checking the tables size and growth (both for the ABAP and the JAVA schemas) from inside the DB50 transaction, gives a total size of about 70Gb (including indexes) , but the reported size of the DB space usage is way ahead of this: 205Gb.
The most growing tables show a total grow of about 500Mb/day but, as said, the DB grows by 10Gb..
Now we are trying to identify were in the DB structure (system tables?) are those more 130Gb contained, so that we may have a clue about were to act to take down the DB to a more reasonable size..
The problem is that until now we have not found a way to check the size of EVERY object contained in the DB, both from the SAP interfaces (SAPGUI/nwa/rwb) or via SQLstudio.
This problem is quickly becoming very urgent, because the max allocable space to the DB without adding more hardware is about 300Gb and with this growing ratio we'll soon been stuck 😔
Thank you in advance for your kind help.
Carlo Ferrari