SAP Knowledge Base Article - Preview

2325830 - IQ could start with -tl 0 while default is 2 mins - SAP IQ16 SP10.x


By default, the liveness time out is 2 mins for IQ to check for client connection liveness every 2 mins.

On IQ16 SP10.x, IQ starts without liveness time out check: -tl 0.
Thus dead connections could be still considered as alive and still listed in sp_iqconnection until IQ shutdown.

This could cause "Max connections exceeded" error and new conenctions wouldn't be able to be established.



  • IQ 16 SP 10 PL 10
  • IQ 16 SP 11

The issue was not on IQ 16 SP 4.


SAP IQ 16.0


CR 797461 ; 797461 ; -tl 0 ; liveness time out ; sp_iqconnection ; dead ; connections ; default.cfg ; , 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 for Me (Login required).

Search for additional results

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