finding the table related to tablespace

[Former Member]

Hi Experts,

Its a production issue. The table space of XI has got filled up,later BASIS people have increased the space by adding an additional file system.I just want to know which table has got filled.

Please provde me the navigation to find the table.

Thanks,

Suresh.

[SudhirT · Accepted solution]

Hi,

PSAPSR3 is the table space and the tables are, SXMSPMAST,SXMSCLUP. For more details on table refer this blog

Thanks!

Edited by: sudhir tiwari on Nov 21, 2008 2:01 PM

[Former Member]

Hi Suresh

SXMSPMAST would have filled. This table holds the XML messages processed by PI

You need to implement archival and delete strategy with production system to avoid this situation. Increasing the size is a temperory solution and not a good practice. If you don't have any business requirement to keep data. Go ahead and do archive and delete under SXMB_ADM

Thanks

Gaurav