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

Search for additional results

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