2607913 - HVAR/RTL Performance Slow to SAP IQ - SRS | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2607913 - HVAR/RTL Performance Slow to SAP IQ - SRS

Symptom

  • Outbound queue is slow.
  • Queue dump output shows too many rs_ticket entries sent from the primary database (PDB):
      
    • QUEUE DUMP FOR 393:0
      BLOCK BEGIN q_number=393 q_type=0 blk=3888797:48 cnt=7
      ENTRY ver=1100 len=388 orig=168 lorig=0 oqid=00150015057d610300b06bc0000200b06bbf000f0000a887008608e60000000000000002 lqid=3888797:48:0 st=0 tr= '0015001505' }` 'f7000f' BHLINXeli '000000a800000000' comlen=261 rs_ticket 'V=2;H1=DBGSYB;H2=302182731;H3=-21600;H4=BHLINX;PDB(pdb)=02/14/18 08:08:01.286;EXEC(336)=02/14/18 08:08:01.295;B(336)=332829068911;DIST(189)=02/14/18 08:08:01.374;RSI(99)=02/14/18 08:08:01.617;RSI_B=425762062186;PRS=RS1'

      ENTRY ver=1100 len=188 orig=168 lorig=0 oqid=00150015057d610300b06bc0000200b06bbf000f0000a887008608e60000000000000003 lqid=3888797:48:1 st=1 tr= '0015001505' }` 'f7000f' BHLINXeli '000000a800000000' comlen=63 commit transaction

      --after 2 seconds --

      comlen=261 rs_ticket 'V=2;H1=DBGSYB;H2=302182731;H3=-21600;H4=BHLINX;PDB(pdb)=02/14/18 08:08:03.186;EXEC(336)=02/14/18 08:08:03.205;B(336)=332829142689;DIST(189)=02/14/18 08:08:03.401;RSI(99)=02/14/18 08:08:03.644;RSI_B=425762129535;PRS=RS1'

      ENTRY ver=1100 len=188 orig=168 lorig=0 oqid=00150015057d625700b06bd6000200b06bd500080000a88700860b3e0000000000000003 lqid=3888797:55:2 st=1 tr= '0015001505' }bN '000f' BHLINXeli '000000a800000000' comlen=63 commit transaction


Read more...

Environment

  • SAP Replication Server (SAP) 15.7.1
     
  • SAP Replication Server (SAP) 16.0
     
  • SAP Replication Server Real Time Loading (RTL) 15.7.1
     
  • SAP Replication Server Real Time Loading (RTL) 16.0

Product

SAP Replication Server 15.7 ; SAP Replication Server 16.0 ; SAP Replication Server, real-time loading edition 16.0 ; Sybase Replication Server 15.7, real-time loading edition

Keywords

IQ; RTL; HVAR; Latency; grouping; rs_ticket; CR 813577 , KBA , BC-SYB-REP , Sybase Replication Server (standalone) , Product Enhancement

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.