Java DB

Apache Derby

Derby Server and Administration Guide

Derby Getting Started
Derby Reference Manual
Derby Developer's Guide
Derby Performance Tuning
Derby Server and Admin Guide
Derby Tools and Utilities
Derby Server and Admin Guide
-Part one: Derby Server Guide
-Derby in a multi-user environment
-Using the Network Server with preexisting Derby applications
-The Network Server and JVMs
-Installing required jar files and adding them to the classpath
-Starting the Network Server
-Shutting down the Network Server
-Obtaining system information
-Accessing the Network Server by using the network client driver
-Accessing the Network Server by using a DataSource object
-XA and the Network Server
-Using the Derby tools with the Network Server
-Differences between running Derby in embedded mode and using the Network Server
-Setting port numbers
-Managing the Derby Network Server
-Managing the Derby Network Server remotely by using the servlet interface
-Derby Network Server advanced topics
-Derby Network Server sample programs
-Part two: Derby Administration Guide
-Checking database consistency
-Backing up and restoring databases
-Replicating databases
-Logging on a separate device
-Obtaining locking information
-Reclaiming unused space

 

Obtaining system information

You can obtain information about the Network Server, such as version and current property values, Java information, and Derby database server information, by using the sysinfo utility. The sysinfo utility is available from scripts, the command line, the NetworkServerControl API, and through the servlet interface.

The following scripts are located in the $DERBY_HOME/bin directory. Before running these scripts, make sure that the Derby Network Server is started.

  • Run the following script to obtain information about the Network Server on a Windows system: 
    NetworkServerControl.bat sysinfo [-h hostname][-p portnumber]
  • Run the following script to obtain information about the Network Server on a UNIX system: 
    NetworkServerControl sysinfo [-h hostname] [-p portnumber]

For more information on the sysinfo utility, see the Derby Tools and Utilities Guide.

You can also use Java Management Extensions (JMX) technology to obtain system information. For details, visit the wiki page http://wiki.apache.org/db-derby/DerbyJMX and refer to the API documentation for the packages org.apache.derby.mbeans and org.apache.derby.mbeans.drda. For information on JMX technology, see http://java.sun.com/javase/technologies/core/mntr-mgmt/javamanagement/.

 

javadb@jdbcurl.com