SAP Knowledge Base Article - Preview

2426254 - DC Cleanup runs for a very long time


Whenever the following query runs in Data Consolidator (DC) cleanup, it takes around 70 hours to complete:

 delete from DC_Account where DCAccountID in (select distinct dca.DCAccountID from (DC_Account dca left outer join Accounts a on dca.AccountID = a.account_id and dca.RoutingNumber = a.routing_num) where a.account_id is null)

Each row takes around 14 minutes to delete. DC_Account has cascade deletes to around 13 tables and delete on each row of these tables activates the triggers. Please check if the query can be optimized.



  • Sybase Corporate Online Banking 8.2
  • Oracle Database 11


Sybase Corporate Online Banking 8.2


Data Consolidator, DC, Cleanup, Oracle, long, running , KBA , FS-OLB , SAP Online Banking , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.