To Stop the Database

The local stop-database command enables you to stop Java DB on a specified port. A single host can have multiple database server processes running on different ports.

1. If necessary, notify users that the database is being stopped.

2. Stop the database by using the stop-database(1) command.

Example 5–2 Stopping a Database

The following example command stops Java DB on port 5001 of localhost:

asadmin stop-database --dbhost=localhost --dbport=5001

Information similar to the following is displayed:

onnection obtained for host: localhost, port number 5001.
Apache Derby Network Server - 10.2.2.1 - (538595) shutdown at 2008-10-17 23:34:2
7.218 GMT
Command stop-database executed successfully.

Troubleshooting

For a laptop that roams between networks, you might have trouble shutting down the database. If you start Java DB and then change your IP address, you will not be able to stop Java DB unless you add a specific --dbhost argument. For example, if you run asadmin start-database --dbhost = 0.0.0.0, and then disconnect Ethernet and switch to wifi, you should run a command similar to the following to stop the database:

asadmin stop-database --dbhost localhost

See Also

To see the full syntax and options of the command, type asadmin stop-database --help at the command line.