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 for Me (Login required).

Search for additional results

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