Java DB Utility Scripts

These scripts are deprecated in Application Server 9.1.

The Java DB configuration that ships with Application Server 9.1 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.