Using the <ph conref="../conrefs.dita#prod/productshortname"></ph> tools and startup utilities There are several tools and utilities that you might want to use as you begin to work with . Derbyscripts, using Derbytools, usingtoolsin Derbyscriptsin Derby Derbysystem proceduressystem proceduresin Derby

The tools that are included with are dblook, ij, and sysinfo. To run these tools see:

includes a set of scripts that you can use to start these tools. In addition, there are scripts for booting the Network Server. The scripts are located in the /bin directory. When you run these scripts, your CLASSPATH environment variable is set if you have not already set it, and remains set as long as you are running the tool.

Most of the script examples in this guide assume that you are using the embedded mode of the database engine. Use the instructions below to run the tools scripts with the Network Server.

Running the scripts with the Network Server

To run the scripts with the Network Server, use the following commands:

  • For the sysinfo tool, issue the command NetworkServerControl sysinfo
  • For the ij tool, issue the command set DERBY_OPTS=-Dij.protocol=jdbc:derby://localhost/ and then start ij by issuing the command ij.
  • For the dblook tool, call the script and specify the -d option and the full connection URL to the Network Server database. For example: dblook -d 'jdbc:derby://localhost/myDB;user=usr'

Additional <ph conref="../conrefs.dita#prod/productshortname"></ph> utilities

In addition, there are Derby utilities that are system procedures that you can call by using the ij tool. For example, there are system procedures that you can use to import and export external files. Instructions on how to use these system procedures are included in the and the .