sxmsclup grows quickly, which caused file system space less.

[SAPSupport]

sxmsclup grows quickly, which caused file system space less.
We keep doing archiving on the table.

Question:
how can we reorg on the table?
how to prevent table growth?

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

The only why to prevent sxmsclup growth is to control from application level, for example, less usage, bring less value.

See applicatio kba/note:
2167673 High growth of PI table SXMSCLUP

After archiving, we can do reorg, to free up space inside database, the normal table level reorg, won't free up os space.

Best regards,
James (from SAP Oracle team)

[JamesZ]

If we cares about OS space, we need to reorg tablespace by creating a smaller data files.
Table level reorg won't release os space, it only release space inside database/oracle.