ODBCLINK/SE Reference Manual (36217-90410)

ODBCLink/SE Reference Manual Troubleshooting
ODBCLink/SE
©M.B. Foster Associates Limited 1995-2000 55
Troubleshooting
Terminating an ODBC Connection
Occasionally it may be necessary to terminate an ODBC session that has deadlocked or is attempting to read a very
large table (note that rebooting the Client PC will not be sufficient as the server has control at this point). You may do
this from ISQL with the command TERMINATE USER user@account.
When an ODBC client terminates abnormally, the server process that handles the connection will normally go down
after the timeout interval has expired. This is typically 30 minutes to 2 hours.
On an HP-UX system, you can kill the process manually (if you know the process-id) with the command “kill -16
pid” (pid is the process id).
On MPE/iX you must either use the ISQL TERMINATE USER command or abort the listener job using the
ABORTJOB command.