SAP Knowledge Base Article - Preview

2831533 - replication to IQ after new connection was created using insert...location - SAP IQ

Symptom

Though replication to IQ is working, but the performance is bad.

  • A new connection to an IQ system that was created using insert location.
     
  • Items noticed on Replication:

Dump transaction is processing very slowly.  

begin transaction
dump transaction MYdb '20XX0826 15:41:02:946' 0x010f466210000000000000000000000032303139303832362031353a34
commit transaction

  • admin who,sqm  -- shows that the connection is progressing:
    • The lag in the outbound queue is growing.
    • Configurations between the old connection and the new connection have not changed.

  • On the IQ msg log:
    Transactions are taking too long to commit - it can take several minutes to commit just a few records.


Read more...

Environment

  • SAP Replication Server 15.7
  • SAP Replication Server 16.0
  • SAP IQ 16.0
  • SAP IQ 16.1

Product

SAP IQ 16.0

Keywords

KBA , BC-SYB-IQ , Sybase IQ , 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.