Running sysinfo
Getting Started with Derby
16
Most of the examples in this guide that show how to use the Derby scripts to launch
the Derby tools assume that you are using the embedded mode of the Derby database
engine. Use the instructions below to run the 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 Derby 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 Derby Server and Administration Guide and the Derby Reference Manual.
Running sysinfo
The Derby
sysinfo
tool displays information about your Java environment and your
version of Derby.
The
sysinfo
utility prints system information to a console.
Choose the method that you will use to run the
sysinfo
script. The methods are listed in
the following table.
Table 5.
Methods of running the
sysinfo
utility
Method
When to Use
Command
Run
sysinfo
as a standalone
command.
Use this method if
you are relatively
new to the Java
programming
language and new
to Derby.
Follow the steps in
before you run the
sysinfo
utility using this method.
To run the
sysinfo
script from the
command line, use:
sysinfo
The
sysinfo
script sets the appropriate
environment variables, including the
CLASSPATH, and runs the
sysinfo
utility.
Run
sysinfo
using the jar file
that is located in
the directory where
sysinfo
resides.
Use this method
if you are new to
Derby, but are
familiar with the
Java programming
language.
You must set the DERBY_HOME
environment variable before you can run
the
sysinfo
utility using this method.
On UNIX, the command is:
