SAP Knowledge Base Article - Preview

3196398 - IQ connections with open cursor cannot be dropped - SAP IQ

Symptom

  • IQ connections with open cursor cannot be dropped. 
  • These connections come from an SAP Adaptive Server Enterprise (ASE) server.
  • Client processes in ASE cannot be killed with the regular KILL command.
  • We didn't try to kill client processes with the WITH FORCE option in SAP ASE.


Read more...

Environment

SAP IQ 16.1

Keywords

kill, active, OPENCURSOR,  sp_iqtransaction, sp_iqlocks, sp_iqconnection, sp_iqcontext, sp_iqversionuse , 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.