2207039 - Latency: open transactions in IBQ are moving slowly - SRS 15.7.1 | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.