/BI0/ASM_UPLDD00 table high records

[SAPSupport]

Hi Team,

we need your help on /BI0/ASM_UPLDD00 table reached 1.90 Billion records. How do we reduce the size of this table?

We found Usage Logging and SQLM application in deactivation status for housekeeping , can you please suggest on housekeeping settings?

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

[SAPSupport · Accepted solution]

Dear Customer,

The reason for the table  /BI0/ASM_UPLDD00 containing a large number of entries is usually the fact that the Usage Logging Housekeeping Settings are inactive. Additionally insufficient retention periods can cause excess data growth in this table. 

The table /BI0/ASM_UPLDD00 is an application table which represents the contents of the DataStore Object 0SM_UPLDD - this is where daily data, collected as part of usage logging, is stored. Daily data is then aggregated into further DSOs at different granularities (weekly, monthly and yearly) to support usage logging activities. 

It is highly recommended to activate housekeeping for Usage Logging, and to configure retention periods, to enable the BW housekeeping job (E2E BI HOUSEKEEPING job) to delete excess data for each system daily. This prevents a build-up of unneeded data in the DSO.

The default retention period for daily data is 14 days, meaning that the housekeeping job will search for and delete any data older than 14 days from the DSO. Any value can be chosen for the retention period, based on your usage logging requirements. 

To activate the Housekeeping Settings for Usage Logging, follow the steps below:

1. In Solution Manager system, execute Transaction: SOLMAN_SETUP.
2. Select the Custom Code Management Scenario.
3. Enter Step 3.
4. Select the Managed System that you wish to maintain Housekeeping for from the list.
5. Enter Edit mode.
6. Select the Settings dropdown in the System Overview section, and select System-Specific Settings
7. The resulting pop-up window displays the current settings - retention periods and activation status of housekeeping
8. Maintain the desired retention periods and activation settings
9. Click Save

For more information on the Usage Logging please refer to the SAP Help Portal:

https://help.sap.com/docs/SAP_Solution_Manager/283e4c6df1d44887a6449094bbfc3775/7f6a89e0ae0b48dba16f...

https://help.sap.com/docs/SAP_Solution_Manager/dfb02462c453431eaf249aad96f004f8/7bf1c60384fb43788e7f...

SAP Community : Getting started with Usage and Procedure Logging (UPL)

https://community.sap.com/t5/technology-blogs-by-sap/getting-started-with-usage-and-procedure-loggin...

Kind Regards,

SAP Support