Housekeeping for Solution manager Database

[SAPSupport]

Dear Team,

Our Solution manager system (PSM) database (Sybase) is almost 90% full. We need to perform housekeeping to reduce the DB size.

Below mentioned are the top consuming standard tables on the Sybase DB. Please check and let us know how to perform cleanup to reduce the DB size.

Table Name Used MB
----------------------------------- ----------
syslogs DIGITS.375
/BI0/E0CCMAWMD2 ZIPCODE.DIGITS
/BI0/D0SMD_EA1H7 ZIPCODE.DIGITS
DSVASRESULTSGEN ZIPCODE.DIGITS
/BI0/E0CCMWSMD1 ZIPCODE.DIGITS
/BI0/E0CCMAWMD1 ZIPCODE.DIGITS
/BI0/F0SMD_EA1H ZIPCODE.DIGITS
BALDAT ZIPCODE.DIGITS
/BI0/SSMD_PRGR ZIPCODE.DIGITS
/BI0/E0HDB_C05H ZIPCODE.DIGITS

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

[SAPSupport · Accepted solution]

Hi customer,

There are several housekeeping settings can be done to limit the size of solution manger relevant tables.
Please refer 2549260 - Certain tables in Solution Manager system grow fast - SAP Solution Manager 7.2