SAP Knowledge Base Article - Preview

2642953 - What are IQ_MPX_SERVER_P* connections on multiplex coordinator in SAP IQ ?

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

SAP IQ 16.0

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.