Question about ODBC connections.
Posted in 2003
Hello,
Informix 9.3
ODBC Driver 3.34 or 3.80
Platform Solaris 8
Have a question about being able to monitor the ODBC connections made to a Sun
Server running Informix DB 9.3 or at least validate the connections are
proper. In an MTS/XA environment where the transaction is dependent upon two
separate servers responses returning valid return codes in order to complete
the transaction, I am trying to monitor the connections established to
Informix because we are timing out trying to connect via ODBC. I have already
tried onstat u, onstat g sql, onstat g ses, but they are not at the
appropriate level of information. Trying to find a better way to monitor
performance and how long the ODBC connection takes from the point of commit at
the top level of the transaction to the actual point of thread established via
sqlexec. Any help would be greatly appreciated.
Jerrett Levensalor