SAP Knowledge Base Article - Preview

2816976 - further information on request type PREFETCH - SAP IQ


  • Running the sp_iqconnection stored procedure may see connections in a state where the ReqType value is PREFETCH
  • Detecting a high number of prefetch connections in IQ 16.1
    • Is this normal? Is this controlled by any option?
    • The Prefetch option seems to be for catalog or it also apply to IQ store?



  • SAP IQ 15.4
  • SAP IQ 16.0
  • SAP IQ 16.1


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


sybase, 'pre fetch', 'pre-fetch', controlled, ddisql, isql, clients, users, application, hung, troubleshoot, 'trouble shoot', investigation, 'how to', documented, manuals, SAPIQ, information, high, number, meaning, proc, , 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.