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
- 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.
- On the server system, start the wsadmin tool.
- 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.