In Informix Server how can I confirm my NETTYPE settings have taken effect
Question
With IBM® Informix® Server™ how can I confirm my updated NETTYPE settings have been taken into effect?
Answer
This can be established with onstat -g ntu or onstat -g ntt output, by reviewing the q-limitsvalue which is displayed in the header section of the results. This value represents the size of a pre-allocated array used to store information about client connections.
The value is calculated as 100 + (poll_threads * 0.7 * num_connections).
Example 1
$ onstat -c | grep ^NETTYPE
NETTYPE soctcp,1,233,NET
Using the formula above: 100 + (1 * 0.7 * 233) = 263
$ onstat -g ntt | head -6
IBM Informix Dynamic Server Version 11.70.FC4 -- on-Line --
global network information:
#netscb connects read write q-free q-limits q-exceed alloc/max
9/ 10 3 25 25 1/ 1 263/ 10 0/ 0 1/ 1
Example 2
$ onstat -c | grep ^NETTYPE
NETTYPE tlitcp,2,500,NET
Using the formula above: 100 + (2 * 0.7 * 500) = 800
$ onstat -g ntt | head -6
IBM Informix Dynamic Server Version 11.70.FC4 -- on-Line --
global network information:
#netscb connects read write q-free q-limits q-exceed alloc/max
9/ 9 0 0 0 0/ 0 800/ 10 0/ 0 0/ -1
As an alternative to using onstat, you can query sysmaster:sysnetglobal and review the value for column ng_free_thres.