WebSphere

Configuring a SQL Server event database

You can configure an external event database using Microsoft® SQL Server Enterprise on a Windows® system.

About this task

To configure a SQL Server event database:
Procedure
  1. On the SQL Server database server system, create the directory used to contain the database files. By default, the files are written to the c:\program files\ibm\event\ceiinst1\sqlserver_data directory. If you need to specify a different location, you must edit the generated database configuration script to modify the value of the ceiInstancePrefix parameter, and then run the script manually.
  2. On the server system, start the wsadmin tool.
  3. Use the AdminTask object to run the configEventServiceSQLServerDB administrative command in batch or interactive mode. The minimum required parameters of the configEventServiceSQLServerDB 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. If you specify a server name, you must also specify a node name.
    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.
    dbServerName
    The server name of the SQL Server database. This parameter is required only if you specified true for the createDB parameter.
    dbHostName
    The host name of the server where the SQL Server database is running.
    dbPassword
    The password to use for the user ID created to own the event database tables (the default user ID is ceiuser). The WebSphere® data source uses this password to authenticate the SQL Server database connection.
    saUser
    A user ID with privileges to create and drop databases and users. This parameter is required only if you specified true for the createDB parameter.
    saPassword
    The password for the specified SA user.

    Other parameters might be required for your environment. For a complete list of parameters and usage information, refer to the help for the configEventServiceSQLServerDB 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/dbscripts/sqlserver 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_sqlserver.html
Copyright IBM Corporation 2005, 2010. All Rights Reserved.
This information center is powered by Eclipse technology (http://www.eclipse.org).