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:
- Login to the machine that contains the Ingres DBMS.
- su to the Ingres user.
- Execute the .profile associated with the Ingres user.
- cd into the bin sub-directory of the Ingres installation.
- Run this command: ./iinamu
- Pass this flag to iiname: SHOW
- Hit enter.
- Record the port number associated with your Ingres DBMS, e.g., 59543.
- Pass this flag to iiname: QUIT
- Run this command: ./iimonitor tcp_port For example: ./iimonitor 59543
- Pass SHOW ALL SESSIONS to display all DBMS activity.
- Type HELP to see variants of the SHOW command.