Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Hi I want
to write a query in sysmaster to
get the following information:-
netscb thread name sid open read write address
2605cdc0 sqlexec 3109 17:59:55 18:00:22 18:00:22
the above is taken from onstat -g ntt
I am interested in open, read and write time which I believe
pertains to connection open time, last read operation time of connection
and last write operation time of connection.
I need it to 'prove' to our developers that there is a connection
leak in their code which causes useless connection to sit idle
doing nothing for hours, while new connections are acquired all the time.
This is eventually leading to informix crash.
oh yeah,it is a battle between DBA and developers :-)
thanks in advance.
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.