WebSphere

Configuring a Derby event database

You can configure a Derby event database at the server or cluster scope on a Linux®, UNIX®, or Windows® system.

About this task

There are two types of Derby databases that you can use for the event database: Derby Embedded and Derby Network. Both types are shipped with WebSphere® Application Server, but they have limited functionality that is not suitable for a production environment. You should, therefore, use Derby as the event database only for purposes such as development or testing. For more information on the Derby databases, see the WebSphere Application Server documentation (linked to at the bottom of this page).

Derby Embedded can only be used with a stand-alone server. Consequently, if you ever federate your stand-alone server to a cluster or ND environment, then you will need to completely re-configure your event data source with another database product. It will automatically start when you start the server.

Derby Network can be used in a clustered or ND environment, although it should still be avoided in use with actual production systems. You need to manually start the database to use it with the server.

To configure a Derby event database:

Procedure
  1. Start the wsadmin tool.
  2. Use the AdminTask object to run the configEventServiceDerbyDB administrative command in batch or interactive mode. The minimum required parameters of the configEventServerDerbyDB command are as follows:
    createDB
    Indicates whether the administrative command should create and run the database configuration scripts. Specify true or false. If this parameter is set to false, the scripts are created but are not run. You must then run the database configuration scripts to complete the database configuration.
    nodeName
    The name of the node that contains the server where the event service data source should be created. If you specify a node name, you must also specify a server name. You must specify one of the following:
    • node name and server name
    • cluster name
    serverName
    The name of the server where the event service data source should be created.
    clusterName
    The name of the cluster where the event service data source should be created. If you specify a cluster name, do not specify node and server names.

    Other parameters might be required for your environment. For a complete list of parameters and usage information, refer to the help for the configEventServiceDerbyDB administrative command.

Results

The administrative command creates the required data source at the specified scope; if you specified true for the createDB parameter, the command also runs the generated database configuration script to create the database.

The generated database configuration scripts are stored by default in the profile_root/databases/event/node/server/dbscripts/derby directory. (In a Network Deployment environment, these scripts are stored under the deployment manager profile directory.) If you specified a value for the optional outputScriptDir parameter, the scripts are stored in that location instead. You can use these scripts to manually configure the event database at any time.


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_configure_derby.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).