SAP Knowledge Base Article - Preview

2146660 - DBISQL can not connect to server with different CommBufferSize - SAP IQ

Symptom

IntractiveSQL(DBISQL) cannot connect to the IQ server with a different CommBufferSize via shared memory.
DBISQL stops not able to connect to the IQ server.

ex:
-p(CommBufferSize) = 64000

[params.cfg]
-p 64000

[iqmsg]
I. 03/24 10:45:41. 0000000000 IQ full cmd line: -n iqdemo -x tcpip{port=2638} -c 48m -gc 20 -gd all -gl all -gp 4096 -p 64000 iqdemo -gm 10 -ti 4400 -tl 0 -gn 25 -o /opt/sap/IQ-16_0/logfiles/iqdemo.0021.srvlog -hn 5
I. 03/24 10:45:41. 0000000000 DB: r/w, Main 63MB Buffs=509, Temp 63MB Buffs=509, Pgsz=131072/8192blksz/16bpc, BP=1
I. 03/24 10:45:41. 0000000000 DB: Frmt#: 23F/2T/1P (FF: 03/18/1999)
I. 03/24 10:45:41. 0000000000 DB: Versn: 16.0.0.807/140804/P/sp08.03/Enterprise Linux64 - x86_64 - 2.6.18-194.el5/64bit/2014-08-04 18:42:22
I. 03/24 10:45:41. 0000000000 DB: Name:  /opt/sap/IQ-16_0/demo/iqdemo.db


[dbisql]

[sapuser@ demo]$ dbisql -c "uid=dba;pwd=sql;eng=iqdemo" -nogui

Suspended


Read more...

Environment

  • SAP IQ 16.0 SP08 or later
  • SAP IQ 16.1

Product

SAP IQ 16.0

Keywords

IQ, "SAP IQ", CR781617, CR776538, "-p" , 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.