Re: net statistics from shared memory ?

On 6 Aug, 20:10, "Floyd Wellershaus" <fl...@fwellers.com> wrote: > We are currently running our c programs through esqlc and also shell scripts. They attach to the database SERVER that is associated with shared memory. > > In the near future we are going to separate the database server from the application server, which means that all the talking back and forth and passing of data back and forth between the app and the database will be going across a lan. > > We're trying to get a handle on how much traffic that would be. Is there a way to gather those type of statistics from the database ? I'm thinking one of the onstat -g ntd or nsd or something. > > Thanks ! > Floyd Well onstat -g nsc gives you reads/writes. Otherwise convert a test environment to using TCP/IP even if via the local TCP address (NOT the 127 loopback address as they packets do not go down and up the network stack and so potentially may not be sniffable on your platform) and sniff network traffic. You may need to tune the buffer size option in the sqlhosts file. Also you may need to tune the size of client fetch/insert buffers via FET_BUF_SIZE/FetBufSize as per http://publib.boulder.ibm.com/infocenter/idshelp/v115/index.jsp?topic=/com.ibm.esqlc.doc/sii-14-39987.htm.