tjaartv
Programmer
- Mar 31, 2004
- 19
Does anyone know how I can monitor who is connected with ODBC on cms?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Monitor ODBC connections
- Thread starter tjaartv
- Start date
- Status
ReallyRotten
MIS
If you have shell access in CMS, and are running Informix 2000, I monitor people by running this command:
ps -ef | grep inf
Or if you are using an Openlink ODBC broker, go to /usr/openlink/bin and run ./oplshut - that will tell you what IP addresses are connected. Always select n when you are asked if you want to continue to shut the broker down (unless you actually want to shut the broker down).
Or, if you know what ports ODBC is supposed to connect to (ours are 5000 and above), you could run netstat -a and see who is connected to port 5000 and above.
Hope this helps!
ps -ef | grep inf
Or if you are using an Openlink ODBC broker, go to /usr/openlink/bin and run ./oplshut - that will tell you what IP addresses are connected. Always select n when you are asked if you want to continue to shut the broker down (unless you actually want to shut the broker down).
Or, if you know what ports ODBC is supposed to connect to (ours are 5000 and above), you could run netstat -a and see who is connected to port 5000 and above.
Hope this helps!
- Status