Name | Synopsis | Description | Options | Examples | Exit Status | See Also
start-database [--dbhost host] [--dbport port-no] [--dbhome db-file-path] [--echo={false|true}] [ --terse ={false|true}]
The start-database command starts the Java DB server that is available with the Sun Java System Application Server software for use with the Application Server. Use this command only for working with applications deployed to the Application Server. Java DB is based upon Apache Derby.
When the Java DB database server is started by using this command, the database server is started in Network Server mode. Clients connecting to it must use the Java DB ClientDriver. For details on connecting to the database, such as the Driver Class Name and Connection URL, see the Apache Derby documentation.
When the database server starts, or a client connects to it successfully, the following files are created:
The derby.log file that contains the database server process log along with its standard output and standard error information
The database files that contain your schema (for example, database tables)
These files are created at the location that is specified by the --dbhome option. If the --dbhome option is not specified, the start-database command determines where to create these files as follows:
If the current working directory contains a file that is named derby.log, the start-database command creates the files in the current working directory.
Otherwise, the start-database command creates the files in the as-install/databases directory.
To create the database files at a particular location, you must set the --dbhome option.
The start-database command starts the database process, even if it cannot write to the log file.
This command is supported in local mode only.
The host name or IP address of the Java DB server process. The default is the IP address 0.0.0.0, which denotes all network interfaces on the host where you run the start-database command.
The port number where the Java DB server listens for client connections. This port must be available for the listen socket, otherwise the database server will not start. The default is 1527.
The absolute path to the directory where the database files and the derby.log file are created. If the --dbhome option is not specified, the start-database command determines where to create these files as follows:
If the current working directory contains a file that is named derby.log, the start-database command creates the files in the current working directory.
Otherwise, the start-database command creates the files in the as-install/databases directory.
To create the database files at a particular location, you must set the --dbhome option.
Setting to true echoes the command line statement on the standard output. Default is false.
Setting to false displays detailed database information. Default is false.
The following command starts Java DB on the host host1 and port 5001:
asadmin> start-database --dbhost host1 --dbport 5001 --terse=true Starting database in the background. Log redirected to /opt/SUNWappserver/databases/derby.log. |
The exit status applies to errors in executing the asadmin command. For information on database errors, see the derby.log file.
command executed successfully
error in executing the command
Name | Synopsis | Description | Options | Examples | Exit Status | See Also