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.