HP MPE/iX 6.x Operating System manual To determine whether or not the listener job is running

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	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

ODBCLink/SE
©M.B. Foster Associates Limited 1995-2000	9