Skip to Content

Multiplex dbo connections queueing up

Hi All

I most probably need to log an indecent but I just need to get my head around the multiplex inner workings.

We have an IQ 15.4 ESD4.3 multiplex with 3 nodes (1 Query 2 Writer with Coordinator on the one 1 Writer)

As a norm there are 2 dbo connections named IQ_MPX_SERVER_H0 open from each node on the coordinator. When all is well there will be new connections created as

IQ_MPX_SERVER_Pnnn for each node , They execute and go away. Lately we get these connections queuing up and taking a long time to resolve.

This means that the iqgovern slots fill up and the server grinds to a crawl.

Can anybody explain the the process the multiplex follows and what these connections are doing or potentially waiting for?

regards

Johan Bornman

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 09, 2015 at 02:25 PM

    Hi Johan,

    They are related to Internode communications (Heartbeat and Pooled)

    http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc01839.1604/doc/html/san1278444293091.html

    Regards,

    Tayeb.

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Mark

      Just on these connections. What does it mean if the ReqType = PREFETCH? I see this a lot for these connections and even other connections if the server is very busy

      regards

      Johan Bornman