SAP Knowledge Base Article - Preview

2426254 - DC Cleanup runs for a very long time

Symptom

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.


Read more...

Environment

  • Sybase Corporate Online Banking 8.2
  • Oracle Database 11

Product

Sybase Corporate Online Banking 8.2

Keywords

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 for Me (Login required).

Search for additional results

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