Java DB Utility Scripts

The Java DB configuration that ships with Application Server 9 also includes several useful scripts which can help you use Java DB. The following scripts are available for use in the <appserver_install_dir>/javadb/frameworks/NetworkServer/bin directory:

• startNetworkServer.ksh/bat — Script to start the network server

• stopNetworkServer.ksh/bat — Script to stop the network server

• ij.ksh/bat — interactive JDBC scripting tool

• dblook.ksh/bat — Script to view all or part of the DDL for a database

• sysinfo.ksh/bat — Script to display versioning info regarding the Java DB environment

• NetworkServerControl.ksh/bat — Script which provides a means of executing commands on the NetworkServerControl API

To Configure Your Environment to Run the Java DB Utility Scripts

1. Set the DERBY_INSTALL environment variable to point to the <appserver_install_dir>/javadb directory.

2. Unset your CLASSPATH environment variable.

3. You can also optionally set the following properties:

   1. DERBY_SERVER_HOST to the host on which the network server will listen.

      Can also be set to 0.0.0.0 to enable all listeners.

   2. DERBY_SERVER_PORT to the port number on which the network server will listen.

See Also

For more information about these utilities, see the Derby Tools and Admin guides.