Symptom
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.
Read more...
Environment
- IQ 16 SP 10 PL 10
- IQ 16 SP 11
The issue was not on IQ 16 SP 4.
Product
Keywords
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.