Symptom
- Primary site data is getting replicated very slowly to the replicate sites.
- The "admin who, sqt" command shows the same open transaction in the inbound queue (IBQ) over an extended period of time:
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
- This transaction can be open and uncommitted at the primary site.
Read more...
Environment
SAP Replication Server (SRS) 15.7.1
Product
Keywords
syslogshold kill RepServer , 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.