ODBCLink/SE Reference Manual

Troubleshooting

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.

ODBCLink/SE

 

©M.B. Foster Associates Limited 1995-2000

55

Page 65
Image 65
HP MPE/iX 6.x Operating System manual Troubleshooting, Terminating an Odbc Connection