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

Search for additional results

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