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.