Re: Delay in commands returning

Neil Truby wrote: > Delay before resonding to commands. > > On a certain server type (Sun M9000), and maybe others, I get about a > second's delay issuing any onstat command ... even onstat -m. See > below, took about one second. > > On any other server - a Sun v890, a Linux server, it takes a few > millseconds. > > I've tried a shared-memory rather than TCP/IP connection. No difference. > > It doesn't seem to be causing any issue, I'm just curious ... > > Thanks > Neil As someone else already said, execute onstat through truss to get a protocol of the system calls: truss -D -o /tmp/truss.out onstat - The first column in /tmp/truss.out contains a float value representing the time delta in seconds. For more see "man truss". Regards, Frank

Hello Neil, I am going to guess that you allocated a large amount of your Sun M9000's memory to Informix. It may take a second to read all that memory (or even part of it) to give you an answer. Another guess is that the many lines of Informix engine code interact with the many lines of Sun operating system code causing a 1 second delay on a Sun M9000. This maybe something you will have to live with or require some Sun tuning. Right or wrong, I am very curious of what you will eventually find out. -L.S.

On 26 Oct, 20:14, LIGHT SCANS <light_sc...@yahoo.com> wrote: > Hello Neil, > > I am going to guess that you allocated a large amount of your Sun > M9000's memory to Informix.  It may take a second to read all that > memory (or even part of it) to give you an answer.  Another guess is > that the many lines of Informix engine code interact with the many > lines of Sun operating system code causing a 1 second delay on a Sun > M9000.  This maybe something you will have to live with or require > some Sun tuning. > > Right or wrong, I am very curious of what you will eventually find > out. > > -L.S. Try running onstat -i then see how long command like p or s take to return, it could be the time taken to attach to shared memory that is the problem. Also at least for version 7 onstat reads message files under $INFORMIXDIR/msg and $INFORMIXDIR/gls and that can take time to return. Try the "truss -d onstat -" and what did that return? david.