Operational Delta Queue Cleanup

Created by:

SAP

Underlying SAP report:

ODQ_CLEANUP

Client-dependent:

No

Settings as variant:

Yes

Support for RecycleBin:

No

Recommended for HANA pre-migration Housekeeping: 

No
Introduction

The Operational Data Provisioning (ODP) framework has been greatly enlarged during the last releases of SAP Business Warehouse (BW). The framework uses Operation Delta Queue (ODQ) as temporary storage for data that is loaded from the data sources and pushed further for all subscribers of the queue. These queues should be cleaned up to avoid unnecessary utilization of database resources.

Recommendation

SAP recommends running this task daily.

Related SAP Notes

  • 2286619 – ODQ_CLEANUP deletes entries in simulation mode

  • 2190229 – Composite request can only be confirmed by the subscriber

  • 2166526 – Solution to delete unconfirmed requests in transaction ODQMON

  • 1745317 – ODQ: Cleanup notification does not pass queue names

  • 1735928 – ODQ: Improvements for cleanup

  • 1655273 – ODQ: More than one cleanup job per client

  • 1599248 – ODQ: Real-time support

  • 1507908 – ODQ: Client dependency of the cleanup job is undefined

  • 706478 – Preventing Basis tables from increasing considerably