SAP Knowledge Base Article - Preview

2206985 - Latency: the same open transaction stuck in IBQ - SRS 15.7.1

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

SAP Replication Server 15.7

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.