SAP Knowledge Base Article - Preview

2207039 - Latency: open transactions in IBQ are moving slowly - SRS 15.7.1

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

SAP Replication Server 15.7

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.