SAP Knowledge Base Article - Preview

2503677 - proxy table performance degradation post upgrading from 15.4 to 16 SP11 - SAP IQ

Symptom

  • Queries that insert or update data in IQ  proxy tables , pulling in data from a remote server like SAP ASE.

  • Post upgrading from IQ 15.4 to IQ 16 SP11 ,  the performance of these queries degrades significantly.

  • Updates of proxy tables in IQ 16 SP11 upwards are slow in general , regardless of if this is an upgraded IQ server or not.

Read more...

Environment

  • SAP IQ 16.0 SP11 on all platforms
  • SAP IQ 16.1 on all platforms

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.4

Keywords

proxytab, "create existing", sybase, CR804194, #804194, 804194, CR794251, #794251, 794251, slow, stuck, hang, slower, bad, CIS, ASA, "Adaptive Server", IQ15, IQ16, ASEODBC , KBA , BC-SYB-IQ , Sybase IQ , Problem

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.