Symptom
- Primary site data is getting replicated very slowly to the replicate sites.
- Replication latency continous to grow as data is slowly flowing through.
- The "admin who, sqt" command shows that First Trans in the primary database inbound queue (IBQ) is moving:
Spid State
Info
Closed Read Open Trunc Removed
Full SQM Blocked First Trans
Parsed SQM Reader Change Oqids Detect Orphans
---- --------------------
------------------------------------------------------------
----------- ----------- ----------- ----------- -----------
----------- ----------- ---------------------------------------------
----------- ----------- ------------ --------------
38 Awaiting Wakeup
113:1 DIST PDS.pdb
0 0 5 5 0
0 1 st:O,cmds:1,qid:12780:48:21
Read more...
Environment
SAP Replication Server (SRS) 15.7.1
Product
Keywords
slow performance sqt_max_cache_size , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , BC-SYB-REP-SAP , Replication with SAP Suite / SAP BW , 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.