The ESP installer creates a cluster database during
installation, and prompts you to enter a user name and password for this database. The
cluster database created by the
installer
contains a single node. If you wish, you can also create your own cluster database, by
following the cluster example under
STREAMING_HOME\cluster\examples. However if you
create a cluster database, you will need to deploy a cluster configuration file to it using
streamingclusternode.
Procedure
- Create the cluster database by running the following command and providing your own values for
the parameters in brackets.
This step is required if you want to create a new database rather than using the database file
created by the installer.
dbinit -dba <username>,<password> <database-file> -t <transaction-log-file>
where
- <username> is the initial administrator user name.
- <password> is the initial administrator user
password.
- <database-file> is the name of the database file to be
created.
- <transaction-log-file> is the name of the transaction
log file for database.
For
example:
dbinit -dba DBA,sql cluster_example.db -t cluster_example.log
- Start the cluster database by running the following command, and providing your own values
for the parameters in brackets.
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.
- <database-name> is the database name.
For example:
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.
- Create tables
By following the cluster_example and making your own modifications, you have created
a cluster database. You can now deploy or migrate cluster configuration data to
the database, and then start the node. From there, you can use
SAP ESP Cockpit to manage cluster
configuration.