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.

http://www-01.ibm.com/support/docview.wss?uid=swg21592040