Starting a Cluster Database

The ESP installer creates a cluster database during installation. To deploy and start a cluster, first start the database.

Procedure

Start the cluster database by running the following command, and providing your own values for the parameters in brackets.
```
start dbsrv16 -n <server-name> <database-file> -n <database-name>
```
where
- <server-name> is the name of the database server.
- <database-file> is the name of the database file. If you want to run the database created by the installer, set <database-file> to $STREAMING_HOME/cluster/config/ESP1/esp_cluster.db
- <database-name> is the database name.
For example:
```
start dbsrv16 -n cluster_example_myhost cluster_example.db -n cluster_example
```
This starts the database with a server name of cluster_example_myhost and a database name of cluster_example.
Note If you need to start the database in a different port, use the -x option. For example,
```
start dbsrv16 -n my_server -x "tcpip(PORT=6872)" -su sql "C:\tmp\ASA\SQLA\Bin64\db2\db.db"
```
Modify the cluster bootstrap file cluster_example.cfg to provide database- and cluster-related information.
The following information is required:
- jdbc-username - the database user name
- jdbc-password - the database password
- cluster-name - the cluster name, used to name the cluster
- cluster-password - the cluster password
If the database is not running on the default port (2638), or on the local cluster, also modify the jdbc-url property by replacing the host and/or port value.
Start the cluster node by running the start_node script. You can specify the node to start by using the node name as the first argument for the start_node script. For example:
```
$STREAMING_HOME/cluster/config/esp1/start_node node1
```