How do I monitor open database sessions associated with Ingres ODBC connections?
Use the following steps to monitor open database sessions associated with Ingres ODBC connections:
1.
Login to the machine that contains the Ingres DBMS.
2.
su to the Ingres user.
3.
Execute the .profile associated with the Ingres user.
4.
cd into the bin sub-directory of the Ingres installation.
5.
Run this command: ./iinamu
6.
Pass this flag to iiname: SHOW
7.
Hit enter.
8.
Record the port number associated with your Ingres DBMS, e.g., 59543.
9.
Pass this flag to iiname: QUIT
10.
Run this command: ./iimonitor tcp_port For example: ./iimonitor 59543
11.
Pass SHOW ALL SESSIONS to display all DBMS activity.
12.
Type HELP to see variants of the SHOW command.