[TRAFODION-2695] SSMP process ($ZSMxxx) sees too many opens from the master process To avoid hanging deadlocks in the IPC layer a SQL Error warning 2026 is now returned when the application attempts to have more than 14 statements opened at the same time from a JDBC/ODBC connection
Maximum Nowait depth is 16. We need to spare 2 slots - One to send query finished message and the other to get the response for the pending nowaited query started message.
[TRAFODION-2695] SSMP process ($ZSMxxx) sees too many opens from the master process Mxosrvr/Any master process opens a connection to mxssmp for the following: 1) For get statistics command Managed via ssmpManager_ in the context. This can have connections to all the ssmps in the cluster
2) To cancel a query Was managed via cbServer_ in ExCancelTcb. This connection was expected to go away when the cancel is passed on the mxssmp.
3) To Send query started /Query finished message Was managed via cbServer_ in ContextCli. If this cbServer_ was taken up already by the query with query started message pending, every statement being executed would have created a connection to ssmp and managed via cbServer_ in ex_root_tcb of the query
In an ssmp core there were many opens from a mxosrvr. To avoid many open connections, all the ssmp connections are now managed via ssmpManager_ in the default context. This connection is shared by multiple message streams by increasing the no-wait depth.