WebSphere

Manually creating a Derby event database

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
  1. 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.
  2. 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:
    • For Windows operating system Windows® systems: cr_event_derby.bat
    • For Linux operating systemFor UNIX operating system Linux® and UNIX® systems: cr_event_derby.sh
    • For i5/OS operating system iSeries® systems: cr_event_derby
  3. Optional: If you are configuring the database on an iSeries system, start the Qshell interpreter.
  4. 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
  5. 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.


task Task topic

Terms of use | Feedback


Timestamp icon Last updated: 22 June 2010


http://publib.boulder.ibm.com/infocenter/dmndhelp/v6r2mx/topic/com.ibm.websphere.cei.620.doc/doc/tcei_run_db_script_derby.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).