ODBCLink/SE Reference Manual | Preparing the Database Server |
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 | 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 |
/opt/allbase/bin/odbcse/odbclnse stop | On |
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
ODBCLink/SE |
|
©M.B. Foster Associates Limited | 9 |