SAP Knowledge Base Article - Preview

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


  • 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.



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


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


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.