CLI Reference Guide

ODBCLink/SE Reference Manual Preparing the Database Server
ODBCLink/SE
©M.B. Foster Associates Limited 1995-2000 9
To determine whether or not the listener job is running:
On the HP3000 database server, enter:
SHOWJOB JOB=@J
The resulting display will besimilar to the following:
JOBNUM STATE IPRI JIN JLIST SCHEDULED-INTRO JOB NAME
#Jnnn SCHED 8 10S LP 12/ 6/00 4:00 ODBCLNSE,MANAGER.SYS
On the HP9000 database server, enter:
# ps -ef | grep odbclnse
The resulting display will be something like this:
root 7223 1 0 15:37:15 ? 0:00 /usr/bin/odbcse server
paw 7226 7223 0 15:40:56 ? 0:00 /usr/bin/odbcse server
root 7238 7230 1 15:41:29 ttys2 0:00 grep odbcse
The first line shows the server running. The second line shows a user with a login of “paw” is using the server and the
last line shows the command you just entered.
To stop the listener:
On the HP3000 database server, enter:
ODBCLNSE.ODBCSE.SYS STOP
Note: If there is a connection open when the stop command is
issued the process will not be stopped. If you are not able to
stop the listener in the normal way, or if you want to
terminate active ODBC client sessions, you may abort the
listener Job with the :ABORTJOB command
On the HP9000 database server, enter:
/usr/bin/odbcse/odbclnse stop On HP-UX 9.x
/opt/allbase/bin/odbcse/odbclnse stop On HP-UX 10.x and 11.x
Note that in Unix, the STOP command will prevent any new connections but will not affect connections that were
active at the time the command was issued.
You may also use the following command to stop the listener. It is, however, strongly suggested that you use the
“odbcse stop” command to stop the listener.
kill -16 “pid” where “-16" is the “siguser1" and “pid” is the process ID number