Workaround – Set the -gn server startup flag.
Calculate GNn considering the number
of multiplex servers (Sn), the
INC connection pool size on each
secondary server (see database option
Mpx_Max_Connection_Pool_Size, which
defaults to 10 (INCPn)), and the
number of user connections (GMn). The
formula is:
GNn = (Sn * INCPn) + GMn + 5
For example, if you have 20 multiplex servers with a
Mpx_Max_Connection_Pool_Size of 10
and -gm is set to 50, then you set
-gn to 255.
If you are running the coordinator on a host that has
greater than 32 cores, then you must set
-iqmt. Make sure that the value
of -iqmt is less than (4000 -
(GNn + 200)) to ensure that the total
number of threads spawned by IQ does not exceed
4000.