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. includes a set of scripts that you can use to start the tools. The scripts are located in the /bin directory. These scripts also help you set up your classpath.

See

To show how to use the scripts to launch the tools, most of the examples in this guide assume that you are using the embedded mode of the database engine.

Running the scripts with the Network Server

The scripts are designed to run in embedded mode. To run these tools with the Network Server, use the following commands:

  • For the dblook tool, call the script and specify the -d option and the full URL to the Network Server database. For example: dblook -d 'jdbc:derby://localhost/myDB;user=usr'
  • 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 sysinfo tool, issue the command NetworkServerControl sysinfo

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

In addition, there are 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 .