Choosing a method to run the <ph conref="../conrefs.dita#prod/productshortname"></ph> tools and startup utilities There are several ways that you can run the tools and startup utilities. Derbytools, running toolsin Derby

The method that you choose to run the tools and utilities determines the environment variables that you set for .

 Choose the method that you want to use. The methods are listed in the following table. Methods of running the <ph conref="../conrefs.dita#prod/productshortname"></ph> tools and utilitiesThis table lists the various methods of running the tools and describes when to use each as well as the required prerequisites for running them. Method When to Use Requirements Run the tools using the command shell scripts that are provided with . Use this method when you want to run the tools with the least amount of typing and have installed the full bin distribution of .
  • Set the environment variable
  • Include the location of the java executable file (usually JAVA_HOME\bin) in the PATH environment variable
  • Include the \bin directory in the PATH environment variable
 Run the tools using the derbyrun.jar archive file. Use this method when:
  • You have only the jar files available (see ), and do not have the full bin distribution of
  • You do not want to use the scripts that are provided with
  • Set the environment variable
  • Include the location of the java executable file (usually JAVA_HOME\bin) in the PATH environment variable

The derbyrun.jar file must be in the same folder as the other .jar files.

For more information, see .

 Run the tools using the complete java syntax, or use in a Java program. Use this method when:
  • You do not have the derbyrun.jar file or the scripts installed
  • You want to learn the full syntax of each command and understand the details of setting up the execution environment
  • You are developing application programs with
  • Set the environment variable
  • Include the location of the java executable file (usually JAVA_HOME\bin) in the PATH environment variable
  • You must know the full package name for the Java class that supports the tool
  • The CLASSPATH environment variable must be set to include the required JAR files

For details on setting the CLASSPATH, see .
Based on the requirements of the method that you chose to run the tools, follow the instructions to set the environment variables.