SLT Servers High space / memory utilization

[SAPSupport]

Table ODQDATA (Operational Delta queue) have grown nearly 300 GB.

ODQ_CLEANUP job has been running but the time is very long (> 1 day) which lead to timeout issue.

How to make ODQ_CLEANUP job finishes successfully to reduce the number of table ODQDATA?

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

[SAPSupport · Accepted solution]

1. Make sure no old data in ODQMON and all obsolete subscriptions have been deleted. See note 2502498 - Huge amount of data in ODQDATA table
2. Follow note 2300483 - ODQ - performance of ODQDATA_V and ODQTSNLOG to create indexes:
   • Secondary index on the table ODQDATA: Fields: CLIENT, MODELNAME, QUEUENAME
   • Secondary index on the table ODQTSNLOG: CLIENT, TID
     
     
3. Apply note 3213659 - ODQ_CLEANUP: Runtime error SYSTEM_NO_ROLL in delete_queue_data
   
   
4. Execute ODQ_CLEANUP job with different values of Retention period to clear the data one period by one period
   [For example]: Suppose that there're old data over than 20 months:
   • Delete them "month-wise" starting with a retention time of 19 months (24h * 30 days/month * 19 months = 13,680 hours to start with):
     Recovery  13,680 Hours  <-----
     Data with low relevance 10 Days
     Data with average relevance 31 Days
     
     If this is successful it should have deleted confirmed data older than 19 months.
     
     
   • Change the variant always reducing the retention time by 720 hours (a month with 30 days):
     Recovery  12,960 Hours  <----- 13,680 - 720
     Data with low relevance 10 Days
     Data with average relevance 31 Days
     
     
   • Next retention time should be reduced step by step from 12,240, 11,520, 10,800, ... , to 720 for the last month finally.