Symptom
- When creating a boundary, the java process selects the complete datasets with an order by.
- It is sorting the data inside the database, consuming large amounts of temp space + resources.
- Create boundary also takes a very long time for tables with a large number of rows.
For Example: mytable table has 373596353 rows, and ran for over 12 hours. - How can this be monitored?
Read more...
Environment
SAP Replication Server (SRS) Data Assurance 15.7.1 SP303 and above
Product
SAP Replication Server 15.7 ; SAP Replication Server 16.0
Keywords
KBA , BC-SYB-REP , Sybase Replication Server (standalone) , How To
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.
SAP Knowledge Base Article - Preview