2642953 - What are IQ_MPX_SERVER_P* connections on multiplex coordinator in SAP IQ ? | SAP Knowledge Base Article

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.