HPlogo HP Driver for JDBC User's Manual: HP 3000 MPE/iX Computer Systems > Chapter 3 Installation

Starting and Stopping HP JDBC Monitor

» 

Technical documentation

Complete book in PDF
» Feedback

 » Table of Contents

 » Index

HP JDBC Monitor is the server-side counterpart of HP Driver for JDBC, present on the client-side. For a JDBC application to connect to a database, the JDBC Monitor must be running on the database server. JDBC Monitor can be started manually or automatically at system startup by including the JDBC Monitor start commands in the system startup scripts.

HP-UX Monitor Startup and Shutdown

The startup and shutdown of the HP-UX JDBC Monitor is normally controlled by the system startup and shutdown scripts. Thus as long as the machine is up and running, the JDBC Monitor will also be up.

The only time the Monitor should ever be brought down is to install a newer version. In this case, use the monctrl command to kill the Monitor process. Do not use the UNIX kill command, as this could render the server unable to start a new Monitor process. The monctrl command to shut down the monitor is:

monctrl kill [portnumber]

The portnumber parameter is necessary only if the monitor you wish to shut down is not running on the default port number 31700.

To restart the monitor after it has been accidentally terminated or was shut down, use the monctrl command to start it up:

monctrl start [portnumber]

Again, the portnumber parameter is necessary only if you wish to start the monitor on a port number other than the default port number 31700.

You cannot start a monitor on the same port number as a currently running monitor. You also can not re-start a monitor on its original port number until all child processes that were spawned by the previous monitor process are terminated, and the port released. If the monitor is intentionally terminated or accidentally terminates, all of its child processes must be terminated before it can be restarted. For this reason, the monitor must not be terminated by using the UNIX kill command. Always use the monctrl tool to kill the monitor. The tool will search out all the child processes and kill them first, before killing the monitor.

MPE/iX Monitor Startup and Shutdown

The startup and shutdown of the MPE/iX HP JDBC Monitor is normally done by the startup and shutdown stream jobs, JSTRTMON and JSTOPMON, which are normally included in MPE/iX system startup and shutdown scripts. Thus as long as the machine is up and running, the JDBC Monitor will also be up.

The only time the monitor should ever be brought down is to install a newer version. In this case, use the JSTOPMON stream job or ABORTJOB command to kill the monitor process. The ABORTJOB command to shut down the monitor is:

: ABORTJOB #JXX

where XX is the job number.

To restart the monitor after it was accidentally terminated or shut down, use the JSTRTMON stream job to start it up.

: STREAM JSTRTMON.JDBC.SYS

On the MPE/iX platform, each client connection is serviced by a separate process that is in the same session as the monitor. Thus, if the monitor is terminated or dies, the existing server process already serving the client requests will also die. This could result in client applications experiencing dropped connections.

For a complete listings of JDBC Monitor log file, please refer to Appendix B “JDBC Monitor”

Feedback to webmaster