Use the cr_event_derby command to manually
generate a database configuration script for a Derby event database
About this task
To manually run the generated database configuration script
for a Derby event database:
Procedure
- On the server system, go to the directory containing the
generated script. The default location is the profile_root/databases/event/node/server/dbscripts/derby
directory; if you specified a value for the outputScriptDir parameter
of the database configuration administrative command, the scripts
are stored in that location instead.
- Using an ASCII text editor, make any required modifications
to the configuration script. The name of the script varies
depending upon the operating system in use:
Windows® systems:
cr_event_derby.bat

Linux® and UNIX® systems: cr_event_derby.sh
iSeries® systems:
cr_event_derby
- Optional: If you are configuring the database
on an iSeries system, start
the Qshell interpreter.
- Run the database creation script using the following syntax
(remember to specify the file extension, if applicable):
cr_event_derby -p profile_path [-s server_name|-c cluster_name]
The
parameters are as follows:- -p profile_path
- The path to the WebSphere® profile
directory. This parameter is required.
- -s server_name
- The name of the server. This parameter is required if you are
configuring the database at the server scope.
- -c cluster_name
- The name of the cluster. This parameter is required if you are
configuring the database at the cluster scope.
For example, the following command would create
the Derby database at the scope of the server1 server, using the profile
profile1:
cr_event_derby -p c:\WebSphere\appserver\profiles\myprofile -s server1
- Restart the server. For a federated node, you
must also stop and restart the node agent using the stopNode and startNode commands.
What to do next
After you finish configuring the database, you can use
the administrative console to test the database configuration. To
do this, navigate to the appropriate JDBC data source and select the Test
Connection option.