Java DB Utility Scripts

The Java DB configuration that ships with Application Server 8.2 also includes several useful scripts that can help you use Java DB. The following scripts are available for use in the appserver_install_dir/derby/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 information regarding the Java DB environment

• NetworkServerControl.ksh/bat – Script that provides a means of running 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/derby directory.

2. Unset your CLASSPATH environment variable.

3. (Optional) You can also set the following properties:

   • Set 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.

   • Set 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.