Symptom
On execution of sp_iqconnection on coordinator, sometimes you will see quite a few internal connections that begin with "IQ_MPX_SERVER_P".
Example of sp_iqconnection output:
ConnHandle Name
...
NodeAddr LastIdle MPXServerName
-------------------------------------------------------------------------------------
184361 IQ_MPX_SERVER_P1317
...
XX.XX.XXX.XXX 7724 SecondaryNode2
184362 IQ_MPX_SERVER_P1318
...
XX.XX.XXX.XXX 8788 SecondaryNode2
184363 IQ_MPX_SERVER_P1319
...
XX.XX.XXX.XXX 8356 SecondaryNode2
184374 IQ_MPX_SERVER_P1091
...
XX.XX.XXX.XXX 9375 SecondaryNode3
Read more...
Environment
- SAP IQ 16.0
- SAP IQ 16.1
Product
Keywords
sybase ; mpx ; multiplex ; cn ; , 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.
SAP Knowledge Base Article - Preview